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

[Vikas...]

Hi

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.

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

3 hour it was production bug.

But I will check out with quotestr.

I am using Delphi 5 and SQL server 2000.

Thanks again for all your help again.

Really appreciate all of ur time

Regards
Vikas Vasudev
Solution Consultant
National cash register
USA




On 8/26/08, Neven MacEwan <neven at mwk.co.nz> wrote:
>
> 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 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
> >>>>
> >>>>
> >>>> __________ 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 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
> >>>
> >>>
> >>>
> >>>
> >>
> >> _______________________________________________
> >> 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
> >>
> >> __________ 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  *rohit at cfl.co.nz <mailto:rohit at cfl.co.nz>**
> > *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 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
>
> _______________________________________________
> 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/20080826/4762bacf/attachment.html