Removing a field (OpenInsight 32-Bit)
At 28 AUG 2002 11:11:32AM Rick Todd wrote:
I have the field "tOTAL" in the dictionary of one of my tables. How do I remove it? Can I use DELETE_ROW? And if so what is the syntax?
Thanks
Rick
At 28 AUG 2002 11:16AM Donald Bakke wrote:
Rick,
You can delete it with the Table Builder. But you could also delete it using the DELETE_ROW command line:
RUN DELETE_ROW "DICT.TABLENAME", "TOTAL"
dbakke@srpcs.com
At 29 AUG 2002 11:08AM Rick Todd wrote:
I could never get the Table Builder to remove the field. The Table Builder would always convert the field name to uppercase prior to delete, which prevented it from really deleting. But the DELETE_ROW command worked fine.
Thanks
Rick
At 29 AUG 2002 11:10AM Mike Ruane wrote:
Rick-
Run the command, with correct case-sensitivity, from the exec line in the system monitor.
The system monitor, by default, wil convert all test to upper case. Exec line does not.
Mike
At 29 AUG 2002 12:09PM Donald Bakke wrote:
Ah, I thought "tOTAL" was your misspelling in the post, not in the Table Builder!
dbakke@srpcs.com
At 29 AUG 2002 12:21PM dsig@sigafoos.org wrote:
Not to be one of those RTFM guys (lord knows I ask enough questions) but I find that just typing the command in the editor (not the command line (why can't we do that?) but in a 'page' and f1 .. get the syntax and all options
dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 503-639-4240
OS: Win2k sp2 (5.00.2195)
OI: 4.1 beta (pre 082002)