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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi Viskas
>
>
>
> Have you tried "Viskas's"?
>
>
>
> John
>
>
>
> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> *On Behalf Of *Vikas...
> *Sent:* Monday, 25 August 2008 6:40 p.m.
> *To:* delphi@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@delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
> unsubscribe
>
--
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
