Not value or previous values

[#1]

Hi,

I am working on appending my qvds.

I created a variable to select the latest ID in the qvd.

I want to use that ID in the where clause of my database load script to not select that ID or the ID's before it. Just the ones afterwards.

So like this:

Load
*
from database
where id is not equal to variable or before this variable.

Is this possible?

any help is much appreciated,
thanks in advance

[Miguel_Angel_Baeyens]

Hello,

That should work with a piece of script similar to

SET vLoadFrom = 2000; Table:LOAD *;SQL SELECT *FROM TableWHERE id <= $(vLoadFrom);

Should the driver doesn't pass the value of the variable, you can always do that in the LOAD part of the script.

Hope that helps