Conceptual database questions...

Robert Brenstein rjb at robelko.com
Thu May 26 12:19:14 EDT 2005


>But, don't those techniques require a cursor reference, which requires
>use of SQL select?

Of course. How else would Valentina know where to insert the new 
record? You provide the same SQL query, so do speak, when using SQL 
method.

I guess what you really refer to is that with SQL approach, you have 
a single line that does the job whereas with direct API you have 
several lines since you need to handle the cursor yourself. Yes, for 
simple scenerios, SQL is more compact and simpler. But then you can 
also write your own function using direct API that is called in a 
manner parallel to SQLexecute. As I said, use whatever suits you 
better.

Robert


More information about the Use-livecode mailing list