Helpful SQL Syntax for e-Work

Metastorm

The information in this article applies to product: e-Work 5.x 6.x

Sample SQL

• Incorrect: %ExecSQL("INSERT INTO CMSearchResults (efolderid,BatchID,ci\_searchid,ci\_sindex) VALUES (%FolderID,%BatchNumber,%txtci\_searchid,(SELECT ci\_sindex FROM ci\_searchdetail WHERE (ci\_searchid = %txtci\_searchid)))")

  Correct: %ExecSQL("INSERT INTO CMSearchResults (efolderid,BatchID,ci\_searchid,ci\_sindex) SELECT '%FolderID','%BatchNumber','%txtci\_searchid', ci\_sindex FROM ci\_searchdetail WHERE (ci\_searchid = %txtci\_searchid)")