SQL problem

[ToFaceTeKilla]

Sorry i can't (and don't want to) install stuff, just to check your DB for you.
You can proceed as follows:
1.) Debug and check your parameters (:HWM_ID,...)
2.) Check the entries in your DB. If there is no way to access the DB from outside of Delphi (i wasn't able to find any tool) just make a query with 'SELECT * FROM...' and check the recordset.
3.) Compare the content of your DB with the values of your parameters. Is there any match? If not, then you probably there is a bug in the functions which fill the params!

[nanix]

I already fixed it :lol:

But thanks for support,parameters was a problem when you are writting such long SQL text readability suffers :dp:

[ToFaceTeKilla]

Fine. So what was the problem? I'm curious :-)