Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index & cursoradapter
Message
De
18/07/2003 19:40:46
 
 
À
18/07/2003 16:53:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00811669
Message ID:
00811723
Vues:
15
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform