243 results found
-
Unidump should backup and restore virtual/ stored virtual fields
Unidump should backup and restore virtual/ stored virtual fields
7 votes -
Support PostGIS Geometry-Data-Types
The possibility to read/write Geometry-Data-Types of PostGIS (MultiPolygon, Collections etc.) as it is possible with PostGreSQL-Geometry-Data-Types like lseg, polygon etc.
7 votes -
Support UDL File for ConnectionString by SQL Server
I think that this can be very useful I to be able to encapsulate the connecting data in a file UDL. In the forum You have promised that possibility for future versions, 5 years old.
6 votes -
Add threaded module to connect and performce SQL operations inside thread
Currently when I tried to perform some SQL operation like connect or use filtersql for table the db bound control flashes and I get many errors like "system out of resource" , etc...
I wish to see IBDac add a new special module to use as a holder for the IBDac components. this module can work inside a second thread but at the same can be bound to the main thread VCL UI controls....is that possible ?
6 votes -
TUniMetaData data-types
the TUniMetaData data-type field now returns different data for different databases - Example:
currently for MySql it returns a string e.g. 'float'
but for MS SQL server it returns a number: e.g. 5 (for float fields)so the recommended improvement is to add a new field to the result that returns a string representing the native database type.
this feature is useful if you want to show a list of columns including data-types to the user - it can also be used to generate a create script, etc.
6 votes -
Double click on TLiteDump
Trivial: SQLite: when user dblclicks TLiteDump it does not open string list editor like in TMyDump
6 votes -
WaitEndMasterScroll
That's right! It is a very useful functionality, something like that
exist in FIBPlus components and is called:WaitEndMasterScroll: boolean
If WaitEndMasterScroll of a master-dataset is True then a detail-dataset
will not be reopened while the master-dataset is in a browse state.WaitEndMasterInterval: integer
Use WaitEndMasterInterval to set an interval before refreshing detail
dataset while navigating.http://www.devrace.com/ru/fibplus/articles/1172.php
+
WaitEndAfterScroll
WaitEndAfterScrollInterval - OnAfterScroll with timeout6 votes -
Add the ability appendFromStream/file to TVirtualTable
Sometimes is needed to preserve the existing records when loading from stream/file.
That could be implemented either with overloading the existing methodes loadFrom... adding a parameter or with new methods like appendFrom....6 votes -
Add an Option "EnableMonitoring" to Diable TSQLMonitor.OnSQL Event for an Object and its dependent Objects
OnSQL Event could so be used for Tracking & Logging into DB without Infinite loops.
6 votes -
Transaction should be closed when TIBCQuery (DataSet) is closed, and Transaction was started by that component. Same as IBX TIBTransaction.
When I use TClientDataSet + TDataSetProvider + TIBCQuery and I open the ClientDataSet and also the TIBQuery is opend and closed, but the transaction is automaticlally started but not closed. In a n-tier solution (e.g. DataSnap) I open the ClientDataSet in the the client but have no access to the underlying Query and Transaction which is on the server side.
The TIBTransaction has that feature implemented and is very handy to use.
6 votes -
More control on Connection Pooling in Unidac Components
Timeout for connection pooling is fixed for 30000 ms in Unidac ( It is a local constant variable). It is not enough for some applications. We need more control on connection pooiling. It would be better if developer could set timeout as a property.
6 votes -
Support Postgres Advanced Server
Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.
6 votes -
Support for Oracle objects in UniDAC queries.
Enable retrieving Oracle objects and varrays from database in query fields. Now in some cases it only properly works if you're retrieving object into a parameter.
6 votes -
TUniSqlMonitor - дозапись в файл
RUS
Предлагаю добавить у компоненты TUniSqlMonitor возможность указать имя файла, чтобы компонента сама всё писала в этот файл. Без использования события OnSQL.ENG
I propose to add a component TUniSqlMonitor the ability to specify the file name to the component itself is all written in the file. Without the use of event OnSQL.5 votes -
Implement Connection.QueryValue()
FIBPlus have a great and simple way to quickly ask databse about value or set of values, this method is called QueryValue. If I want to ask database for only one row, I do not want to create a dataset for it. It causes a big overhead.
Instead I would like to ask for a value like this:
MyValue := Connection.QueryValue('SELECT TOP 1 USERNAME FROM USERS WHERE SURNAME = :SURNAME', [Surname])
5 votes -
Internal Calc fields
Support for InternalCalc fields. This is really usefull feature. And is supported by FireDac and ClientDataset.
5 votes -
Add support for Direct Mode SQLite with FTS5 enabled.
Include SQLite extensions like enable FTS5 in direct mode connection in UniDac.
5 votes -
Natural sort for IndexFieldNames (order 1, 2, 11 instead of 1, 11, 2)
You can order your query/table with the property IndexFieldNames. But if you have an varchar field that contains numbers, the order is wrong. You get:
1
11
2But better would be:
1
2
11This can be done with the "natural sort" algorithm. Please implement it for the use with IndexFieldNames like:
ATable.IndexFieldNames := 'MyField natural';
I know I could sort it with SQL, but I need client side sorting with the property IndexFieldNames.
For natural sort see:
https://en.wikipedia.org/wiki/Natural_sort_order(As far I know Windows uses StrCmpLogicalW to sort file names in that way)
5 votes -
4 votes
-
Add ability to open dataset without sending SELECT query on server.
It is useful for inserting new data without selecting existing.
4 votes
- Don't see your idea?