In this article there is some functions that maybe can help you
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q178070
Regards
Zlatko Talic
----- Original Message -----
From: Corey W. Gibbs <cgibbs@westmarkproducts.com>
To: <pgsql-odbc@postgresql.org>
Sent: Wednesday, March 13, 2002 7:14 PM
Subject: [ODBC] Maybe more of a VB question, but here goes
> Good Morning Everyone,
>
> I'm having a bit of a VB problem, and I don't know quite how to solve this
> as my VB knowledge is minimal at best. The problem is with quotes and
> apostrophes in variables. What I'm doing is pulling some really really
> really bad data from an Access database and trying to insert it into my
> handy dandy Postgres db.
>
> Here's the insert statement:
> pg_cn.Execute "INSERT into
> itemlist(jobno,area,floor,building,room,elevation,phase,cycle,model,w,h,
> d,itemno," & _
> "finish,mtostatus) values('" & rs!jobno & "','" & rs!area & "','" &
> rs!floor & "','" & rs!building & "','" & _
> rs!room & "','" & rs!elevation & "','" & rs!phase & "','" & rs!cycle &
> "','" & rs!model & "','" & rs!w & "','" & rs!h & "','" & _
> rs!d & "','" & rs!itemno & "','" & rs!finish & "','" & rs!mtostatus &
> "')"
>
> rs is an adodb recordset
>
> Now, if rs!d="7'" (I said it was bad data ;)) that tickmark throws off the
> whole insert statement. as they're interpreted as the genuine ticks. Has
> anyone come across this or can anyone point me in the right direction to
> solve this problem short of removing the users "-' key?
>
> thanks in advance
> corey
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>