Larry Bradley wrote: > I'm going to convert a large VFP application that uses the CodeBook > framework to DABO. This system manages the day-to-day operations of a 1200 > member Yacht Club that I belong to. It started out as a FoxBase app 20 > years ago, and has evolved over time. > > I recently converted it to use mySQL as a back end; it makes extensive use > of remote views as well as VFP's SQL passthrough. This should make it > easier to convert to DABO, since the nasty work of converting from VFP > tables to mySQL has been done. > > However, as I mentioned, it uses remote views. For example, when I display > the member's data, I have a VFP remote view that picks up fields from the > member table (these are editable) and from the membercategory table (these > are read-only). This type of things is done extensively in this app. > > I'm quite new to DABO - just started playing with it. > > What should I be looking at in DABO/mySQL as a replacement for the remote > view (with multiple tables) facility of VFP? >
I have been pondering this question for a few months. "Views are an Sql query and wad of parameters to help VFP figure out what Vfp Datatypes the columns are, and what updates to send back." http://fox.wikis.com/wc.dll?Wiki~VfpViews~VFP so a "VFP view" is just a wad of metadata. (calling the SQL command 'data' may be a stretch, but it is just a string, and that string is stored in the dbc file, which is more a data file than a 'code file', but all this is just a matter of agreeing to some terms, so lets agree to call the string that starts "Select ... From..." as one more piece of data. ) In dabo, there isn't a formal 'place' to put that metadata that could be labeled "a view" but that doesn't mean you can't put the stuff somewhere and use it and achieve the same thing that a VFP view provided. also, in VFP, that stuff is all put in the DBC, which makes it seem like it is all data-tier related, but I am not sure how correct that is. Ed suggested the SQL command is really a Business tier thing - I keep changing my mind on if I agree. This matters because even if VFP made it 'convenient' we will be better off storing things where they belong. "Special cases aren't special enough to break the rules." sorry if this doesn't answer your question at all :) Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users
