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