246 results found
-
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 -
Support interactive query builders
Add support for interactive query builders like TMS or Korzh query builder.
31 votes -
Add DefaultFormat property to TIBCQuery for Date and Numeric fields.
It would be nice to have more control over display formats for Date and Numeric fields.
So having a DefaultFormats property like FIBPlus has, would be of great value.FIBPlus implementation:
DefaultFormats: TFormatFields;TFormatFields = class(TPersistent)
DisplayFormatDateTime:string;
DisplayFormatDate:string;
DisplayFormatTime:string;
DisplayFormatNumeric:string;
EditFormatNumeric:string;
....
end;3 votes -
TIBCAlerter.Synchronize property
The component TIBCAlerter should have a property called Synchronize to listen for events in the background thread same like TFDEventAlerter component
3 votes -
Adding comment feature as property to UniDAC components
Add a "comment" property to possible UniDAC components. It could be very helpfull to add comments to TUniConnection, TUniQuery, TUniTable, ... because technical names are often short or meaningless and a comment can translate it into a meaningful description.
8 votes -
improve you web side by putting away the left side bar of facebook
improve you web side by putting away the left side bar of facebook
1 vote -
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 -
In TOraStoredProc storedproc editor "parameters" tabset please add a "mandatory" checkbox.
At execproc runtime call when this option is checked and the value of the parameter is null display a warning message.
When "mandatory" is not checked nothing is done and the component workd like before.
The principe is a bit like "assertions" in code ... we want to make sure that parameters required by procedures are filled by programmers and not forgotten.
Thanks
Those who don't want the feature can just ignore it.The concept could be extended to an assertion formula, but for us a checkbox is enought
1 vote -
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 -
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 -
DataSet memory Container
My problem today.
I developed a system that is going to be sold to many clients. The problem with firebird nowadays is that anyone can copy the database file and open it in its computer. Using SYSDBA and masterkey the database file can be opened in any computer and then, all your register can be copied.
My dream would be that the user and password could be into the database file and not in the server. But I think this is so far away to come true.
Then, I see a possibility to have all my strings rows encrypted, but…3 votes -
Add compression ability to saveToStream/file of TVirtualTable
I think, the memoryTables are most usefull as secondary tables whith data saved in master tables as BLOBs.
In this case, is big advantage to be saved compressed.
Maybe this behavior is better to be default as it saves space and time.4 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 -
the ability to perform sql queries in the local cache
Возможность выполнять запросы в локальном кеше при установке
значения IBCQuery->LocalUpdate=true1 vote -
SQLite - HTTP tunneling
Using HTTP tunneling for SQLite our applications can manage remote -shared- data using just SQL, not php or other server side solutions. This reduces the time for all data management tasks significant...
3 votes -
Add Method CloneCursor for TUniQuery
Add Method CloneCursor for TUniQuery like TClientDataset.CloneCursor
9 votes -
SaveToXml method from tIBCStoredProc or tQuery splited into several files
Sometimes results is to big to be save or more often to be loaded into a tVirtualTable (not enough memory). Solution should be to split the result files into several smaller ones (according to line numbers or size).
1 vote
- Don't see your idea?