database write error
Mark_Smith at cpe.umanitoba.ca
Tue Jan 31 14:22:27 CST 2012
Peter Haworth-2 wrote
> If you use single quotes, double quotes don't need to be escaped in the
> literal, and vice versa. So, if you're sure that your data won't contain
> double quotes, then you can use double quotes to enclose the literals and
> single quotes won't cause a problem.
Thanks for the suggestion Pete. I was going to try that but the relevant
code section reads as follows
merge("VALUES ('[[globaldate]]', '[[tmaternalname]]', '[[tmaternalphin]]',
'[[tmaternalmhsc]]', '[[tmaternaldob]]', '[[tmaternalage]]',
'[[tmaternalpc]]', '[[tmaternaled]]'," & \
"'[[tmaternalocc]]', '[[tmaternalage]]', '[[tsite]]',
'[[tmaternalchart]]', '[[tcareprovider1]]', '[[tcareprovider2]]',
'[[tcareprovider3]]', '[[tnote]]')") into tCmd
Wouldn't replacing the single quotes with double quotes mess up the merge
command (ie. it would not know where the string beings/ends??) Or can you
replace the "outer" quotes with single quotes as well?
View this message in context: http://runtime-revolution.278305.n4.nabble.com/database-write-error-tp4343759p4345754.html
Sent from the Revolution - User mailing list archive at Nabble.com.
More information about the use-livecode