using temporary field exception

jda jda at his.com
Wed Mar 2 07:21:14 CST 2005


Hi Ruslan,

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

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?

Thanks,

Jon


More information about the Valentina-beta mailing list