listar nome de campos da tabela
24/08/2010
0
Fabio Sanches
Posts
30/08/2010
Fabio Sanches
30/08/2010
Eriley Barbosa
Case CbCampos.ItemIndex of 0 : begin // codigo if cbpesquisa.ItemIndex = 0 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where codusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where codusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end; end; 1 : begin //nome if cbpesquisa.ItemIndex = 1 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where NomUsu like ' + QuotedStr(ELocUsu.Text)+'%'); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where NomUsu like ' + '%'+QuotedStr(ELocUsu.Text)+'%'); DataModule1.ADOQCadUsu.Open; end; end; 2 : begin //nivel if cbpesquisa.ItemIndex = 2 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where nivusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where nivusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end; end; end;
30/08/2010
Eriley Barbosa
DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where NomUsu like ' + QuotedStr('%' + ELocUsu.Text +'%'));
30/08/2010
Fabio Sanches
'a' foi a letra q eu digitei no edit e ja deu erro na hora.
30/08/2010
Eriley Barbosa
31/08/2010
Fabio Sanches
31/08/2010
Eriley Barbosa
Case CbCampos.ItemIndex of 0 : begin // codigo if cbpesquisa.ItemIndex = 0 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where codusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where codusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end; end; 1 : begin //nome if cbpesquisa.ItemIndex = 1 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where NomUsu like ' + QuotedStr(Trim(ELocUsu.Text)+'%')); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where NomUsu like ' + QuotedStr('%'+Trim(ELocUsu.Text)+'%')); DataModule1.ADOQCadUsu.Open; end; end; 2 : begin //nivel if cbpesquisa.ItemIndex = 2 then begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where nivusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end else begin DataModule1.ADOQCadUsu.Close; DataModule1.ADOQCadUsu.SQL.Clear; DataModule1.ADOQCadUsu.SQL.Add('Select * from TCadUsu where nivusu = ' + ELocUsu.Text); DataModule1.ADOQCadUsu.Open; end; end; end;
31/08/2010
Fabio Sanches
31/08/2010
Eriley Barbosa
31/08/2010
Fabio Sanches
31/08/2010
Eriley Barbosa
01/09/2010
Fabio Sanches
01/09/2010
Eriley Barbosa
begin
//joga nos edits, como fizemos no dbnavigator
SeuFormulariodeConsulta.Close;
end;
Clique aqui para fazer login e interagir na Comunidade :)