241 results found
-
Make it possible to combine the Sqlite3 source code and header files with LiteDAC in the same project
Simply add #ifndef SQLITE3H_ in e.g. LiteCall.hpp.
The location is around line 460:
//-- var, const, procedure ---------------------------------------------------define DACProductName L"LiteDAC"
define SQLiteDLLName L"sqlite3.dll"
ifndef SQLITE3H_
static const System::Int8 SQLITEOK = System::Int8(0x0);
static const System::Int8 SQLITEERROR = System::Int8(0x1);1 vote -
TCRGrid make style aware
Have the TCRGrid component display with the currently selected theme style
1 vote -
Dbexpress Driver support compression for Firebird 3
Firebird over Internet is very slow, Firebird 3 solve this problem useing compress,please Implement Dbexpress Driver to support Firebird 3 compression
about firebird 3 compress :
http://www.firebirdnews.org/firebird-3-protocol-benchmark/15 votes -
Support for the TDataset.FieldOptions property in IBDAC
Support for the TDataset.FieldOptions property in IBDAC, specialy the AutoCreateMode so the TIBCQuery can add missing TFields automaticlly
19 votes -
TMSTableData Assign function not copy the data
The TMSTableData Component Assign function only copy the source table fields, but not copy the source data! I strongly recommend that can copy the all data like the TMSTable component.
for example:
self.MSTable1.First;
self.MSTableData1.Close;
self.MSTableData1.FieldDefs.Clear();
self.MSTableData1.Assign(self.MSTable1);
self.MSTableData1.Active:= true;The MSTableData1 not copy the MSTable1 data , but it copy the fields
2 votes -
TMSQuery.SaveToStream/LoadFromStream the entire data set
An optimized version of this (maybe without the need to go to/from dataset to make it go faster)
var
query: TMSQuery;
VirtualTable: TVirtualTable;
begin
query := db.CreateMSQuery( ); //returns TMSQuery
query.SQL.Text := 'select * from [table]';
query.open;
result := binary.create;
VirtualTable := TVirtualTable.Create(nil);
VirtualTable.Assign(query);
VirtualTable.saveToStream( result );
VirtualTable.free;
query.free;
end;4 votes -
Support Postgres Advanced Server
Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.
6 votes -
Install directories
You guys use several uncommon directories for 3rd party components : 1: windows\System32 for some BPL
2: Delphi\Lib for some dcp
3: Delphi\Bin for some other BPL
4: UniDAC for dcuHow about using
BDSCommon\BPL for all bpl
BDSCommon\DCP for all dcp
leaving the dcu in the lib of the unidac install directoryTo explain : As a developer i work with several virtual PCs that I have to update. I use a local SVN for that. Installing unidac is always a hassle because after the install I first have to copy everything where it's supposed to be and then…
1 vote -
Monitoring every events (insert, edit,..)
Add monitoring feature to uniDac to let developers monitor each events occured to MySQL database (insert, update, delete..) and return the result.
1 vote -
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 -
Add a way to turn off active sorting without losing the current sort order (ODAC lost this feature.)
ODAC has always allowed clearing IndexFieldNames without reverting to the original sort order. The ability to sort a dataset and then turn off active sorting is very useful (and necessary for editing a sorted dataset in a grid component.)
24 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 -
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 -
Ability to localize TCRDBGrid
CRDBGrid have only one popup where it shows "Filtered", "Filter Bar", "Search Bar" as a text and everything else is pictures on it. Or, field names which can be set by programmer.
It would be nice to be able to localize these texts in the object inspector. Should be pretty easy to implement, and would be a nice addition to the component.
0 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 -
Implement TStringField.Size restriction
DB table has column varchar(200), in application i want to restrict field size to 50 characters.
In ADO Components TStringField.size restrict string column size, but UniDAC, after open table, discard my TStringField.Size and set it to column size, that column has in DB.70 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 -
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
- Don't see your idea?