what i want is to create a DBS file which drops certain columns and values in columns.
TABLE 1:
table name: CONFIG_NEW
table values to drop: strSomething and strSomething2 (from column C_VARIABLE) (but i need the values in C_VALUE deleted as well)
TABLE 2:
table name: MEMBERS
table columns to drop: M_SOMETHING and M_SOMETHING2
can someone please tell me how to do this?
i tried this:
[DELETE]
CONFIG_NEW
C_VARIABLE = 'strSomething'
C_VARIABLE = 'strSomething2'
[END]
[DELETE]
MEMBERS
M_SOMETHING
M_SOMETHING2
[END]
but that tells me that
-2147467259 | Cannot delete a field that is part of an index or is needed by the system
and
9 | Subscript out of range
-----------------------------
Crash's Site | Email me
Topic Locked
Posted - 03 March 2002 : 17:54:49
