Application tables split in various directories (None Specified)
At 04 SEP 1999 01:07:23AM ilde Girón wrote:
I created an application called SGI_DB which has three main kinds of related data:
- Customers
- Prospects
- Invoicing
Once I figured out what tables and fields I would use, I proceeded to create them in three directories whose names are:
- custom
- prosp
- invoices
All directories are located under c:\revsoft\oinsight
Does anybody see a potential problem in putting data for an application on various directories? Should I have created all tables in a single directory? Will OI be able to place indexes for my tables in the right places?
At 04 SEP 1999 09:32AM Donald Bakke wrote:
ilde,
There is no problem with what you are doing. OI can handle multiple volumes just like AREV.
The real challenge is understanding how OI uses the .DBT operating system file to know what tables to attach. In this regard it is similar to an attachimage in AREV. So if you have new tables introduced to these volumes from another system (like AREV), OI won't know to attach them until you explicitely add these tables and then save the database definition (which then updates the .DBT file.)
dbakke@srpcs.com
At 06 SEP 1999 02:20AM ilde Girón. wrote:
Thanks for taking the time to answer to my quetion Don.
Best regards,
ilde.
At 06 SEP 1999 08:19AM Colin Rule wrote:
We have multiple sub-directories in our applications, with each having up to 50 database files. It all works fine.
You will have Revmedia in each, and there is an attachment problem if each have the same time/date stamp, but your example would be OK.
There is no problem attaching each and and when you need it.
Take care though as you cannot legally create these tables programmattically unles you have the OI development system or Dev Ready Runtime active.