[V4RB] [CARBON] Unexpected quit when using LIKE

[Andy Fuchs]

Update:

It seems that the db somehow got corrupted! When re-creating the db and
trying the same thing it worked!

Although RegEx-grouping seems not to work:

RegExpressions like '^B' or '^[ABC]' seems to do nothing. Is this expected?


SELECT Name FROM Person where Name NOT LIKE  'bbe'

returns Error 609 (Wrong field type)

Best

Andy

BTW: Only 20% of my posts come through the list!! :-{


> Hi Ruslan,
> 
> RB (4.0.3) unexpectedly quits when I use a LIKE - search:
> 
> ie. SELECT Title FROM myTABLE WHERE Title LIKE "Hi"
> 
> Everything works fine and I get a valid cursor, but when I try to access the
> properties of the cursor RB quits immediately.
> 
> sqlString = "SELECT Title FROM MAIN WHERE Title LIKE 'Hello'"
> 
> v_vCursor = db.SQLSelect(sqlString)
> 
> if (v_vCursor <> nil) then
>   n = v_vCursor.RecordCount  // <- CRASHES HERE
> end if
> 
> ?
> 
> -- Andy Fuchs
> -- silent movie media
> -- mailto:andy at foxwerk.de
> -- http://www.silent-movie-media.com