which table am I using ?

Franco Jommi

Delphi Developer

Fri, 03 Dec 2004 19:20:05 GMT

which table am I using ?

The same program is OK or fails depending on the machine is running on. When
the path of a table is not specified, in one case the program defaults to a
directory where that table exists, in anothe case where it doesn't exist and
it fails. I tried to find out which is the table the program is using in one
case or the other, but I didn't find a function for this, nor I found out
why in one machine the program defaults to the directory of the exe and not
in the other machine.
Can anyone help ?

Richard Cart

Delphi Developer

Sat, 04 Dec 2004 07:19:51 GMT

Re:which table am I using ?

Quote

Franco Jommi (franco.jom...@tin.it) wrote:

: The same program is OK or fails depending on the machine is running on. When
: the path of a table is not specified, in one case the program defaults to a
: directory where that table exists, in anothe case where it doesn't exist and
: it fails. I tried to find out which is the table the program is using in one
: case or the other, but I didn't find a function for this, nor I found out
: why in one machine the program defaults to the directory of the exe and not
: in the other machine.

Using what database engine?

If the BDE, my advice is:
1) For large applications, or applications that may grow and
expand, use alias names.

2) For small applications, using a single table or not much more,
consider putting the table in the same directory with the .exe
file. Then, in the form's onCreate method:
var s: string;
begin
s := ExtractFilePath(Application.ExeName);
Table1.DatabaseName := s;
Table1.Open; //when compiling, Table1.Active should be False
end;
--
Rick Carter
carte...@email.uc.edu Rick.Car...@ParadoxCommunity.com
Chair, Paradox/Delphi SIG, Cincinnati PC Users Group

Franco Jomm

Delphi Developer

Sat, 04 Dec 2004 15:20:15 GMT

Re:which table am I using ?

Thanks for your advice. I am using the DBE and my program uses an ini file
to remember the path to the archives and the problem occurs when, for any
reason, the ini file get lost. But I wanted to understand how Delphi behaves
in the case I open a Table but no path has been explicitally defined.
What is the default path in this case ? Is there a function that I could
use in the program to understand which directory is accessed when opening
tha table ? (this coul help me explain why in different machines the program
behaves differently)

"Richard Carter" <carte...@news.ececs.uc.edu> ha scritto nel messaggio
news:aelqqn$mic$1@news.ececs.uc.edu...

Quote

> Franco Jommi (franco.jom...@tin.it) wrote:
> : The same program is OK or fails depending on the machine is running on.
When
> : the path of a table is not specified, in one case the program defaults
to a
> : directory where that table exists, in anothe case where it doesn't exist
and
> : it fails. I tried to find out which is the table the program is using in
one
> : case or the other, but I didn't find a function for this, nor I found
out
> : why in one machine the program defaults to the directory of the exe and
not
> : in the other machine.

> Using what database engine?

> If the BDE, my advice is:
> 1) For large applications, or applications that may grow and
> expand, use alias names.

> 2) For small applications, using a single table or not much more,
> consider putting the table in the same directory with the .exe
> file. Then, in the form's onCreate method:
> var s: string;
> begin
> s := ExtractFilePath(Application.ExeName);
> Table1.DatabaseName := s;
> Table1.Open; file://when compiling, Table1.Active should be False
> end;
> --
> Rick Carter
> carte...@email.uc.edu Rick.Car...@ParadoxCommunity.com
> Chair, Paradox/Delphi SIG, Cincinnati PC Users Group

Other Threads

1. Losing File Handles - But I am not using Files

2. help for including units in main file (i am using BP7)

3. IndexDefs - am I using the right property?

4. Am I using SQL right ?

5. How to find version of Delphi I am using

6. am i using kylix or delphi?

7. I am looking for a tutorial on using palettes

8. Which driver am I using? (Jet vs ODBC)

9. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

10. Problems using TSQLClientDataSet.LoadFromStream