qry in retrieving column from Access

[srivalli]

hello
i am trying to retrieve one table from MS Access,in which there are many columns.
One of the column datatype is nvarchar and the data in that column is
" HYD'BAD".

generally in command string , we ll read text as '" & aaa & "'
(aaa is the data ,which is declared as varchar)

but when i am trying to retrieve HYD'BAD
then the string is read as 'HYD'BAD' and the error is displayed as Quoted string not ended
so any suggestions
thanks

 

[jelo]

Hi

this is because the Quote inside the string is closing the begining quotes n the last quote needs an another quote to be closed that is why u r gettin this error. U can get rid of this simply by removin the quote from ur string that is hyd'bad can be changed to hydbad.

 

[srivalli]

thanks
but i cant remove or modify the data ,i can only read it and display it in the data base.
thanks

Hi

this is because the Quote inside the string is closing the begining quotes n the last quote needs an another quote to be closed that is why u r gettin this error. U can get rid of this simply by removin the quote from ur string that is hyd'bad can be changed to hydbad.