General information
Category:
Coding, syntax & commands
Thanks - that certainly was simple enough!!!!
Gaylen
>See SET AUTOINCERROR Command.
>
>>In trying to move some test data from production to test I tried to use "append from production". I am using an autoincrement field for id and it doesn't like the "append from" saying it is read only.
>>
>>I know I can scan the table and drop the values each field or can use SQL "insert into test(field1,field2) select field1,field2 from production) " but both require a listing of fields. Since this is a table with many many fields, is there a simplier way to move the data between tables with auto increment fields.
>>
>>
>>Thanks
>>Gaylen
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only