sql update statement

Ruslan Zasukhin sunshine at public.kherson.ua
Sun Oct 1 03:22:52 EDT 2006

On 10/1/06 7:55 AM, "Stephen Barncard" <stephenREVOLUTION at barncard.com>

Hi Stephen,

> SELECT  * FROM `Contractors` ORDER BY `id` DESC

Why you use here single quotes ?

SQL92 expect here double quotes.
Single quotes should be used for string constants only.

Yes I know that mySQL can eat any quotes on any place,
But this comes from the past, and it is always good idea follow to standard.

> This also could be done with in-line variables or
> fields contents, but a little trickier.
> put "SELECT" && fld "fieldlist" && "FROM" && "'"
> & label of btn "tableSelect" & "'"\
>      &&   "ORDER BY" && "'" & (label of btn
> "tableORderby") & "'" & "DESC" into tSQL

Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information

[I feel the need: the need for speed]

More information about the use-livecode mailing list