My Visual Database — Got error by no returning sql!

Re: Got error by no returning sql!

null@example.com (sonixax) — Sun, 12 Oct 2014 20:16:57 +0000

Thanks a lot

Re: Got error by no returning sql!

null@example.com (DriveSoft) — Sun, 12 Oct 2014 19:03:57 +0000

Sorry )

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
var
   s: string;
begin
     s := SQLExecute ('SELECT MAX(einnahme) FROM Ennahmeausgabe');
     Main.biggerineu.Caption:= s +' €';
end;

Re: Got error by no returning sql!

null@example.com (sonixax) — Sun, 12 Oct 2014 18:48:58 +0000

DriveSoft wrote:

try this:

Main.biggerineu.Caption := SQLExecute ('SELECT MAX(einnahme) FROM Ennahmeausgabe')+' €';

Thanks a lot,
With this code I've got error when I have results !!!
All of my Results are double

Re: Got error by no returning sql!

null@example.com (DriveSoft) — Sun, 12 Oct 2014 18:09:04 +0000

try this:

Main.biggerineu.Caption := SQLExecute ('SELECT MAX(einnahme) FROM Ennahmeausgabe')+' €';

Got error by no returning sql!

null@example.com (sonixax) — Sun, 12 Oct 2014 17:36:27 +0000

Hi,
I've got The error attached when I run an sql with no result on the following code :

Main.biggerineu.Caption :=    FloatToStr(SQLExecute ('SELECT MAX(einnahme) FROM Ennahmeausgabe'))+' €';

I'm not knowing Delphi code as well as that can I solve this little problem

Thanks a lot