243 results found
-
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 -
"DEFAULT VALUE" constraint support in TUniLoader
For now, if some of the data I need to load in db I'm not able to calculate all fiellds values, there's no way to indicate TUniLoader to let the DB Server apply the fields "DEFAULT VALUE" constraint if any.
A good way could be to make TUniLoader able to see no value (nor Null) was given to a column (so, still in "Unassigned" state).4 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 -
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 -
Spatial datatypes
Support for MySQL Spatial datatypes so that they could be read and written. Geometry is saved as CBLOB field, but not usable as is.
7 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 '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 -
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 -
Add savetoJSON to uniquery
As JSON more popular。
It's time to support JSON in uniquery.43 votes -
7 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 -
Implementing UpdateOptions - TIBCQuery
Two users modify the same field in the table,
Error want to show the second user to save data.-) Using a TClientDataser and TDatasetProvider, no problem, works well.
-) TFDQuery component FireDAC the Embarcadero it has the property
Property: UpdateOpcions
UpdateMode:
upWhereAll
upWhereChanged
upWhereKeyOnlyImplementing this property in TIBCQuery
solve my problem of concurrency.thanks
132 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 -
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 -
Improve data type mapping feature
Allow set field type mapping / rules by CHARSET
Ex: if db field charset is UTF8 set field as TWideStringFieldset field type mapping / rules by DOMAIN
Ex: if db field domain is DM_BOOLEAN set field as TBooleanField[Optional] Separate TFieldMappings component that allow to define custom field mappings. TConnection/TQuery should have a property of this type.
Useful when use multiple connections (for example in threads), to define mapping rules once and link all Connections to one common component.
108 votesThe first and the second features have been implemented.
-
TIBCQuery.OnScrollFinish
Implement OnScrollFinish event that is fired at the end of the scrolling process.
For example we need to adjust some elements of interface on record change, even perform an aditional sql query or other heavy calculations.
For example, if user scroll fast over 20 records in a grid, relying on AfterScroll event imply a lot of unused work. So instead executing it 20 times, we may do this once after scroll process is finished.
In fact, such kind of logic in *Dac already have it on Master/Detail "wait" magic, so it's not too much to change to have this kind…
103 votes -
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 -
Fastreport support using lazarus
Accessing firebird database from fastreport runtime designer
using lazarus.20 votes -
TIBCTransaction.OnEnd
Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.111 votes -
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
- Don't see your idea?