17 results found
-
Implementing OpenDatasets in Direct mode
Procedure TCustomMSConnection.OpenDatasets doesn't work with Direct mode (MSConnection.Options.Provider := prDirect) but works with ODBC or SQL Native Client provider. I suggest implementing it in Direct mode.
3 votes -
Allow us to copy parameters in dbMonitor
In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.
Or can I download the source code for dbMonitor and edit it myself?
thanks,
Jon.
3 votes -
Implmentation of MSSQL Active Directory Authentication
dbExpress driver for MSSQL with Active Directory Authentication.
Customers want to connect to Azure MSSQL database. Only AD Authentication is allowed.
Maybe same idea as https://devart.uservoice.com/forums/104635-delphi-data-access-components/suggestions/34764841-implementation-of-the-new-authenticatthod-of-newer, but for dbExpress SQL Server driver.
17 votes -
Add ability TMSDump to dump all of database (not only data) to sql script. i.e schema - create statement, sp,triggers, etc.
The same functionality which has dbforge studio or ssms.
1 vote -
Add Support For SQL Server "Always Encrypted"
SQL Server now has a new security feature called "Always Encrypted". This is a recognised Microsoft solution for encrypting certain sensitive database columns to meet European Union GDPR regulations. Please add "Always Encrypted" support into Devart SQL Server data access components. This is a recognised approved solution to SQL Server DBA's.
1 vote -
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 -
Unidac connectionstring add parameter column encryption setting=enabled
Unidac connectionstring add parameter column encryption setting=enabled
12 votes -
SDAC Data Encryption
Encryption parameters in SDAC Data
It would be very very usefull to use Parameters on Insert and Update Queries3 votes -
Do not create duplicate parameters when a parametername is used multiple times in a query text
When you have a query like
select *
from mytable
where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodToThen the params property of a TMSQuery component now contains the parameter 'PeriodTo' twice. This behaviour differs from the behaviour of TUniQuery. I think the behaviour of TMSQuery needs to be changed such that is has the behaviour of TUniQuery.
2 votes -
Allow to connect with another Windows User
When TMSConnection.Authentication is auWindows the username is the currently logged in user, it woudl be good to have a way to connect as another user. There could be a new property TMSConnection.ImpersonateUser, if this is set and auWindows is set the connection will be done as if that user is logged in.
2 votes -
16 votes
-
Add support for xml, image and text fields.
I can make TVirtualTable.Assign( TMSQuery ), but xml and other blob fields are lost. A great pity!
9 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 -
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 -
include scheme as folows scheme.storedprocedurename in TUniStoredProc
Please include the scheme name of the stored procedure because now you have to include it manually, and if you dont it throws an error can find stored procedure, if i run MyStoredProcedure it throws an error but if i change it to MyScheme.MyStoredProcedure manually it works.
3 votes -
Implement Compact, Repair, Shrink, Verify to SQL Server Compact database
I would like to see SDAC implementation of next methods to SQL Server Compact database connection:
Compact
Repair
Shrink
VerifySame as is in C# SqlCeEngine class.
Thanks.15 votes -
Export XML to XSD schema
ADD new function to export the XML from your table
components in a format compliant with the XSD schema
instead of the XDR format you're using now1 vote
- Don't see your idea?