Zeoslib Portal

Dear Everybody,

the following sql statement works with MySql-Control-Center on 4.1 server perfectly

[syntax="sql"]
set @Platz = 0;
SELECT @Platz:= (@Platz + 1) as Platz, RegV, RV, VR, Znr, Züchter, sum(Preise) as Preise, sum(Aspkt) AS Aspkt, sum(Km) AS KM FROM ms_championat_ergebnis
GROUP BY Züchter
ORDER BY Preise DESC, Aspkt DESC ...
[/syntax]

this Delphi7 Procedure doesn`t work

[syntax="DELPHI"]

procedure TForm5.championat_ie_dr();
var i : integer;
begin
with Z_Championat do
begin
close;
sql.Clear;
sql.Add('set @Platz = 0; '+
'SELECT @Platz:= (@Platz + 1) as Platz, RegV, RV, VR, Znr, Züchter, '+
'sum(Preise) as Preise, sum(Aspkt) AS Aspkt, sum(Km) AS KM '+
'FROM ms_championat_ergebnis '+
'GROUP BY Züchter '+
'ORDER BY Preise DESC, Aspkt DESC ');
open;

end;
end;

[/syntax]

The EDatabaseError event wrote:
Incorrect Token followed by ":"

I Think, the problem are the chars :=


Please excuse my bad Englisch


For your help many thanks in advance


.

"SELECT @Platz:= (@Platz + 1)" is wrong

Ithink it should be

SELECT @Platz= (@Platz + 1)

":=" is valid only in Delphi, not in SQL.

Any yes - do not use umlats --> use only ASCII characters for field names!

Dear Zippo,

thanks for quik answering.

With the ASCII Chars you are right, but these is not the problem because the Query works without the USER VARIABLES @Platz fine.

In the MySql Documentation on Point 7.1.4 is wrote that you have to use the chars ":=" to replace the User Variables

Hi what version of zeoslib are you using?

the thing here is that ':' is for parameters so when ti parses a ':=' it will tryu ti identry the '=' as aparam name. But As logn as I remeber these correction was done.

Are you using latest version of ZoesLib?

Hi,

i am using following Version of ZeosLib

6.1.5-stable build at 2004-04-29 07:03:04


martin

Set ParamCheck with false

It worked?