<div>Hi John,</div>
<div> </div>
<div>I tried this too. Well Its strange i once developed the smililar kind of applciation too and it seems to have no issues with this special charractor. But this time i am not sure why. I even checked the query object they all seems to be fine. So i have decided to use link server technique to get it done. I mean i am getting the data from the central sever and moving to regional one.</div>
<div> </div>
<div>So i used like</div>
<div> </div>
<div>insert into x select * from "<a href="http://11.22.22.44">11.22.22.44</a>".db.dbo.x where y=''</div>
<div> </div>
<div>this actually solved my issues. But still i was wondering why my previous dint worked</div>
<div> </div>
<div>for insert into x values('vikas's')</div>
<div> </div>
<div> </div>
<div>Regards</div>
<div>Vikas<br><br> </div>
<div><span class="gmail_quote">On 8/25/08, <b class="gmail_sendername">John@padasy</b> <<a href="mailto:john@padasy.co.nz">john@padasy.co.nz</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-NZ" vlink="purple" link="blue">
<div>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061">Hi Viskas</span></p>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061"> </span></p>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061">Have you tried "Viskas's"?</span></p>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061"> </span></p>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061">John</span></p>
<p><span style="FONT-SIZE: 10pt; COLOR: #244061"> </span></p>
<div style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0mm; BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0mm; BORDER-LEFT: blue 1.5pt solid; PADDING-TOP: 0mm; BORDER-BOTTOM: medium none">
<div>
<div style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0mm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0mm; PADDING-BOTTOM: 0mm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<p><b><span lang="EN-US" style="FONT-SIZE: 10pt">From:</span></b><span lang="EN-US" style="FONT-SIZE: 10pt"> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:delphi-bounces@delphi.org.nz" target="_blank">delphi-bounces@delphi.org.nz</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:delphi-bounces@delphi.org.nz" target="_blank">delphi-bounces@delphi.org.nz</a>] <b>On Behalf Of </b>Vikas...<br>
<b>Sent:</b> Monday, 25 August 2008 6:40 p.m.<br><b>To:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:delphi@delphi.org.nz" target="_blank">delphi@delphi.org.nz</a><br><b>Subject:</b> [DUG] Need help in special charector while inserting in a table</span></p>
</div></div>
<div><span class="e" id="q_11bf8beab4ecdf15_1">
<p> </p>
<div>
<p>Hi</p></div>
<div>
<p> </p></div>
<div>
<p>I am using delphi and sql server 2000. I am facing a issue while inserting a value to a database</p></div>
<div>
<p> </p></div>
<div>
<p>TABLE x</p></div>
<div>
<p> </p></div>
<div>
<p>INSERT INTO X VALUES('VIKAS`S');</p></div>
<div>
<p> </p></div>
<div>
<p>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.</p></div>
<div>
<p> </p></div>
<div>
<p>But when i use the same using delhi tquery execsql. It fails.</p></div>
<div>
<p> </p></div>
<div>
<p>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.</p></div>
<div>
<p> </p></div>
<div>
<p>Regards</p></div>
<div>
<p>Vikas <br clear="all"><br>-- <br> vikas </p></div></span></div></div></div></div><br>_______________________________________________<br>NZ Borland Developers Group - Delphi mailing list<br>Post: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>Unsubscribe: send an email to <a onclick="return top.js.OpenExtLink(window,event,this)" 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