[DUG] Need help in special charector while inserting in a table

[Vikas...]

Hi John,

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.

So i used like

insert into x select * from "11.22.22.44".db.dbo.x where y=''

this actually solved my issues. But still i was wondering why my previous
dint worked

for insert into x values('vikas's')


Regards
Vikas


On 8/25/08, John at padasy <john at padasy.co.nz> wrote:
>
>  Hi Viskas
>
>
>
> Have you tried "Viskas's"?
>
>
>
> John
>
>
>
> *From:* delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]
> *On Behalf Of *Vikas...
> *Sent:* Monday, 25 August 2008 6:40 p.m.
> *To:* delphi at delphi.org.nz
> *Subject:* [DUG] Need help in special charector while inserting in a table
>
>
>
> 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 at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> unsubscribe
>



-- 
  vikas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080825/560ecef6/attachment.html