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