General information
Title:
Problem with combobox Record In Use
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only