Trevor Devore's DB Library is an abstraction layer that makes doing
SQL in Rev very manageable. You'll never have to touch 'INSERT', for
instance as he has written a handler to do the inserts from an array.
http://mangomultimedia.com/developer/revolution/
I use it every day. Free, but Trevor appreciates the paypal donation.
After I started using the library, it all made sense.
sqb
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
--
stephen barncard
s a n f r a n c i s c o
- - - - - - - - - - - -
_______________________________________________
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
