[DUG] Need help in special charector while inserting in a table

[John@padasy]

Hi Viskas

 

Have you tried "Viskas's"?

 

John

 

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On
Behalf Of Vikas...
Sent: Monday, 25 August 2008 6:40 p.m.
To: delphi at delphi.org.nz
Subject: [DUG] Need help in special charector while inserting in a table

 

Hi

 

I am using delphi and sql server 2000. I am facing a issue while inserting a
value to a database

 

TABLE x

 

INSERT INTO X VALUES('VIKAS`S');

 

this statement fails. If you see the above query there is a ` value in the
string. When i fire this query in query analyser it goes well.

 

But when i use the same using delhi tquery execsql. It fails.

 

I tried D``costa for example than D`costa it works. But this changes the
name completely. So any ideas how to handle (`) this one.

 

Regards

Vikas 

-- 
  vikas 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080825/4ba7b62d/attachment.html