my two cents :
at the beginning, I used the 'visual data environment' until one day a 'table
object' became sized 0,0 and I was unable to reinitialize it to a normal size.
So I came back to what I like a lot : code. In fact, sometimes I open the
dataenvironment, put a table on it, drag the object to the form to have a grid
and then delete the table and the dataenvironment !
I open tables and views, instanciate data-acces classes in the load event (but I
don't write 'close tables all' in the unload event !). It's easier for me to
understand the 'data structure' reading a lot of code than looking at a visual
map. It's also easier to find a table, a field, ... with the 'research tool'.
Apart this, nearly all my forms are in a private dataenvironment (I allow the
user to open each form more then once (ie in my school management system, he/she
can work on three or four pupils at the same time)).
and nowadays, I am testing one thing : I have a lot of 'parameter tables' ie :
holydays dates, prices, types of meals, ..... I build a class, instanciated as a
global object in the init of the app so in the datasession 1; this class opens
'parameter views' only when it is needed (so if I need a 'meal price', it opens
the view if it is not opened; the view is not systematically opened in the init
(is this understandable ?)). The cursors generated are in the datasession n°1.
And in the load event of a form with a private dataenvironment I write :
goparam.viewtest_open() && opens the view if it is not in the datasession 1
otherwise do nothing
USE viewtest NOREQUERY 1 && 'copy' the cursor in the form's datasession
It is supposed to be very fast (no requery just a copy aof the cursor) ... and
it seems to work well ...
The Foxil
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
