Fórum Como excluir um indice... #54014
29/11/2005
0
_DM_INTERBASE.IBDatabase1.DatabaseName:= ´C:\MaxProgramador\Pro Projeto\Teste\BD Interbase\BD.GDB´;
_DM_INTERBASE.IBDatabase1.LoginPrompt:= false;
_DM_INTERBASE.IBDatabase1.Params.Add(´user_name=sysdba´);
_DM_INTERBASE.IBDatabase1.Params.Add(´password=masterkey´);
_DM_INTERBASE.IBDatabase1.SQLDialect:= 3;
_DM_INTERBASE.IBDatabase1.DefaultTransaction:= IBTransaction1;
_DM_INTERBASE.IBDatabase1.Connected:= false;
_DM_INTERBASE.IBTransaction1.defaultdatabase:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBTransaction1.DefaultAction:= TACommitRetaining;
_DM_INTERBASE.IBTransaction1.Active:= false;
_DM_INTERBASE.IBQuery1.database:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBQuery1.SQL.Clear;
//DROP INDEX IND_NOME;
_DM_INTERBASE.IBQuery1.SQL.Add(´DROP INDEX IND_NOMES ON ´ENDERECO_2´ ( NOME )´);
_DM_INTERBASE.IBQuery1.ExecSQL;
_DM_INTERBASE.IBQuery1.SQL.Clear;
Esta dando a mensagem linha 1 caracter 22...
Aonde estou errando...
_DM_INTERBASE.IBDatabase1.LoginPrompt:= false;
_DM_INTERBASE.IBDatabase1.Params.Add(´user_name=sysdba´);
_DM_INTERBASE.IBDatabase1.Params.Add(´password=masterkey´);
_DM_INTERBASE.IBDatabase1.SQLDialect:= 3;
_DM_INTERBASE.IBDatabase1.DefaultTransaction:= IBTransaction1;
_DM_INTERBASE.IBDatabase1.Connected:= false;
_DM_INTERBASE.IBTransaction1.defaultdatabase:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBTransaction1.DefaultAction:= TACommitRetaining;
_DM_INTERBASE.IBTransaction1.Active:= false;
_DM_INTERBASE.IBQuery1.database:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBQuery1.SQL.Clear;
//DROP INDEX IND_NOME;
_DM_INTERBASE.IBQuery1.SQL.Add(´DROP INDEX IND_NOMES ON ´ENDERECO_2´ ( NOME )´);
_DM_INTERBASE.IBQuery1.ExecSQL;
_DM_INTERBASE.IBQuery1.SQL.Clear;
Esta dando a mensagem linha 1 caracter 22...
Aonde estou errando...
Max.sgj
Curtir tópico
+ 0
Responder
Posts
29/11/2005
Afarias
´DROP INDEX IND_NOMES´
T+
T+
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)