Script Variant

[andrew101]

Simpe answer i hope. Im trying to have buttons execute a mimic script but change the variant, where pVariant is the ID

-script-

SELECT

    Recordtime

FROM

    CDBHISTORIC

WHERE

    ID = pVariant AND

    Recordtime BETWEEN { OPC 'Y' } AND { OPC 'Y + 1Y' } AND

    STATEDESC = 'Running'"
end sub

[AdamWoodland]

There are a few ways to do it, but where is pVariant coming from? Is it a point value, is it an input from the user?

Once you have that value and have validated it (i.e. it is only an integer) then you can just do some simple string concatenation to get the SQL you need, i.e.

"SELECT columns FROM table WHERE id = " & pVariant & " AND something = somevalue"

Then use Server.Query to execute it and get the results, the help has that info in.

[BevanWeiss]

As Adam mentioned, if you really need this in your script, you can do it that way.

But... if you want to display it for a user, then you probably want to use an animation for the SQL expression on an embedded query list.

You could do something like:

'SELECT

    Recordtime

FROM

    CDBHISTORIC

WHERE

    ID = ' + REGISTRY("RegistryLocationWhereYouHavepVariantStored", -1) + ' AND

    Recordtime BETWEEN { OPC 'Y' } AND { OPC 'Y + 1Y' } AND

    STATEDESC = ''Running'''

NOTE: single quotes within the SQL need to be escaped as two single quotes (i.e. 'Running' -> ''Running'')

Then if you had a button to change the variant, it could simply set the registry value.  The animation 'plumbing' is normally good for this, when your button changes the registry field, then the animations based on that are updated (I've never had it fail... outside of bug situations).