That's what I thought. Yeah the terminology is a royal PITA. And even VFP's database implementation of triggers and such is not the cleanest in the world.
Thankfully of all the systems we wrote only 2 are left using VFP tables, the rest have been converted to SQL. If we ever get a few months free we might think of converting them as well, but they work so we aren't going to break the wheel. ______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: Doug White [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 8:16 AM > To: CF-Talk > Subject: Re: visual fox pro db? > > > Actually they are "free tables." and not in a database > container. He sent > them to me and I exported them to three different files, > System data format, > Comma delimited, and tab delimited, and he them imported them > into his SQL > database with no further problems. Since the table did not > contain a whole lot > of records, it only took a minute or so to make the export > and send them back. > There is an inherited terminology error with FoxPro, (and for > that matter dbase) > in that free tables were called "database" before they even > knew what a real > database was. > > You are correct that a DBF table can be accessed directly, > but it is cleaner > when using it as a part of a larger application to import it > into an SQL table > where you can apply stored procedures, triggers, etc. > > Had it been in a database container (dbc file) then the VFP > upsize wizard will > convert it to an SQL database file in one pass. > > ====================================== > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > ====================================== > If you are not satisfied with my service, my job isn't done! > > ----- Original Message ----- > From: "Bill Grover" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 02, 2003 6:30 AM > Subject: RE: visual fox pro db? > > > | Sorry it took so long to respond, I got pulled out of the > office all of > yesterday. > | > | I suspect that you are doing your DTS import your DSN is > set to use a VFP > database. In this case when you see the table list SQL is > retrieving it from a > list of tables stored in the VFP database. The VFP database > information is > stored in a set of 3 files, ?.dbc, ?.dct, ?.dcx where ? is > common among the > files. This container holds neat things like triggers, > defaults, referential > integrity and so on. > | > | However, having said that, it is possible to create VFP > tables know as "free > tables". These are tables just like ones in the database but > are not linked to > any database. There are a few restrictions (no triggers, > column names < 10 > characters, etc) but otherwise these tables can be accessed > just like tables > that are part of a VFP database. > | > | So my thought is that the 3 sets of files you are not > seeing in your import > list are free tables. Create yourself another DSN telling > the system to use > tables instead of the database. You should now see all of > the tables in the > folder, both the ones that are part of the database and the > ones that are not. > You should be able to select all of the tables you want to import. > | > | Hope that helps. > | ______________________________________________________ > | > | Bill Grover > | Supervisor MIS Phone: 301.424.3300 x3324 > | EU Services, Inc. FAX: 301.424.3696 > | 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > | Rockville, MD 20850-1299 WWW: http://www.euservices.com > | ______________________________________________________ > | > | > | > | > -----Original Message----- > | > From: Tony Weeg [mailto:[EMAIL PROTECTED] > | > Sent: Tuesday, July 01, 2003 8:45 AM > | > To: CF-Talk > | > Subject: RE: visual fox pro db? > | > > | > > | > just missing a table in the import, that is there, in the > foxpro files > | > directory.... > | > does this make sense? I have like 55 groups of 3 files, > all I assumed > | > where 55 different > | > tables with some ancillary files to hold data....correct? > so, most of > | > them import fine, its just > | > that a couple, don't? its like they are not there in the > | > list of tables > | > to choose from, on my > | > dts import...ive got the filename dsn working, its all good, > | > just three > | > tables don't show up in > | > the list to select all when importing into sql server 2000? > | > > | > tony weeg > | > uncertified advanced cold fusion developer > | > tony at navtrak dot net > | > www.navtrak.net > | > office 410.548.2337 > | > fax 410.860.2337 > | > > | > > | > -----Original Message----- > | > From: Bill Grover [mailto:[EMAIL PROTECTED] > | > Sent: Tuesday, July 01, 2003 7:52 AM > | > To: CF-Talk > | > Subject: RE: visual fox pro db? > | > > | > > | > Tony, > | > > | > We use FoxPro here all the time and have successfully > migrated many > | > systems to SQL. What is the issue/errors you are seeing? > | > ______________________________________________________ > | > > | > Bill Grover > | > Supervisor MIS Phone: 301.424.3300 x3324 > | > EU Services, Inc. FAX: 301.424.3696 > | > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > | > Rockville, MD 20850-1299 WWW: http://www.euservices.com > | > ______________________________________________________ > | > > | > > | > > | > > -----Original Message----- > | > > From: Tony Weeg [mailto:[EMAIL PROTECTED] > | > > Sent: Tuesday, July 01, 2003 12:05 AM > | > > To: CF-Talk > | > > Subject: RE: visual fox pro db? > | > > > | > > > | > > and then in turn, im builing a web based collections > | > system, reverse > | > > engineering actually...but building from scratch most of > | > it...taking > | > > it from a windows based app > | > > to a web based app :) fun fun fun...old vfp system!!! > | > > > | > > later. > | > > > | > > and thanks for any help.. > | > > > | > > -----Original Message----- > | > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > | > > Sent: Monday, June 30, 2003 11:56 PM > | > > To: CF-Talk > | > > Subject: Re: visual fox pro db? > | > > > | > > > | > > What's the question? > | > > > | > > -Novak > | > > > | > > ----- Original Message ----- > | > > From: "Tony Weeg" <[EMAIL PROTECTED]> > | > > To: "CF-Talk" <[EMAIL PROTECTED]> > | > > Sent: Monday, June 30, 2003 8:46 PM > | > > Subject: ot: visual fox pro db? > | > > > | > > > | > > > hey, if anyone on here is knowledgable about vfp > | > databases...please > | > > > if you have time, email me off list, i have a quick > | > > question...thanks! > | > > > > | > > > ....tony > | > > > > | > > > tony weeg > | > > > [EMAIL PROTECTED] > | > > > www.revolutionwebdesign.com > | > > > rEvOlUtIoN wEb DeSiGn > | > > > 410.334.6331 > | > > > > | > > > > | > > > | > > > | > > | > > | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
