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 <[EMAIL PROTECTED]> 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@delphi.org.nz
> >>>> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> >>>> Unsubscribe: send an email to [EMAIL PROTECTED] 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@delphi.org.nz
> >>> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> >>> Unsubscribe: send an email to [EMAIL PROTECTED] with
> Subject: unsubscribe
> >>>
> >>>
> >>>
> >>>
> >>
> >> _______________________________________________
> >> 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
> >>
> >> __________ 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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>**
> > *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@delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
> unsubscribe
>
> _______________________________________________
> 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
