I have successfully used revdb_execute() to create tables and index
them. Now I want to insert records but am having difficulty. I try to
send the following syntax:
insert into VP2000.APACCT99 values ('','11010-','System Checking
Account','21010-','20010-',' 10104','19990620','')
I get an error saying "Commands out of sync; You can't run this
command now" but I can paste the same syntax into an SQL utility
program and it works.
I am at a loss to understand how this works. Do I need to create a
cursor first? What if I want to insert all new records at the end of
the tables? I think what I need is a pre-defined methodology for
doing basic SQL stuff. I have perused the help stack and I simply
cannot determine what I am expected to do.
Thanks for any help. I will be attending the conference and so hope
to learn a lot there.
Bob Sneidar
IT Manager
Logos Management
Calvary Chapel CM
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
