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>
wrote:

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
http://www.paradigmasoft.com

[I feel the need: the need for speed]





More information about the Use-livecode mailing list