using temporary field exception

[Ruslan Zasukhin]

On 3/2/05 2:21 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I'm getting an exception when I create and use a temporary field in a cursor:

I think you mean in the table ?
 
> dim fld as VVarChar
> 
>   fld = 
> myDatabase.myReferences.createVarCharField("authorEditorSortMethod",
> 2000, EVFlag.fNone, "IFNULL(authors, IFNULL(editors,title))")
> 
> s = "select *,authorEditorSortMethod from thereferences where hit>0
> ORDER BY authorEditorSortMethod,thedate"
> 
> myCursor = myDatabase.SQLSelect(s, EVCursorLocation.kServerSide,
> EVLockType.kReadOnly)
> 
> The error is: Field "60" does not exist.
 
> fld is created, and seems to be OK.
> 
> Anything I'm doing wrong? Or bug?

Try simple query at first

    select authorEditorSortMethod from thereferences


Jon, in 2.0 you can do what you want using SQL itself:

    select *, IFNULL(authors, IFNULL(editors,title)) as 'ff'
    from thereferences
    where hit > 0 
    ORDER BY ff, thedate

Please try this also


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