Hey guys, sorry for the picture with the camera, i was in a hurry. As you can see, i was in a VM, with Windows XP-64bit, Deplhi7, Firebird 2.1, Zeos and Fortes Report. My client wants a specific task to perform so i wrote the SQL and it compiled very well on my machine, so i went to my client, that had the same config, but using win7-32.
Hey guys, sorry for the picture with the camera, i was in a hurry. As you can see, i was in a VM, with Windows XP-64bit, Deplhi7, Firebird 2.1, Zeos and Fortes Report. My client wants a specific task to perform so i wrote the SQL and it compiled very well on my machine, so i went to my client, that had the same config, but using win7-32.
The same query on my client broke in several occasions, manly due to the Alias using, i kinda went my way around it but now i have this. Token size exceeded. If i cut some of the code off it will work, but i dont think i can accomplish what i want with less code. (note that the code is pretty mess up, that was i trying to debug and eventually surrendering. Can you guys give me a light?
https://imgur.com/a/kqtJ2v1
https://imgur.com/a/kqtJ2v1
The same query on my client broke in several occasions, manly due to the Alias using, i kinda went my way around it but now i have this. Token size exceeded. If i cut some of the code off it will work, but i dont think i can accomplish what i want with less code. (note that the code is pretty mess up, that was i trying to debug and eventually surrendering. Can you guys give me a light?
https://imgur.com/a/kqtJ2v1
https://imgur.com/a/kqtJ2v1
Rik van Kekem I'm seeing it now. Left picture with Windows XP screenshot is absolutly invalid SQL, because
ReplyDeletewhere datapagamento is null
:di
AND
:df
GROUP
cannot be valid.
And in second screenshot from Windows 7 these lines are replaced with different lines. And that has spurious double quotes.
Possibly some kind of SQL modification before execution, but that would mean, that those showmessages showing sql are of different places in program.
No, you can't. But :df could be replaced with a string (containing :dataFinal) which could result in a PLAN with the sql on the right (although I'm not sure if that works and you would get an error during replacement). But complex parameter replacement like that with parameter inside a string doesn't work anyway. Otherwise the :df replacement is done manually in code and the resulting sql is shown via showmessage (and the " got in there accidentally).
ReplyDelete