Page 1 of 1

Silly question

Posted: Tue 20 May 2008 14:18
by 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

Re: Silly question

Posted: Tue 20 May 2008 22:57
by eduardosic
jalin wrote: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;

Posted: Wed 21 May 2008 12:57
by jalin
I tried but doesnt work

Posted: Wed 21 May 2008 15:48
by eduardosic
jalin wrote: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.