Hi All,
I am new here and hope my question is understand to you.
Within one procedure, can I utilized the previous 6 months .MAS file which have the same name?
Thanks all.

This message has been edited. Last edited by: Kerry,

What do you mean by "previous 6 months . MAS file"
What is in your opinion a MAS file?

Each month all sale transactions, amount and customer information, etc. will be downloaded and was saved within a certain database name eg. CarSell_Jul08, Carsell_Aug08, Carsell_Sep08, Carsell_Oct08, Carsell_Nov08 and Carsell_Dec08. Among it, there are serveral different subfiles and the subfiles name is the same for each month, which look like this.
Carsell_Jul08
- customer.mas
- newcar.mas
- hirecar.mas
Carsell_Aug08
- customer.mas
- sellcar.mas
- hirecar.mas
Carsell_Sep08
- customer.mas
- sellcar.mas
- reccard.mas
Carsell_Oct08
- customer.mas
- sellcar.mas
- reccar.mas
Carsell_Nov08
- customer.mas
- sellcar.mas
- reccar.mas
Carsell_Dec08
- customer.mas
- sellcar.mas
- reccar.mas

Base on this struction, can I use one procedure (.FEX file) to join all six months information and list them out even though they all have the same MAS name?

Well it can, take the documentation and search for the term 'USE'.

I think however that your design is a bit strange.
If you put and extra field in the database masters that has the month as key, you may be able to put all the data into one database.

If you post the 3 masters we might be able to help you a bit better.
I suppose you have all the databases in different directories?
What kind of databases are this?

quote:

you post the 3 masters we might be able to help you a bit better.
I suppose you have all the databases in different directories?

Thanks for your help, but due to company policy, the data cannnot be disclosed. Any way try your suggestion.

I did not ask for the data, but for the masters.

The best suggestion I can think of is ask the company what there policy is in relation to training there personnel.
I think they bought a very good and powerful piece of software.

Hi Frank
As I am the end user and are very very new to WebFocuc. Sorry for the miss leading, hope this will make you more clear .
**CREATE SYNONYM**
****LEDF COLUMN****
Metadata
Configured
approot
DEC2008
sel940 - ODBC
sellown - ODBC
carhire - ODBC

Add
Remote Server

ODBC
DEC2007
JUN2008
JUL2008
OCT2007
NOV2007
SEP2008
JAN2008
DEC2008

***RIGHT CLOUMN***

DBMS = SQLODBC ; Server = DEC2008
Application: DEC2008
Prefix: SET CONVERSION LONGCHAR TEXT (for Web Focus)ALPHABLOB (for EDA)
--------------------------------------------------------------------------------
All Select
Check Default Synonym Name Owner/Schema Table Name Type
SELL940 dbo SELL940 TABLE
SELLOWN dbo SELLOWN TABLE
CARHIRE dbo CARHIRE TABLE

I would again strongly recommend at least some basic training.

Your company gives you as enduser the ability to create synonyms, but who is creating all the databases every month?

If you open the CARHIRE.MAS of one of these months in an editor what do you get?
Does the master have a field to recognize the month?