RulesEngine.GetLastGeneratedGuid

Previous Next

Get the most recently generated GUID, if any are generated in the current session. A unique value is generated for a column C each time a record with column C is inserted, if C is based on a domain that has the "Generate Unique Values = GUID" setting.

Returns a column value (a GUID).

Syntax

SELECT RulesEngine.GetLastGeneratedGuid()

 

Explanation

If a table contains a column for which the domain has the "Generate Unique Values = GUID" setting, each time a new row is INSERTed into this table, the Rules Engine automatically generates a new GUID for that key column.

If you are in client/server mode, you can see this new value directly after INSERTing the row. This behaviour is referred to as "update-notify".

But if you are using the Remote Rules Service API or the Rules Service, the underlying protocol (ODBC or JDBC) which allows you to communicate with the Rules Engine does not provide an "update-notify" mechanism, so that you cannot see the newly generated key value. This makes it difficult to retrieve the row that you have just inserted. The RulesEngine.GetLastGeneratedGuid() method provides the solution for this problem.

Only the session's MOST RECENTLY GENERATED value is available.

 

See also

RulesEngine internal component

RulesEngine.GetLastGeneratedUniqueValue