RE: Optimize Table usage

2003-01-06 Thread Dan Cumpian
PROTECTED] Subject: Re: Optimize Table usage On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote: >1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE >TableName command? From Delphi help: "Use ExecSQL to execute queries that do not return a cursor to data (s

Re: Optimize Table usage

2003-01-06 Thread Steve Yates
On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote: >1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE >TableName command? From Delphi help: "Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE)." >2) The

Optimize Table usage

2003-01-05 Thread Dan Cumpian
Hello, I am trying to write a process to optimize several tables in a database by using the OPTIMIZE TABLE command in a query. I have a couple of questions that I can't get an answer to in the documentation: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? 2)

Optimize Table usage

2003-01-04 Thread Dan Cumpian
Hello, I am trying to write a process to optimize several tables in a database by using the OPTIMIZE TABLE command in a query. I have a couple of questions that I can't get an answer to in the documentation: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? 2)