On 30-Jul-07, at 12:10 AM, RB-n00b wrote:
> Hi,
>
> I searched a lot but couldn't find anything useful about prepared
> statements in Realbasic. You know, I mean stuff like"SELECT * FROM
> sometable WHERE id = ?" and then assigning a value to the ? before
> starting the query. I very used to using this approach as other
> languages I'm programming in have support for this. While browsing
> the SqLite homepage I learned that even SqLite supports prepare
> statements thus it should be useable in Realsql-Database as well.
> Basically I don't like the use of this databinder-controls in the GUI
> because it violates the MVC-principle.
>
> Does somebody know more about prepared statements?
None of the DB API's directly support prepared statements.
There's nothing like
prepared_statement_reference = db.Prepare(sql to be used as a
prepared statement)
which you can then do
rs = db.SQLSelect(prepared_statement_reference, parameters)
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|