Hi Tom,
I might have known you'd weigh in on this one! :)
>I remember reading an article a few years ago stating that “FoxPro dbf’s are 90% compliant with the relational database model”. Again if you are a purest you will reference that 10% value as your validation against the dbf format being “a true relational database model”.
If the DBF format falls down on the fact that indexes and tables are held in separate files (which also happens to extend the capabilities of the DBF enabled system beyond the 2GIG file size limit -imposed by the operating system), then what we're really saying is that the DBF schema is just like an RDBMS only better!
Maybe we should call the VFP/DBF system an RDBMSx ("x" for extended capabilities)
I'll go for that. :)Hugh
Microsoft hears loudest what the VFP community says about Visual FoxPro by looking at the bottom line!
Support the product. Buy the latest version!
Hugh Winters @ WorldData 408-512-1131