Complex String for Insert.

I'm trying to insert the following 'complex' string into a table:

datawindow.detail.height=679 #nxtmd# text_triggers_list.text='' #nxtmd# text_actions_list.text='' #nxtmd#

With the following.

INSERT INTO obj_syntax VALUES (34453,
1,
'datawindow.detail.height=679 #nxtmd# text_triggers_list.text=''
#nxtmd# text_actions_list.text='' #nxtmd#',
'oper');

Of course this produces a few errors. I CAN get it to work with the following.

INSERT INTO obj_syntax VALUES (34453,
1,
'datawindow.detail.height=679 #nxtmd# text_triggers_list.text=''''
#nxtmd# text_actions_list.text='''' #nxtmd#',
'oper');

But that needs some manual changes.
One of the other inserts I have to deal with is as followings, and again I have to manually add the extra quote.

13 nofparallel_t.height='68' nofparallel_t.text=''Number of Parallel processes:'' nofparallel_t.width='699' nofparallel_t.x='41' nofparallel_t.y='556'

How would I go about inserting the whole string into ONE field.

Thanks Folks. Received on Tue Jan 08 2002 - 15:33:39 CET