Hmm sounds good but I am not using the Stonefield kit. Currently in the systems running at the moment we have a chkfiles program that keeps the data structures correct. But this is just suited to dbfs.
At the moment I am tinkering with my own n-Tier design (building from scratch to learn). I want to do something similar as to what we were doing before but using the data layer to alter tables. One thought I had was to either have a generic checkfiles() in the app object or possible put a checkfiles() in each biz object, thus they would look after there own files. The second route I think is going to end up in more complicated maintenance and probably just will not work. Tristan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Posted At: 28 June 2006 14:17 Posted To: Profox Archive Conversation: App Data generation Subject: Re: App Data generation Tristan Leask wrote: > Hi All, > > Just pondering about something. > > How do you guys sort the data out for a new application installation? > Do you generate it from within your program using the data layer to > build up whatever files are required therefore the same generation code > can be used for DBF/MySQL/MSSQL/yada...? > > Hi Tristan, I'm sticking to DBF's for now so this only works for that option. It also works nicely for when I modify a table or add a new one. I have a new app installation exe that will generate all the DBF's for me using a function in Stonefield Database Toolkit. I just make sure the meta data files plus the DBC are copied over then I put in a text file "update.txt" in the system folder and check for this on startup. If the file is there I call oMeta.SetDatabase(dbc()) IF oMeta.oSDTMgr.NeedUpdate() oMeta.oSDTMgr.Update() ENDIF ERASE ('system\update.txt') Cheers Peter [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
