V4RB b9 uploaded

[Ruslan Zasukhin]

On 7/22/04 8:32 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> Jon,
> 
> * Now I can open close pref db many times.
> * I can create new main db
> * I can open close main db many times
> * I can add record into main db and navigate them
> * I can open db and records here.
> 
> There was fail of SQL query on exception when I have try to make find.
> So we need check this.

I have found that problem is caused by left() function

-----------------------------------------------
line 1:41: unexpected token: (
line 1:42: expecting ')', found 'left'
line 1:56: expecting ')', found ','
line 1:59: unexpected token: )
<AST>: unexpected AST node: <ASTNULL>
<AST>: unexpected AST node: <ASTNULL>
select id,hit from thereferences where ((left(allFields, 1) = 'PETER'))
order by id
Select
    QuerySelect
        1 (  mAll )
        SelectList
            SelectList_Elem_Expr
                id
            SelectList_Elem_Expr
                hit
        TableExpr
            Table_NonJoin_Table
                thereferences
Select
    QueryTableRef
        Table_NonJoin_Table
            id
-----------------------------------------------


So we will start work in this area now.

    searches on strings.


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