sql execution

[Stephen Barncard]

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
- - -  - - - - - - - - -