Re: can't update 'c:\windows'

Guard,

First, this kind of beginner question is more appropriate for the NOVICE
list.

> IF update table set field='c:\windows'
> but
>
> c:\windows -> c:windows

That's because "\" is the Unix escape character. If I were to want to
save "O'Reilly", for example, I could:
UPDATE table SET name = 'O\'Reilly';

Since you want to save an actual backslash, do this:

UPDATE table SET field = 'C:\\windows';

In your interface code, you may which to add a function that doubles
your backslashes.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco