sql update statement
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>
> 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
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