BorlandTalk.com

Nick Weaver · Guest

I am trying to use the SELECT INTO command within Delphi using Paradox as a
database. Bassically, I need a way to create a Temp table (#Temp.db) for
storing some data just to be displayed in a datagrid which gets deleted and
reconstructed every time the screen is brought up. The biggest problem is
that I cannot get a table to allow itself to be emptied because other users
(with the same screen open) lock the table from being emptied, hence the
need for a Temp table. I would just use a Query, but the "table" being
created must be edited as a result of user input and a Query is not
"editable". Does such fuctionality exist in Delphi? Any help would be
greatly appreciated. thanks!

Bill Todd · Guest

SQL has nothing to do with Delphi. Each database system implements its own
SQL dialect. Delphi components just pass the SQL statements to the
database management system for execution. Paradox tables use a dialect
called Local SQL. You can get help with Local SQL from the Local SQL help
file in your BDE directory. Local SQL does not support SELECT INTO. Use
INSERT INTO SOME_TABLE SELECT ... FROM ... instead.

The best way to handle temporary tables with a Paradox database is to set
Session.PrivateDir to a directory on the user's local hard drive and
create the table there. That way each user will have their own copy.

The best place to ask questions about Paradox tables is the
database.desktop newsgroup.

--
Bill Todd (TeamB)
TeamB cannot answer questions received via email