-
Content Count
161 -
Joined
-
Last visited
-
Days Won
4
Posts posted by Dmitry Arefiev
-
-
I am remembering / expecting that "{}" are not supported by SQL Server ODBC driver. Really by ODBC itself (the same with other ODBC drivers). Consider that as limitation of FireDAC SQL Server driver, which uses SQL Server ODBC driver internally.
-
What is RAD Studio version ?
-
@Lars Fosdal, this feature is supported for 2008 too. In general, it will produce 3 different syntax's depending on SQL Server version.
@Attila Kovacs, no, sorry.- 1
-
SELECT <your query> OFFSET 19900 ROWS FETCH FIRST 100 ROWS ONLY
That for SQL Server 2012 and higher. Different SQL will be generated for older versions.
- 1
-
-
Do we have a report for this ?
- 1
-
16 hours ago, Lars Fosdal said:is not something that FireDAC handles well by itself
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Fetching_Rows_(FireDAC)#Rows_Paging
FireDAC transparently modifies SQL command and applies keywords like TOP, OFFSET, etc depending on DBMS. So, why "is not something that FireDAC handles well by itself" ?
- 1
-
This makes language infrastructure more open.
-
1 hour ago, Stefan Glienke said:Record creation does not take time because they are value types and live on the stack.
But if at least 1 managed field ...
- 1
Backup FB3 Embedded through TIBBackup component
in Databases
Posted
This is something to report to quality.embarcadero.com ...