Icon View Thread

The following is the text of the current message along with any replies.
Messages 21 to 22 of 22 total
Thread SQL scripts
Mon, Jan 8 2007 4:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

One thing you may want to consider with the code that you posted is just
converting it to using single SQL statements that are fired off one by one.
Instead of building one large script, just build individual statements and
execute them instead.  DBISAM 4 essentially did exactly that under the
covers - it simply parsed out each SQL statement and fired it off to the
engine or remote database server.  IOW, it was all client-side and simply a
way of executing a series of SQL statements in one shot, no branching,
looping, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jan 8 2007 7:12 PMPermanent Link

"Ole Willy Tuv"
Tim,

<< As indicated to Adam, dynamic SQL scripts in EDB are exactly like SPs
without the parameters or naming.  That's the only difference between the
two, so if you can't use an SP then you won't be able to use dynamic scripts
either. >>

OK, I think I'm getting the picture.

Ole Willy Tuv

« Previous PagePage 3 of 3
Jump to Page:  1 2 3
Image