Since you are constructing an SQL SELECT command, you should be more
concerned with SQL syntax than RealBasic syntax for the content of
the SELECT command.
Which means you should be aware of the SQL value called NULL.
e.g. "SELECT StringA, StringB from TABLE1 where StringB = NULL"
Which brings up another point, of course:
You should be specifying the fields you want to retrieve, in the
order you want them, rather than using the asterisk (*).
The asterisk not only will retrieve all the fields, which may be more
than you want, but it does not specify their order - which can cause
maintenance problems later on.
Hope that helps.
Russ
On Jan 3, 2006, at 8:05 AM, Hector Schisa wrote:
How does one search a realSQLdatabase for an empty string as in
recordset = db.sqlselect("select * from table where string = ....")
two single quotes mean a literal single quote; and I've tried other
things with no luck.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
