Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with combobox Record In Use
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Problem with combobox Record In Use
Miscellaneous
Thread ID:
00858639
Message ID:
00858639
Views:
60
Ok... This is really ticking me off.
I'm working on a project. A primary form is used to display one or more grids (parent/child when appropriate). The grid is being built dynamically and data driven. One of the columns built contains a combobox tied to a bogus cursor

create cursor C_Tmp ( TmpCol c(50))

Anyhow, there are over 25 different "views" that the form can display deriving the data from different sources. Each of the grids are being built without any problem on all the others except 1, so I know that the looping, dynamic building and control sources are ok.

There will only ever be a single instance of this "VIEW" form ever displayed so I know there is no duplication of cursors, grid controls, etc. Now the form instance that is trying to be loaded is only supposed to display a single grid, therefore only a single "combobox" grid column.

When preparing the grid column, I force to close the cursor if already open

USE IN ( SELECT( "C_Tmp" ))
select 0
create cursor C_Tmp ( TmpCol c(50) )
append blank

So... At this point, any controls that may have been (of which could never happen because this is the ONLY place the control source is EVER set) would be detached since the cursor would be pre-closed.

Now, I add the combobox control to the column. Within the combobox, I prepare that and set its control source to the "C_Tmp.TmpCol" and VFP throws-up and says "Error 109, Record is in use by another user".... This is all developed for single-user / single-machine / local data processing and I'm the only one on it.

Again, this only happens on the one view defintion and all other views (over 20) all operate the EXACT same process but DO WORK without problem.

Development info... XP Prof, VFP8.

I'd appreciate any thoughts, I'm really stumped on this one.

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform