>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 
*INDEX ON f1 TO testindex && <============= causes BEGIN TRANSACTION to fail

LOCAL oEx as Exception 

TRY
BEGIN TRANSACTION
LIST
END TRANSACTION 
CATCH TO oEX
	? oEx.ErrorNo, oEx.Message 
ENDTRY

Thanks,
Aleksey.