243 results found
-
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 -
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 -
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 -
New property FlatADTView
Add new property FlatADTView (default false for not changing standard behavior of TOraQuery) for showing fields separately in ftADT field in Object View mode.
Example:
CODE: SELECT ALL
create or replace type ComplexType as object(
x varchar2(100),
y varchar2(100)
);/
OraQuery1.SQL.Text := 'select ComplexType(CODE, name) A from TEST';
OraQuery1.ObjectView := True;
OraQuery1.FlatADTView := True; (new property)
OraQuery1.Open;And I want to see:
CODE: SELECT ALL
A.X | A.Y
1 | 2
3 | 4
like OraQuery1.ObjectView := False but this variant friendly for collections datatype.25 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
- Don't see your idea?