Building an Update statement

[Cullenward]

Is there a way to build an update statement piece by piece?

For example, depending on which variables have values I would like to add them to the WHERE clause and then execute the update statement.

so when variable var1 is greater than 100 it would add

AND var1 > 100

to the where statement, but if it was less than 100 it wouldn't. I'm trying to avoid having 10-20 IF statements to account for the different situations.

 

[bubbly]

U can use the GenerateSQL in order to suffice for ur requirement.
You will then need to create a Datastore and assign this SQL to it....

 

[mbalent]

In the sqlpreview event of the datawindow you can examine and alter the statement prior to it being sent to the database. You can add any additional where clauses and whatnot prior to executing a setsqlpreview command to send the modified statement to the database.

Matt

"Nature forges everything on the anvil of time