44 results found
-
Add a limit for the record count in the DataSet
Add a parameter, for example, MaxFetchRows, which will limit the number of records which can be fetched to the DataSet.
83 votes -
Save settings to the database as in an *.ini file or in registry
Many applications use TiniFile or TRegistry for saving their settings. However sometimes one user can work on several workstations with his login and password. He wants to have the same settings on all of his workplaces, and that settings, saved on one computer, were available on other ones.
To implement this feature we may add classes or components with interface similar to TiniFile or TRegistry that save data not on the local computer, but in a database.
82 votes -
Add properties KeepAlive + KeepAliveInterval (maintain the connection)
The component should TUniConnection every 3000 ms (for example) to send to the server any single request (for example, "select 1 from dual"), to the gateway and the server is "seen" that the connection is active and the client is connected.
RUS:
Компонента TUniConnection должна, каждые 3000 мс (к примеру) отправлять на сервер какой-нибудь холостой запрос (к примеру, "select 1 from dual"), чтобы шлюз и сервер "видел", что соединение активно и клиент подключен.Сообщение на форуме: http://www.devart.com/ru/forums/viewtopic.php?p=2081#2081
69 votes -
Forced sending queries to the server without parameters
Queries may be with or without parameters:
select *
from test_table
where id = :IDor
select *
from test_tableHowever some database servers execute queries without parameters faster than the same queries with parameters. An option (for example, AllowParams) may be added; if this option is set to False, all queries will be sent to a server as text.
45 votes -
sqlmonitor
Enhance the SQLMonitor with params copy out functionality
32 votes -
Support interactive query builders
Add support for interactive query builders like TMS or Korzh query builder.
31 votes -
Create a property in the session objects that shows that a statement is current running in a thread!
This is helpfull in a multi threaded environment to see if a statement is running in an other thread.
When this is the case any statement in the main thread should not run, because in this moment the main app will be frozen.23 votes -
Cloned Cursors
Today i'm more and more using TClientDataset because of the cloned cursor and Unidac just for for synchronize and transport between the back end database and the TClientDataset. With a cloned cursor multiple components can share the same data-space and the speed and memory gains are huge, but i would preferer to do this in the unidac and not have another extra layer of technology.
A tQuery with all the functionality of tClientDataSet would be very nice and Firedac is moving that way.
15 votes -
Possibility to set options not just for each DataSet, but for the whole session
Currently such options as FetchAll, QueryRecCount, and others can be set for each DataSet separately. If you need to change these settings, you need either to do it manually at design-time or set them in cycle for all DataSets at run-time.
We may add an option to set these values for all DataSets for a connection. For example, if FetchAll is set to True for a connection, all DataSets in this connection will use this value. You need to set this property only for those DataSets, that must have different value of this option.
14 votes -
Faster access and less trafic over internet en lan
You should implement a feature to avoid moving a lot of records over the network. The components should keep a record position pointer.
So if a dbgrid is 20 lines (the system should read only 20 records en send 20 records over the internet of lan. At next page, read the next 20 records and at page back read the 20 previous records.
It is a feature that is present in ElevateDb and Anydac.
I am very happy with your components and I know we can set the number of records to return, but the described option should be a…14 votes -
13 votes
-
Support open source free embedded database DuckDB
DuckDB is an open source free and very good embedded database, is it possible to fully embed DuckDB into delphi programs like SQLite, without external DLL files?
12 votes -
unidump
When using mySQL as the provider it is possible to add drop and create table statements to the "backuptofile"-file. This option is not possible when using the Microsoft SQL server provider. Could you please add this option ? :-)
12 votes -
CodeTyphon compatability.
Would love to see the DevArt components have compatibility for CodeTyphon (FPC/Lazarus fork) as well as instructions for installing/compiling.
12 votes -
10 votes
-
Implement the auto-incrementation in TVirtualTable component
The TvirtualTable component lacks the ability to use the existing fieldType "autoinc" as such. It uses it as ftInteger.
I think It is usefull to have this ability but only when appending records manualy or programaticaly. Not when loading from stream/file.9 votes -
Enhance the SQLMonitor to allow grouping of objects by nane
In the SQL-Monitor an option is needed that the log files of source objects are grouped by the name of the object.
7 votes -
Adding 'Persistent Indexes' to the TVirtualTable
Could you consider to add the 'Persistent Indexes' to the TVirtualTable ?
In this case the table could be have a few indexes. Inserting/deleting records will modify all indexes. The searching data will use existing indexes without recreating them. Something like in DBF files with several *.ndx files. Before searching the presistent index will be chose by index name and searching will use this index.
At this moment it is possible to use only one index by setting the VirtualTable.IndexFieldNames property. Changing this property recreates the index, and for large table (>3000) takes time.
The 'Persistent Indexes' are used in…
7 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
- Don't see your idea?