<div>Hi</div>
<div> </div>
<div>Well yes the double one worked like i said before if i type 'vikas``s' this goes pretty well. But on the other hand if i type 'vIKAS`s ' it failed.</div>
<div> </div>
<div>Anyways like i said i used link server to fix this issue Since it was crucial bug comming at client side and my cleint cant even afford to wait for </div>
<div> </div>
<div>3 hour it was production bug.</div>
<div> </div>
<div>But I will check out with quotestr.</div>
<div> </div>
<div>I am using Delphi 5 and SQL server 2000.</div>
<div> </div>
<div>Thanks again for all your help again.</div>
<div> </div>
<div>Really appreciate all of ur time</div>
<div> </div>
<div>Regards</div>
<div>Vikas Vasudev </div>
<div>Solution Consultant</div>
<div>National cash register</div>
<div>USA</div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 8/26/08, <b class="gmail_sendername">Neven MacEwan</b> <<a href="mailto:neven@mwk.co.nz">neven@mwk.co.nz</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Rohit<br>> I did Neven, but Vikas is a tad confused himself saying that the<br>> accent worked but not the quote. :-)<br>
I *think* he said a double apostrophe worked but not a single one, as<br>you say Vikas' question was a bit of an enigma<br><br>Good to know you are not yet blind :-)<br><br>Neven<br>><br>> Neven MacEwan wrote:<br>
>> Rohit<br>>><br>>> I think if you look closely its an apostrophe not a single quote<br>>><br>>> Vikas, What Query Class are you using<br>>><br>>> Neven<br>>><br>>>> try<br>
>>><br>>>> INSERT INTO X VALUES('VIKAS''S');<br>>>><br>>>> Vikas... wrote:<br>>>><br>>>><br>>>>> Hi<br>>>>><br>>>>> I am using delphi and sql server 2000. I am facing a issue while<br>
>>>> inserting a value to a database<br>>>>><br>>>>> TABLE x<br>>>>><br>>>>> INSERT INTO X VALUES('VIKAS`S');<br>>>>><br>>>>> this statement fails. If you see the above query there is a ` value in<br>
>>>> the string. When i fire this query in query analyser it goes well.<br>>>>><br>>>>> But when i use the same using delhi tquery execsql. It fails.<br>>>>><br>>>>> I tried D``costa for example than D`costa it works. But this changes<br>
>>>> the name completely. So any ideas how to handle (`) this one.<br>>>>><br>>>>> Regards<br>>>>> Vikas<br>>>>><br>>>>> --<br>>>>> vikas<br>
>>>> ------------------------------------------------------------------------<br>>>>><br>>>>> _______________________________________________<br>>>>> NZ Borland Developers Group - Delphi mailing list<br>
>>>> Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>>>>> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>>>>> Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
>>>><br>>>>><br>>>>> __________ Information from ESET NOD32 Antivirus, version of virus signature database 3383 (20080824) __________<br>>>>><br>>>>> The message was checked by ESET NOD32 Antivirus.<br>
>>>><br>>>>> <a href="http://www.eset.com">http://www.eset.com</a><br>>>>><br>>>>><br>>>>><br>>>> _______________________________________________<br>>>> NZ Borland Developers Group - Delphi mailing list<br>
>>> Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>>>> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>>>> Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
>>><br>>>><br>>>><br>>>><br>>><br>>> _______________________________________________<br>>> NZ Borland Developers Group - Delphi mailing list<br>>> Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
>> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>>> Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
>><br>>> __________ Information from ESET NOD32 Antivirus, version of virus signature database 3385 (20080825) __________<br>>><br>>> The message was checked by ESET NOD32 Antivirus.<br>>><br>
>> <a href="http://www.eset.com">http://www.eset.com</a><br>>><br>>><br>>><br>><br>> --<br>> *Rohit Gupta*<br>> * B.E. Elec. M.E. Mem IEEE Associate IEE*<br>> *Technical Manager*<br>
> *Computer Fanatics Limited*<br>> **<br>> *Tel* +64 9 4892280<br>> *Fax* +64 9 4892290<br>> *Email *<a href="mailto:rohit@cfl.co.nz">rohit@cfl.co.nz</a> <mailto:<a href="mailto:rohit@cfl.co.nz">rohit@cfl.co.nz</a>>**<br>
> *Web *<a href="http://www.cfl.co.nz">www.cfl.co.nz</a> <<a href="http://www.cfl.co.nz/">http://www.cfl.co.nz/</a>><br>><br>> ------------------------------------------------------------------------<br>
> This email and any attachments contain information, which is<br>> confidential and may be subject to legal privilege and copyright. If<br>> you are not the intended recipient, you must not use, distribute or<br>
> copy this email or attachments. If you have received this in error,<br>> please notify us immediately by return email and then delete this<br>> email and any attachments.<br>> ------------------------------------------------------------------------<br>
><br>> _______________________________________________<br>> NZ Borland Developers Group - Delphi mailing list<br>> Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
> Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br><br>_______________________________________________<br>NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
</blockquote></div><br><br clear="all"><br>-- <br> vikas