What SQL Syntax is allowed in Model Search?

[volenin]

Hi. I wonder what kind of SQL syntax is allowed in the model search? Are you allowed to use 'embedded' SQL to build up complex queries? Cursors? Is it only dependent on the underlying DB you are using to store the model? Thx.

Vlad

[Geert Bellekens]

Vlad,

First of all it indeed depends on the db you are using. So queries that work on SQL Server might not work on .eap files.

But next to that I've noticed that some things just don't work. I once tried used Common Table Expressions to create a recursive query, and that didn't work. I got some DAO type error complaining about an invalid syntax (although my query worked perfectly when I tried it on the database directly.)

Geert

[Helmut Ortmann]

Vlad,

You can use Select statements according to the database you use (Access, SQL Server, Oracle,..). Additional you may use the extensions provided by SPARX like:

• <Search String>
• #DB=<DBNAME>#
• #Package#
• #WC#
• #Branch#
• #Author#
• #UserName#
• etc.

You can't use cursors.

Kind regards,

Helmut

[Geert Bellekens]

You can't use cursors.

Kind regards,

Helmut

Well, you shouldn't use cursors anyway

Geert