database write error

[Mark Smith]

Hi, I have some code that works fine until I put an apostrophe into a field
and then it errors out on storing the data. Any suggestions on dealing with
this problem?

The code I am using looks like this:

put "INSERT INTO master (delivery_date, mothers_name, mothers_phin,
mothers_mhsc, mothers_dob, care_provider, note)" & \
merge("VALUES ('[[globaldate]]', '[[tmaternalname]]', '[[tmaternalphin]]',
'[[tmaternalmhsc]]', " & \
           "'[[tmaternaldob]]', [[tcareprovider]]', '[[tnote]]')") into tCmd
revExecuteSQL gConnectID, tCmd

Thanks
-- Mark


--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/database-write-error-tp4343759p4343759.html
Sent from the Revolution - User mailing list archive at Nabble.com.