BASE SQL Box TOOLS/SQL Dialog Box

[Craig209Smith]

When I execute the following code. I get an error. I have tried counter, 'counter', and "counter" all with the same results. What dumb thing am I doing wrong?

DECLARE counter BIGINT;
counter = 1;
UPDATE "tbAll_Game_Word"
SET "fRand" = RAND(),
"fCount" = counter,
counter = counter + 1
WHERE "fLen" = 2;

1. Unexpected token: DECLARE in statement [DECLARE]

[Mountaineer]

Imho you didn't read the error message.
Either Base or your Database can't handle the Keyword declare.

If your Database can: There is a Button SQL at the Toolbox,wich prevents Interpretation of your Command by Base and sends it directly to the used Database

J.

correction: Villeroy is right (below), the direkt-SQL button is only for a query not in the toolbox.

[Villeroy]

It is the database engine. Base does not parse commands entered into the SQL box. The type of engine is indicated on the left side of the status bar.