connecting to external data

[Guest]

I am attempting to connect to data in a .dbf format to apply calculations and
report results. The complication is the source .dbf will be in a different
subfolder each day and I want the user to be able to select the appropriate
day. I can't move the source file because that would destroy the ability to
update information in source application. I thought 'linked table' but
requires daily intevention. I thought 'source property' but can't determine
how to change IN statement from the FROM clause to reflect the updated source.

If date is 11/29/04 then -
SELECT Emp.Name, Emp.Hour
FROM Emp IN 'C:\Data\20041129' [dBASE IV;]

If user selects date 11/30/04 then
SELECT Emp.Name, Emp.Hour
FROM Emp IN 'C:\Data\20041130' [dBASE IV;]

I was thinking of using ActiveX calender to select date. Any suggestions
before I pull out all my remaining hair?

 

[Guest]

Not sure from your description if it is only one table or many that you
retrieve data from and wether you then want to compare between series...

However it is possible on start up to create a procedure to link tables
based on the day of the week etc. I have done this to import a series of data
that was put into daily folders on the network.

So in short yes you can point the database to a source without the user
having to do so.

 

[Guest]

Tony -
Thanks for your response. There are actually many tables, I am not
attempting to compare data between series only report on the information for
that particular day. I also would like to allow the user to select the day
but not have to adjust the script or code. We are a restaurant company and
office managers who use the application do not come in on the weekends so I
would like them to be able to select a date from some sort of calendar when
they return on Monday, etc. That is why I was thinking of an calendar, saving
the date in a table and trying to pass the date to the SQL. The problem is
how to get the date from the table into the appropriate format.

Not sure from your description if it is only one table or many that you
retrieve data from and wether you then want to compare between series...

However it is possible on start up to create a procedure to link tables
based on the day of the week etc. I have done this to import a series of data
that was put into daily folders on the network.

So in short yes you can point the database to a source without the user
having to do so.

I am attempting to connect to data in a .dbf format to apply calculations and
report results. The complication is the source .dbf will be in a different
subfolder each day and I want the user to be able to select the appropriate
day. I can't move the source file because that would destroy the ability to
update information in source application. I thought 'linked table' but
requires daily intevention. I thought 'source property' but can't determine
how to change IN statement from the FROM clause to reflect the updated source.

If date is 11/29/04 then -
SELECT Emp.Name, Emp.Hour
FROM Emp IN 'C:\Data\20041129' [dBASE IV;]

If user selects date 11/30/04 then
SELECT Emp.Name, Emp.Hour
FROM Emp IN 'C:\Data\20041130' [dBASE IV;]

I was thinking of using ActiveX calender to select date. Any suggestions
before I pull out all my remaining hair?