Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error # 1548 ?????
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00191636
Message ID:
00192010
Views:
43
Jose,

>I have a "Clients" maintenance form that has 3 pages in a pageframe. The first one is a list of clients (cBizObjMaintenanceForm), the second one is a detail of the "Clients" data and in the third one I have a cListObjEdit object that lists all the "Attentions" of a "Client". In the corresponding cListObjEditForm I have the "Attentions" data (name, department, etc...) and 3 cListObjEdit objects to store "Attentions" "Telephones", "Faxes" and "Emails". One of the "Attentions" fields is a pre-name treatment (like Mr.) and a post-name treatment (like PHD) that are selected by comboboxes based on a View.
>The problem is that when the Views are indexed I receive the error 1548 and when the Views are not indexed everything works fine.
>The error occurs when I insert a new "Attention" and after saving the new record I try to edit it.
>
>The error message is :
>
>Table "alias" has one or more non-structural indexes open. Please close them and retry the Begin Transaction (Error 1548)>

I've seen this before when you have multiple views that share the same source table. It seems to be a Visual FoxPro "issue"...is this the case in your scenario?

As an aside, I identified a problem with the Framework earlier this week that you may want to try...although it will probably not address the problem you're experiencing. Here it is:

1. In the CForms.vcx library, open the CBizObjForm class
2. In the SetPrimaryBizObj method, comment out the following line:

This.SetFilePos()

3. Close the class and save changes

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform