microsoft.public.dotnet.framework.odbcnet

Cliffe Hodgkinson

9/17/2002 6:05:00 PM

You should be able to escape the apostrophe by using two of them in a row "D
' ' Huez."

Cliffe Hodgkinson
Nichirin Inc.

"Scott Rassbach" <scottrassbach@go.com> wrote in message
news:d0273969.0209160812.5786438b@posting.google.com...
> I have a description that has an apostrophe in it. ("D'Huez"). I'm
> using an insert statement for an AS400 ODBC connection like this:
>
> dim sA7ITEMDES as string = "D'Huez"
> dim sInsertString as string = "INSERT INTO myPartition.Mytable(
> A7ITEMDES ) VALUES ('" & sA7ITEMDES & "')"
>
> MyConnection.connectionstring = sMyConnectionString
> MyCommand.connection = myconnection
> MyCommand.commandtext = sInsertSTring
> MyConnection.open
> MyCommand.executeNonQuery
> MyConnection.close
>
> It gives me this exception:
>
> Microsoft.Data.Odbc.OdbcException: ERROR [42000] [IBM][Client Access
> Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0104 - Token HUEZ was not
> valid. Valid tokens: + ) -.
> at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle,
> SQL_HANDLE hType, RETCODE retcode)
> at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
> behavior, String method)
> at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
> at TestAppleClasses.DataClass.TestInsert() in C:\Documents and
> Settings\srassbach\My
> Documents\Projects\TestAppleClasses\DataClass.vb:line
>
> I'm assuming that there is an escape character for the AS400 to make
> it accept apostrophes in string fields. I'm not an AS400 guru. Can
> anyone help me with this?