243 results found
-
Can you add the feature to UniDump so that it can backup *all* database objects? In MySQL currently
Can you add the feature to TUniDump so that it can backup all database objects? In MySQL currently it only does tables and views. I would like to backup stored procedures and functions also. I haven't tried other databases (Firebird, Postgres etc) but this would be a great feature to be able to to backup / restore the entire database.
63 votes -
Use named parameters in TMSSToredProc SQL text generattion
Passing parameters by name is more reliable than by index, aspecially when stored procedures is not constant and parameter's list is changed frequently.
3 votes -
21 votes
-
support distributed transactions in myDAC
support distributed transactions in MYDAC
3 votes -
Add support for Params[x].AsLargeUInt
Add support for unsigned int64 in SQL-parameters. Using uInt64 is currently troublesome, as this needs to be done via IntToStr or other tricks.
This makes the code harder to write and also clutters the list of param's - having some of them are dome directly in the SQL-text and having other's in the param-list.
For me (and many other, I guess), the use of unsigned uInt64's gets more and more widespread, eg. in IP-numbers as INETATON/INETNTOA in big data.
3 votes -
Creating a native provider for Paradox
BDE Replacement for Standard / Paradox driver
29 votes -
Add OnFetched event to TOraSQL or TCustomDADataSet class
It looks that there is no universal solution to notify about moment when TOraSQL / TCustomDADataSet class (and its descendants) finishes fetching all data in NonBlocking mode.
There should be added some event that related to Fetched method
3 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 -
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 -
Better sql editor in Unidac
Uniquery sql editor editopr should be improved, showing Tables, fields and stored procedures with drag and drop (Fibplus like).
79 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 -
vba
sometimes user adding in access mdb, accdb query a vba function , so i hope that could the access query using vba function executed also on delphi
1 vote -
Create table in unidac
create table method which is database independend.
70 votes -
Multiple dataset result in Unidac
Multiple dataset result in Unidac. In SDAC it is possible to have multiple dataset as a result of executing a query. With CanOpenNext it is possible to open the next dataset. MySql has the same capabilities. We would appreciate to have this functionality the same way Sql Server componentset has it.
3 votes -
Creating a provider for ADO
ADO access is included in some form in the SQLServer provider. Possibly it could extended to support other Ado providers/drivers. For example foxpro has ado driver till version 9, the odbc driver is at version 6. MSAccess is another example.
59 votes -
Executing SQL-Statement in Background (Interbase)
This will be controlled through an appropriate property.
42 votes -
Adding the OnInfoMessage event for UniConnection
Some of our DAC products support receiving information messages from database servers. (ToraSession and TMSConnection have the OnInfoMessage event, PgConnection has OnNotification event). We may add such event to TuniConnection; it will be called when a message from a database server is received.
57 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 -
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 -
Property to return number of warnings
In PHP, there is a mysqli->warning_count property to give the number of warnings that the previous statement generated. MyDAC should have something similar to make it easy to know when MySQL gave a warning and easy to retrieve the warning.
3 votes
- Don't see your idea?