By John L Griffiths

Summary: If you use MS-SQL with your Clarion programs, and you write your own SQL statements, then you've probably run into problems with quote characters. SQL statements use quote characters to delimit streams, and if you have quotes inside your strings you need to double them up so MS-SQL doesn't treat them as the end of the string. This article by John Griffiths will show you a few quoting tricks, and will also provide you with a handy function - SingleQuoteDoubler()

Please log on to read this subscriber-only article. If you do not have a subscription you can purchase one in the ClarionMag store.