Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table error
Message
 
To
26/11/2000 12:22:34
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00445485
Message ID:
00445551
Views:
20
Hi:
sorry if my translate is not the best...
Claudio Campos Wrote Today in MSNews.Microsoft.com:

---snip
The cannot access occurs en different conditions,
but basically its caused by a control (grid, combo) who loose it datasource before the control 'release'.

It happens to us when we close our forms, and effectively the error cannot be 'trapped'.

May be two solutions:

In the case of Grids and when you are not 'releasing' the form, if you 'touch' the source of the grid (an requery, or something), make the focus in a control outside the grid and after your things are done, do focus in the grid again. (Also can manipulate the rowsource in 0, etc).

For the case of releasing the form, the object garbaje collector or 'killer' before closing the tables.

Our garbage collector uses one recursive function who seek all objects (in its containers, forms , etc) of specific 'Kind' (class) and kill her (an release). before closing tables...

With this last medicine, it doesnt happen again.

-----now the originall in spanish:

el cannot access ocurre en diferentes
condiciones, pero basicamente se trata de un control (grilla, combo, los
combo son la raza mas complicada) que pierde su origen de datos antes de
'liberarse' el control.

Nos ocurria cuando cerrabamos nuestros forms, y efectivamente no se puede
'trampear' el error.

Puede haber dos soluciones:

En el caso de grillas y cuando no estas 'liberando' el form, si 'tocas' el
origen de la grilla (un requery, o algo parecido), has el foco en un control
'fuera' de la grilla, y luego de hacer tus cosas, metele el foco a la grilla
nuevamente. (tambien se puede manipular el rowsource en 0, etc).

Para el caso de liberar el form, el garbage collector, o 'killer' de los
objetos antes de cerrar las tablas.

Nuestro garbage collector usa una funcion recursiva que busca todos los
objetos (en tus containers, forms, etc) de determinada 'raza' (clase) y los
mata (un release). Luego a cerrar las tablas...

Con esta ultima medicina, no nos ha vuelto a ocurrir.
------snip

Ariel Gimenez

our power is our knowledge

Previous
Reply
Map
View

Click here to load this message in the networking platform