Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with combobox Record In Use
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00858639
Message ID:
00859156
Vues:
16
Don,

>Ok... This is really ticking me off.

ommmmmmmmmmmmmm.. my life with cbos has become much simpler since I decided to use an array property of the cbo as it's RowSource. I created a couple of methods in the class to have a SQL method to pull the specific lookup data into the array as they Init. The Requery() method is also hooked to the same code.


>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
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform