sql update statement
stephenREVOLUTION at barncard.com
Sat Sep 30 23:55:52 CDT 2006
you need to concatenate lines with the \ or ¬ character.
I still prefer the ¬ (option l on macs) char myself
Also you have ' quotes surrounding " quotes. Rev
doesn't work like PHP in that regard, it can only
quote to one level.
also global, script local and local variables can
be initialized by another variable, a literal
number or text string, but it can't be
initialized to a calculation on the right side of
the =. Also there's no typing in Rev.
so you would do
local builtString = ""
fld "2srd3" & comma & fld "2srd4" & comma & \
fld "2srd5" & comma & fld "2srd6" & comma & \
fld "2srd7" & comma & fld "2srd8" & comma & \
fld "srideht" & comma & fld "smisccomment" into builtString
to make a comma delimited string from a bunch of fields.
I actually like to put the names of the fields in
a list and store data in an array. using rev's
etc. Arrays can also be made using commas, tabs
or any delimiter. Lines in a list can be an array.
Building complex SQL statements can be done
easily in Rev, just perhaps not the way you're
Here's a simple SQL string:
SELECT * FROM `Contractors` ORDER BY `id` DESC
this is how you could put this into a variable for direct use as a SQL call.
put "SELECT * FROM `Contractors` ORDER BY `id` DESC" into tLocalVariable
if you needed to use it with vars for FROM and ORDER BY
use the words Contractors and ID as a placeholder
you could change them with replace this way
replace "Contractors" with "Installers" in tLocalVariable
replace "id" with "date" in tLocalVariable
you could also write a routine to replace the *
with a list of fields to display. A short handler
could be written to surround each field with a '
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
by using groups, a handler could determine all
grouped field names (which are designed to match
the database fields), then create an array of all
the data in the fields.
This is pretty heady stuff, MYSQL, to get into
with your first app. Perhaps you should try
something a little simpler to goof around with
to understand the 'Rev' way...
But don't get discouraged!
>I have a sql update statement that has several hundred items in it, is it
>possible to leave it in list format like this
>2srd3 = '"& fld "2srd3" &"',
>2srd4 = '"& fld "2srd4" &"',
>2srd5 = '"& fld "2srd5" &"',
>srideht = '"& fld "srideht" &"',
>smisccomment = '"& fld "smisccomment" &"',
>and not like this
> 2srd3 = '"& fld "2srd3" &"', 2srd4 = '"& fld "2srd4" &"', 2srd5 = '"& fld
>"2srd5" &"', srideht = '"& fld "srideht" &"', smisccomment = '"& fld
>why you might ask do I want to do this, well once I get out quit a ways on
>one line rev seems to not like it and starts to give me problems run slow,
>and not want to copy and paste
>I tried the above list format but it does not like the returns after each
>comma, what can I do to correct this?
s a n f r a n c i s c o
- - - - - - - - - - - -
More information about the use-livecode