Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index & cursoradapter
Message
From
18/07/2003 19:40:46
 
 
To
18/07/2003 16:53:13
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00811669
Message ID:
00811723
Views:
14
Thanks for the input. I did create a structural index. My cursor is record buffered. I make a change in a record and I start a transaction to save it: this is when I get error 1548.

>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform