bmckenna6 wrote:

>I'm a bit new to dropping tables, and I thought I had it solved
>but apparently not:
>
>I'm using v1.00796, single W2K/sp4 system
>
>I'm getting
>
>ISC ERROR CODE: 335544348
>No current record for fetch operation
>unsuccessful metadata update { there are no dependencies }
>object MYTABLE is in use
>
>from the following:
>
> qryDropTable.Close;
> qryDropTable.SQL.Clear;
> qryDropTable.SQL.Add('DELETE FROM MYTABLE');
> qryDropTable.ExecSQL;
> qryDropTable.Close;
>
>

Commit here !

> // adding a separate Connection and closing/opening seemed to
> // solve the issue for a while. Is it true that closing/opening
> // the Connection is recommended for dropping tables?
> connect2.Connected := False;
> connect2.Connected := True;
>
> qryDropTable.SQL.Clear;
> qryDropTable.SQL.Add('DROP TABLE MYTABLE');
> qryDropTable.ExecSQL;
>
>It seems that if the table is empty/newly created,
>then no error. Now, the error only seems to occur
>after there are actual records that get deleted from the
>first statements.
>
>Could this have anything to do with indexes?
>Do they have to be dropped first/separately?
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.2 - Release Date: 14/06/2005