how to convert a existing database

[Damon Pillinger]

HI all,
Simple question.
RB 5.5.5  Val.fc12

I have a database with a table called FileDataBase and a table called
map, one of the fields is called ali

In the existing database the data is
ALI+++X7+164'

It is the ' which is the problem


INSERT INTO map
(ali,bgm,bsn,cnt1,cnt2,cps,cps1,dtm,loc,name,pac,pac1,qty,rff,uci,unb)
VALUES
('ALI+++X7+164'','BGM+YA5::9+~1~+9'','BSN*00*~1~*~2~*~3~*001','CNT+1:~1~
'','CNT+2:~1~'','CPS+~1~+~2~+1'','CPS+1++5'','DTM+137:~1~~2~:203'','LOC+
8+~1~::92'','Myer Grace
Bros','PAC+~1~++CT'','PAC+1++CT'','QTY+12:~1~:KGM'','RFF+CN:~1~'','UCI+~
1~+~2~:ZZ+~3~:ZZ+7'','UNB+UNOA:3+~1~:ZZ+~2~:ZZ+~3~:~4~+~5~++++1++~6~'')

The above obviously does not work. I have tried 
valentina.escapestring(AllTheAbove,false)

But this then save ALI+++X7+164\'

Please tell me what to do.

Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280