Re: App Data generation
Peter Cushing wrote: I'm sure this sort of thing would have been done by someone (and tested etc). That's why I went for Stonefield. I would not have to reinvent the wheel and it gave me other benefits (like a reindex function etc) For the cost of SDT ($299?), it's more than worth it! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" ___ Post Messages to: ProFox@leafe.com 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.
Re: App Data generation
On 6/28/06, Tristan Leask <[EMAIL PROTECTED]> wrote: 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...? Are you talking about the data itself, or the data structures/metadata? I use xCase for data design, and it generates create scripts (like GenDBC scripts). When I make a change, it generates an update script. We can pass those around, run them as part of an update process and store them in source code control to track changes. The way to "do it right" is to store a free table that has a version number and a script to move from the previous version to the current one. Store a version number inside the database. Compare the two and run the scripts to upgrade from old to new. Most of my apps are custom and installed in a few sites, so we manage the process manually. The shoemaker's children and all that. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com 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.
Re: App Data generation
Tristan Leask wrote: 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. I'm sure this sort of thing would have been done by someone (and tested etc). That's why I went for Stonefield. I would not have to reinvent the wheel and it gave me other benefits (like a reindex function etc) Peter ___ Post Messages to: ProFox@leafe.com 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.
RE: App Data generation
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: ProFox@leafe.com 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.
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 ___ Post Messages to: ProFox@leafe.com 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.