Silly question

[jalin]

I have a very simple query:

select count(*) from departamento

How can I get the result of the query with the MyDac component ?

Thanks and sorry
Jalin

[eduardosic]

I have a very simple query:

select count(*) from departamento

How can I get the result of the query with the MyDac component ?

Thanks and sorry
Jalin

try this

Code: Select all

//QryCount is a TMyQuery
//nValue is Variable to receive the value os query..
With QryCount do begin
 Close;
 Sql.Text := 'select count(*) as New  from departamento';
 Execute;
 nValue := FieldByName( 'New' ).AsInteger;
 Close;
end;

[jalin]

I tried but doesnt work

[eduardosic]

I tried but doesnt work

what problem? what erros messages? send a small project to CoreLab team.

You are a New user? please See MyDAC demo.