241 results found
-
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 -
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 -
the ability to perform sql queries in the local cache
Возможность выполнять запросы в локальном кеше при установке
значения IBCQuery->LocalUpdate=true1 vote -
Make TOraNumberField.GetAsVariant return a numeric variant type
Currently, the function TOraNumberField.GetAsVariant returns a variant of String type:
Result := AsNumber.AsString;
As a result, data accessed by AsVariant method cannot be processed numerically with 3rd-party data bound components such as DevExpress TcxGridDBChartView.
A change like this or similar would do:try
Result := AsNumber.AsFloat;
except
on E: Exception do
Result := variants.null;
end;It allows data to be displayed in Devexpress chart views that read numeric data as variant.
3 votes -
Add Method CloneCursor for TUniQuery
Add Method CloneCursor for TUniQuery like TClientDataset.CloneCursor
9 votes -
Add support for the parameter "Enable Cleartext Authentication"
Add support for the parameter "Enable Cleartext Authentication" in TUniConnection. e.g. for best work "The Cleartext Client-Side Authentication Plugin".
12 votes -
TUniLoader with Firebird - automaically calulate maximal value for RowsPerBatch
For Firebird the possible value for RowsPerBatch depends on the number of rows in the table because the maximal length of an SQL statement is 64KB.
For RowsPerBatch=0, UniDac should calculate the maximal possible value itself.2 votes -
68 votes
-
Internal Calc fields
Support for InternalCalc fields. This is really usefull feature. And is supported by FireDac and ClientDataset.
5 votes -
InternalCalc fields support
It would be very usefull to have support for fkInternalCalc field types.
It is supported by FireDac and ClientDataset why not UniDAC ?8 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 -
Comment area on the Parameters tab
String parameters sometimes have special formatting forms, and it will be very useful to have a TMemo control to save a reminder on how the parameter should be formatted.
I mostly make use of String parameters to the TO_DATE function instead of DateTime parameters to avoid any conversion issue due to local Date and Time configuration.
It will be necessary to add a String property (Comment) to the TOraParam class to hold the comment data and add a TMemo control to the Parameters tab of the ODAC components (TOraQuery, TSmartQuery, TOraStoredProc and TOraSQL ) Editor.
1 vote -
SSl keys in virtual memory
It will be good to implement some feature to use ssl keys stored in virtual memory like memory stream or blob field instead of file on local storage. For example it may be useful to store ssl keys in local encrypted database.
3 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 -
Extend TIBCLoader beyond event driven design when loading data.
Currently TIBCLoader allows only to Load data by handling particular events. If I want to save something to database I need to handle OnPutData event. Unfortunately this solution requires usage of global variables because to know what I want to insert I need to look for some data beyond the scope of an event.
Even the simple demo of yours shows this problem. You are using a global variable Count to know how much data you want to put it. Rest of the data you are using in a demo is random so it could be generated locally in the…
4 votes -
Make a HELP SYSTEM for UniDAC more efficient and integrated IDE for RAD STUDIO
Create a more efficient system and connected to the Delphi IDE help. It seems that the team is out of date regarding the use of the Delphi help system, and, so far, not integrated their help file to the standard used by professional components for RAD Studio.
1 vote -
Option to let the user control the creation and maintenance of TRANSACTIONS manually, not automatic as with the current version (v5.5.12)
Many people do not bother with the beginning and ending a transaction, however, is of paramount importance to know when a good design to start and control your transactions.
Thus, it would be very interesting to have an option to control when the user wants to leave the components create or open a new transaction and when the user want and need to manually create your transactions.
So, a option to let the user control the creation and maintenance of TRANSACTIONS manually, not automatic as with the current version (v5.5.12)
1 vote -
Allow Joined tables' columns to be updated in TDBGrid, as ADO allows
When using TADOConnection / TADOQuery to create datasource for TDBGrid, columns from main tables as well as joined tables may be edited in the grid. With TUNIxxx components, only the first table in the query can have its columns updated in the grid.
1 vote
- Don't see your idea?