Not sure what Delphi version you are using, but using Rohits example I would
wrap it with QuotedStr() like this
INSERT INTO X VALUES(QuotedStr('VIKAS`S'));
OR INSERT INTO X VALUES(QuotedStr('VIKAS'+#180+'S'));
The latter might not bea good idea, but maybe wrappign it with QuotedStr()
will work.
Jeremy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Rohit Gupta
Sent: 26 August 2008 01:59
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Need help in special charector while inserting in a table
try
INSERT INTO X VALUES('VIKAS''S');
Vikas... wrote:
> 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
> ----------------------------------------------------------------------
> --
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi@delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to [EMAIL PROTECTED] with
> Subject: unsubscribe
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 3383 (20080824) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
