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