New Document or Saved Document ?

[Former Member]

Hi,

I want to write a formatted search that performs a calculation differently depending on whether the user has started a new sales order or has opened a saved sales order.

My question is: When the query runs how do I differenciate between a new document and a saved document.

Thanks,

Conor.

[Former Member · Accepted solution]

I don't know what exactly you want to do but since this can't be done by SBO, check the database. The SQL keywords 'exists', 'in', or 'any' may help.

-->IF EXISTS(expression) then ...

-->select ....where EXISTS(expression)

-->select..where something IN (select..)

-->select...where someting=ANY (select...)

[Former Member · Accepted solution]

I had just managed to solve it there myself using exists. And when I returned to the question you had replied suggestion to use exists... ! In the query I just checked something like the following

if exists(select * from ordr where docnum = $[ordr.docnum])

BEGIN

.

.

.

END ELSE BEGIN

.

.

.

END

Cheers for the help!

Conor.

[Former Member · Accepted solution]

How do I reward you with the points...

[Former Member · Accepted solution]

Points rewarding don't seem to be working now. Try again a bit later.