UPDATE or INSERT including apostrophe

[joel009]

Hi,
Trying to use VB6.0sp4 with oracle8 to include an apostrohe in a text string and am unable to do so. Have it working in Access and am trying to convert the application to Oracle. What am I doing wrong. I build a string and use the execute method from the dataenvironment. Can't get the syntax.

Joel

 

[swilliams]

Can you post the code so that I can take a look???

Simon

 

[Snaggs]

Most likely you'll have to put in a double apostrohe to get it to take. For example if your data is O'Mally then you'll have to make it O''Mally. That's not a double quote, it's two single quotes next to each other. Snaggs
tribesaddict@swbell.net

 

[joel009]

Snaggs, Got the same reply from 2 sources and it works, thanks. I wonder why it's not documented better in VB help, or am I just a neophite?

Simmon, from the immediate window.

UPDATE TABLE.COURSES SET TABLE.COURSES.COURSEDESCRIPTION = 'Cathy''s' Where (((TABLE.COURSES.COURSEKEY) = 1))

Thanks again.

Joel

 

[Snaggs]

It wouldn't be as fun if they gave us ALL the pieces to the puzzle, but it'd sure be a lot easier... Snaggs
tribesaddict@swbell.net