|
|
Home » Developing U++ » U++ TheIDE and Library: Releases and ChangeLogs » SqlExp deeply refactored
|
Re: SqlExp deeply refactored [message #5237 is a reply to message #5222] |
Mon, 11 September 2006 09:49 |
|
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..
|
|
|
|
Re: SqlExp deeply refactored [message #5245 is a reply to message #5239] |
Mon, 11 September 2006 10:57 |
|
luzr wrote on Mon, 11 September 2006 04:06 |
Quote: |
(but fine tuning all commands for specific database engines will take some time)
|
Actually, joins where the main reason to separate SqlSelect from SqlSet... actual implementation of left/right joins will be the next step.
|
Yep, I didn't read carefuly..
Anyway, sql-92 is implemented in most popular databases, so one change (sytax: left/right outer join) is needed to have them all suported.
|
|
|
|
Goto Forum:
Current Time: Wed May 15 03:20:42 CEST 2024
Total time taken to generate the page: 0.02654 seconds
|
|
|