Re: Prepared SQL in 4GL

In article <jlumbleyDEyG5G.BFt@netcom.com> jlumbley@netcom.com "Joe Lumbley" writes: > ryeardly@eurobrok.co.uk wrote: > : I hope someone can help. In a 4GL program is it quicker to prepare > : a piece of SQL and then execute it, rather than just embedd the SQL > Generally, it is best to prepare and execute statements that get executed > multiple times. Perfect example is something that is deep inside a program [Perfectly true stuff snipped] IMHO, however, I think it's a good idea to write all your code using PREPAREd cursors for consistency. Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!