Skip to content
← Customer Feedback for Devart

Delphi Data Access Components

Delphi Data Access Components is a line of DB connectivity solutions for such databases as: Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, Microsoft Access, DB2, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

http://www.devart.com/dac.html

Delphi Data Access Components

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve our Delphi Data Access Components?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

17 results found

  1. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. Add ability to editing some dataset's parameters simultaneously with multiselection in SDAC parameter editor

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. 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
    Verify

    Same as is in C# SqlCeEngine class.
    Thanks.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Unidac connectionstring add parameter column encryption setting=enabled

    Unidac connectionstring add parameter column encryption setting=enabled

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. SDAC Data Encryption

    Encryption parameters in SDAC Data
    It would be very very usefull to use Parameters on Insert and Update Queries

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. 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) <= :PeriodTo

    Then 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. 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 now

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
  • Don't see your idea?