>Hi,
>
>I index the cursor generated by a cursoradapter. Apparently the index generated is non strutural and I get error 1548 when starting a transaction... Anyone seen this? Any solution?
>
>Thanks,
>
>Thierry Labarre
Hi Thierry,
Just create a structural index:
clear
CREATE TABLE testCA (f1 I)
INSERT INTO TestCA values(1)
INSERT INTO TestCA values(2)
INSERT INTO TestCA values(3)
oCA=CREATEOBJECT("CursorAdapter")
oCA.DataSourceType="NATIVE"
oCA.SelectCmd="select * from TestCA"
?oCA.CursorFill()
SELECT (oCA.Alias)
INDEX ON f1 TAG f1
LOCAL oEx as Exception
TRY
BEGIN TRANSACTION
LIST
END TRANSACTION
CATCH TO oEX
? oEx.ErrorNo, oEx.Message
ENDTRY
Thanks,
Aleksey.