Hi!
Do you restore data session back after checking? In other words, does your code looks like following:
nOldDataSession = SET("DATASESSION")
... do something in the default data session
SET DATASESSION TO (nOldDataSession)
Wneh above do not help, then re-open the tabel in private data session.
When grid cannot reach its record source, it is reconstruted (see VFP Grids article in the August issue of UT Magazine).
HTH.
>Hi can anyone explain this:-
>
>I have a form with a grid on it, this has a ControlSourceType of 1 and a ControlSource of a table in the forms Private datasession.
>
>Everything was going fine until I added some code that does a check on a table in the Default datasession.
>
>Basically at the point that I change datasessions the grids ControlSource is emptied.
>
>Thanks in anticipation.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.