[V4MD] 2.0b MAC - LIKE problem on a VarChar field

[Ruslan Zasukhin]

On 1/11/05 12:38 PM, "Hans-Joerg Bibiko" <bibiko at eva.mpg.de> wrote:

> Hi Ruslan,
> 
> I copied the folder like you mentioned. OK
> 
> Problem:
> 
> gDB.SQLSelect("select * name,code from language where name = 'German'")
> OK
> 
> gDB.SQLSelect("select * name,code from language where name LIKE 'German'")
> OK but it finds only one record but I have 17 names beginning with 'German'
> 
> gDB.SQLSelect("select * name,code from language where name like 'german'
> no_case")
> SQLError: token 'german' couldn't parsed

2.0 do not have key word no_case....at least now


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------