on 04-19-2023 7:23 PM
I am getting errors attempting to create a declare line in a query in Query Generator. I am told this works in My Sql..
/*SELECT * FROM "OINV" T0*/
Declare @FromDate timestamp;
Set @FromDate = /* SELECT T0."DocDate" from OINV T0 Where T0."DocDate" = */ '[%0]';
SELECT * FROM "OINV"
WHERE "DocDate" > @FromDate
-- error message says incorrect syntax near @ line 3 col 3
what syntax do i need here or does declare not work in Query Manager as it does in other products?
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.