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

[Neven MacEwan]

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