Como excluir um indice...
_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
Curtidas 0
Respostas
Afarias
29/11/2005
“DROP INDEX IND_NOMES“
T+
T+
GOSTEI 0