Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error Message - Cannot Access Table
Message
 
 
À
11/08/2003 14:11:30
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00819030
Message ID:
00819082
Vues:
15
>>Check Cannot access selected table error FAQ #18812
>>
>Hi Sergey:
>
>Thank you for your kind response.
>
>1. I have only one combobox whose InterActiveChange executes an SQL statement. However, I do set the RecordSource = ""
>

What is the exact syntax for SQL in the combobox? Do you select into cursor? Can you check, if this cursor is used when you close your form?
(E.g. you can put in Destroy:

messagebox("My cursor is "+ iif(used("MyCursor"),"","not ") + "used"))

If it's closed, you found your problem...


>
thisform.pageframe1.page4.grid1.RecordSource = ""
>thisform.pageframe1.page5.ravibasegrid1.RecordSource = ""
>thisform.pageframe1.page6.ravibasegrid1.RecordSource = ""
>
>2. The cursor name has been the same since the recodrsource is only refreshed when data is Saved, Deleted or Updated. Therefore, the cursor name is the same when either of the 3 actions of taken.
>
>3. I have not executed a "Close Tables" in the Interactive change of the combo or in any of the 3 action command buttons.
>
>Interesting, I did a debug and stepped thru the code. Everything works well, except that the form does not get released. Further, the form hangs even without me using either the Save, Delete or Edit actions. Now, even the error message does not show up. CmdREturn button is part of my baseform, whose click event is "thisform.release()".
>
>Appreciate your guidance.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform