Board index » delphi » RequestLive=FALSE vs RequestLive=TRUE

RequestLive=FALSE vs RequestLive=TRUE

Anyone,
     Does anyone know why SQL.Add('where AField='JIM''S') returns a row when
RequestLive = FALSE but errors out when RequestLive = TRUE? Note the Double
quote!
 

Re:RequestLive=FALSE vs RequestLive=TRUE


Make sure the SQL's field name's case matches that of table's field name.

Douglas

Quote
Rock wrote in message <6r43eg$f...@forums.borland.com>...
>Anyone,
>     Does anyone know why SQL.Add('where AField='JIM''S') returns a row
when
>RequestLive = FALSE but errors out when RequestLive = TRUE? Note the Double
>quote!

Re:RequestLive=FALSE vs RequestLive=TRUE


Thanks anyway Doug,

The field case matches exactly. You can reproduce this problem with the
Database Explorer by making a query EX. select * from ATable where
AnAlphaField='JIM''S';
try while query is readonly returns OK but when query is Live returns
"Missing right Quote"

Quote
Douglas Macnguyen wrote in message <6r4fls$f...@forums.borland.com>...
>Make sure the SQL's field name's case matches that of table's field name.

>Douglas

>Rock wrote in message <6r43eg$f...@forums.borland.com>...
>>Anyone,
>>     Does anyone know why SQL.Add('where AField='JIM''S') returns a row
>when
>>RequestLive = FALSE but errors out when RequestLive = TRUE? Note the
Double
>>quote!

Other Threads