Please free me from this - I'll PAY
Bastiaan Olij
bastiaan at basenlily.me
Tue Jan 30 20:29:02 EST 2018
Hey Das,
> I can’t insert my sql into a calculate command…it won’t let me quote it with either type of quote because there’s quotes inside the SQL
Well you still would use bind variables in that command but for future
reference, if you need to include a literal string into your SQL string,
just use two single quotes so:
Calculate lvSQL as 'select * from mytable where column1 = ''Hello
World'' order by column2'
Cheers,
Bas
More information about the omnisdev-en
mailing list