241 results found
-
Encryption of the input and output parameters of stored procedures
Шифрование входных и выходных параметров хранимых процедур.
В IBDac есть возможность шифровать\расшифровывать на клиенте данные. Только с хранимыми процедурами это не работает.Encryption of input and output parameters of stored procedures. There is a capability in IBDAC to encrypt/decrypt data on the client. But it doesn't work with stored procedures.
225 votes -
Threadsafe TUniAlerter for multithreaded applications
TUniAlerter.OnEvent is always called in the main application thread regardless in what thread TUniAlerters is created or used.
Devart advice is to use a synchronize, but that is not always possible or wanted. Why or you otherwise using threads?3 votes -
Green tick mark for answered queries?
Perhaps it's an idea to have an indicator on each specific post to show whether a topic has been answered?
This could be as simple as a check box indicating the post has been answered - filled in by the original requester when the requester is happy with the response(s).
Once the tick box is completed the post could be flagged with an icon - e.g. a green tick mark - and thus considered 'closed'.
Would help responders to skip those posts already answered and those wishing to find answers to skip those posts that have not yet been answered.…1 vote -
Add refreshquick to PgDAC
The RefreshQuick method (https://www.devart.com/mydac/docs/devart.mydac.tcustommydataset.refreshquick(system.boolean).htm) seems very useful to refresh only the new records from big datasets. Ideally, make it possible to specify the name of the TIMESTAMP field so we don't have to create a duplicate - mine are called "created" for example). Maybe we don't even need the TimeStamp field for Postgresql ?
1 vote -
unidump
When using mySQL as the provider it is possible to add drop and create table statements to the "backuptofile"-file. This option is not possible when using the Microsoft SQL server provider. Could you please add this option ? :-)
12 votes -
Make CachedUpdates work on master-detail datasets without requiring LocalMasterDetail
Scenario: 100K customer (master rows) with an average of 10 contact (detail) rows each... totaling about 1M detail rows.
Without CachedUpdates I set LocalMasterDetail to false, and each time I scroll on the master dataset UniDAC fetches the 10 or so detail rows from the database. I can insert, modify and delete rows and all is saved immediately (on Delete or Post).
With CachedUpdates I have to set LocalMasterDetail to true. This means UniDAC will fetch 1M detail rows and filter them out locally. With large networked databases this is really not feasible as it generates too much network traffic…
3 votes -
Implement COPY FROM/TO functionality
Implement COPY FROM/TO functionality for PostgreSQL (PgDAC component).
PostgreSQL COPY manual:
http://www.postgresql.org/docs/current/interactive/sql-copy.html103 votes -
Support of direct mode for SQLite in FreePascal (Linux)
With direct mode support external library is no longer needed - this reduce deployment complexity. In addition local database file can be encrypted - this is very useful in secured environment.
34 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 -
1 vote
-
save TUniQuery to TVirtualQuery and restore quickly
How to save TUniQuery to TVirtualQuery quickly ?
1 vote -
pack data between server(LINUX) and client(Windows)
I would like to develop server program at LINUX(Lazarus) and client program at Windows(Delphi). I need to pack dataset on server site. I am using unidac with sql to access relational database. It is better to save returned dataset to memorystream quickly and transfer the stream to client. Also I want to restore memorystream to uniquery dataset quickly.
1 vote -
dbMonitor -- update/insert/delete statements should be reflected in UpdateTransaction
if you apply two different transaction in TIBCQuery.Transaction and TIBCQuery.UpdateTransaction property, then dbMonitor will show update/insert/delete statements in TIBCQuery.Transaction branch.
Actually it should be shown in TIBCQuery.UpdateTransaction branch
RUS
Если вы применяете две различных транзакции в свойствах TBCQuery.Transaction и TIBCQuery.UpdateTransaction то dbMonitor показывает выражения update/insert/delete в ветке транзакции TBCQuery.Transaction.
Однако хотелось бы видеть в ветке TIBCQuery.UpdateTransaction3 votes -
More Features in TCRBatchmove - Events on errorr
Add Events in TCRBatchmove to react if an error occurs.
2 votes -
Retrieving Query Results Row-By-Row
PostgreSQL 9.2 has a new feature that allows results sets to be returned row by row instead of the whole result set at once.
This is a huge improvement for larger result sets.
See here for more info:
http://www.postgresql.org/docs/9.2/static/libpq-single-row-mode.html11 votes -
Add properties KeepAlive + KeepAliveInterval (maintain the connection)
The component should TUniConnection every 3000 ms (for example) to send to the server any single request (for example, "select 1 from dual"), to the gateway and the server is "seen" that the connection is active and the client is connected.
RUS:
Компонента TUniConnection должна, каждые 3000 мс (к примеру) отправлять на сервер какой-нибудь холостой запрос (к примеру, "select 1 from dual"), чтобы шлюз и сервер "видел", что соединение активно и клиент подключен.Сообщение на форуме: http://www.devart.com/ru/forums/viewtopic.php?p=2081#2081
69 votes -
Extract table metadata information
Extract a whole table metadata information, like ibx / IBExtractExtractObject.
It's useful for example replicate a table.22 votes -
Make DAC errorors more clear
When an exception is thrown by a DAC product during startup of a project - like some SQL code cant execute, then the error code wont show what form and what object created the object. If I have project with 20 forms and hundreds of MyQuerys the errr "IdObject does not exist" is not very helpfoul.
28 votes -
26 votes
- Don't see your idea?