U++ forum: Welcome to the forum

Re: SqlExp deeply refactored [message #5237 is a reply to message #5222]

Mon, 11 September 2006 09:49

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

luzr wrote on Sun, 10 September 2006 19:05

This is done mainly to start supporting SQL dialects based on session type - SQL statements are now "compiled" for specific target SQL engine (but fine tuning all commands for specific database engines will take some time).

In the process, I refined the structure of SqlExp types to avoid single "SqlSet" to serve too much purposes. So now we have

SqlSet - now just set of values (or Select result), no more represent SQL statement

SqlStatement
SqlSelect
SqlInsert
SqlDelete
SqlUpdate

Most of code using SqlExp works without trouble after this huge change, but some extreme usages (usually very old) needed to be fixed in our apps.

Mirek

Great!. But what about Left/Right Join? I noticed they use Oracle syntax (join type is specified in where clause). Unfortunately that syntax is not common in others databases..

Report message to a moderator