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

[Neven MacEwan]

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
>
>
>