>Since moving to Foxpro 8.0 from 6.0 we getting a strange error about once every month or two. The error occurs on the [Seek 'b'] command and the error message says 'Record not locked'. While its true that the record is not locked, the fact is there is no need for it to be locked at this point =)
>
>There are no relationships established. The program does not use record or table buffering. For the life of me I can't figure out what is going wrong.
>I would appreciate any ideas anyone has about what might be causing this.
>
>
priv m.tempz,savefilt
>set exac off
>store filter() to savefilt
>set filt to
>m.tempz=order()
>set order to tag blank
>seek 'b'
>
>
>Currently Selected Table:
>Select area: 1, Table in Use: J:\ACW\CUSTOMER.DBF Alias: CU
> Code page: 1252
> Structural CDX file: J:\ACW\CUSTOMER.CDX
> Index tag: CUST_NUM Collate: Machine Key: CUST_NUM
> Master Index tag: BLANK Collate: Machine Key: BLANK
> Index tag: REF Collate: Machine Key: REF
> Index tag: ZIP Collate: Machine Key: ZIP
> Index tag: PHONE Collate: Machine Key: PHONE
> Index tag: CUSTOMER Collate: Machine Key: CUSTOMER
> Memo file: J:\CARPET2\CUSTOMER.FPT
> Lock(s): <none>
>
Eddie,
This is a SWAG, but I'd think it would have something to do with the field/tag named: BLANK. This is a keyword and it's not a good idea to use keywords as fields or memory variables.
I'll give you an example of this and what can happen, if you like.
George
Ubi caritas et amor, deus ibi est