Thanks Ed I take it then , that I should be updating/inserting from a common place ie BizObject which should then check for this abhoration?
Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program Ed Leafe wrote: > On Sep 4, 2007, at 9:04 AM, Andrew Stirling wrote: > >> Just starting to play around with mysql >> if I send >> ? sqlexec(lnhandle, [update COMPDET SET lydata = 'C:\calcpay\pay' >> where >> cname= 'Stirling Clan' ]) >> When I then look at the data I find 'C:calcpaypay' >> Why & what can I do about it? > > Ah, you've run into that amazing Microsoft "innovation": using the > universal escape symbol as its directory separator. All the rest of > the world uses '/', but Bill in his Infinite Wisdom couldn't resist > "innovating" and used the backslash instead. > > The solution, praise to Bill, is to escape the backslash itself with > another backslash. IOW: > > sqlexec(lnhandle, [update COMPDET SET lydata = 'C:\\calcpay\\pay' > where > cname= 'Stirling Clan' ]) > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
