Devart Forums

Hi,

Does TuniQuery will provide a common SQL or do I need to provide SQL specific for Oracle and for SQL Server as for example date arithmetic.

Guillermo Ortega A.

No, TUniQuery does not currently provide such functionality. Please describe in more details your example.

For example in Oracle:
SELECT ...., DATE_FIELD + num_days < SYSDATE

SQL Server
SELECT ....,DATEADD(day,num_days,DATE_FIELD) < GETDATE()

The question is:
Do I need to provide different SQL Statement depending on the backend? or you will provide a commom SQL.

Thanks.

Sometimes i use analytic functions in Oracle. In this case SQL for mySql DB stored separately.
Can TUniQuery store different SQL's?

Now UniDAC does not provide such functionality.

Hi,
unidac 2.0 have this function ?

This can be easy implement with macros:

SELECT ...,
&IF_ORA DATE_FIELD + num_days < SYSDATE &FI_ORA
&IF_SQL SELECT ....,DATEADD(day,num_days,DATE_FIELD) < GETDATE() &FI_SQL

On before open:

case (Query.Connection.ProviderName + ' ')[1] of
'O': // Oracle
begin
Query.Macros.MacroByName('IF_ORA').Value = '';
Query.Macros.MacroByName('FI_ORA').Value = '';
Query.Macros.MacroByName('IF_SQL').Value = '/*';
Query.Macros.MacroByName('FI_SQL').Value = '*/';
end
'S': // SQL Server
begin
Query.Macros.MacroByName('IF_SQL').Value = '';
Query.Macros.MacroByName('FI_SQL').Value = '';
Query.Macros.MacroByName('IF_ORA').Value = '/*';
Query.Macros.MacroByName('FI_ORA').Value = '*/';
end
end;

Best Regards
Branko

Typo (copy / paste), of course correct select sql above is:

SELECT ...,
&IF_ORA DATE_FIELD + num_days < SYSDATE &FI_ORA
&IF_SQL DATEADD(day,num_days,DATE_FIELD) < GETDATE() &FI_SQL
...

Branko

UniDAC 2.0 still does not have a feature to set different SQL depending on the server.

Please take a look at our roadmap here http://devart.com/forums/viewtopic.php?t=13767