Rohit > I did Neven, but Vikas is a tad confused himself saying that the > accent worked but not the quote. :-) I *think* he said a double apostrophe worked but not a single one, as you say Vikas' question was a bit of an enigma
Good to know you are not yet blind :-) Neven > > Neven MacEwan wrote: >> Rohit >> >> I think if you look closely its an apostrophe not a single quote >> >> Vikas, What Query Class are you using >> >> Neven >> >>> 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 >> >> __________ Information from ESET NOD32 Antivirus, version of virus signature >> database 3385 (20080825) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.eset.com >> >> >> > > -- > *Rohit Gupta* > * B.E. Elec. M.E. Mem IEEE Associate IEE* > *Technical Manager* > *Computer Fanatics Limited* > ** > *Tel* +64 9 4892280 > *Fax* +64 9 4892290 > *Email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>** > *Web *www.cfl.co.nz <http://www.cfl.co.nz/> > > ------------------------------------------------------------------------ > This email and any attachments contain information, which is > confidential and may be subject to legal privilege and copyright. If > you are not the intended recipient, you must not use, distribute or > copy this email or attachments. If you have received this in error, > please notify us immediately by return email and then delete this > email and any attachments. > ------------------------------------------------------------------------ > > _______________________________________________ > 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