Devart Forums

As a workaround, you can create all columns automatically using TPgLoader.CreateColumns method.

Hello.

Thank you for the information. We have reproduced the problem and are investigating it. We will inform you as soon as we have any results.

Hello.

SELECT * FROM TableB WHERE field1 =: key -> Does not work

Please specify what you mean by "Does not work".

Try to set the TPgQuery.Options.QuoteNames option to False and check if the problem repeats.

Note: by default, PostgreSQL server creates fields with names in lowercase.

Hello.

Thank you for the information. We have reproduced the problem and are investigating it. We will inform you as soon as we have any results.

Hello.

1) In newer versions of MyDAC the ReadmeSrc.txt is replaced with the ReadmeSrc.html file.

2) If you use edition with source code:
Open %MyDAC%\Source\Lazarus1\dclmydac10.lpk file in Lazarus and press the Compile button. After that press Install button.

3) If you use trial edition:
Open %MyDAC%\Source\Lazarus1\dclmydac10.lpk file in Lazarus and press the Install button. Do not press the the Compile button for the package. Compiling will fail because there are no MyDAC sources.
Today we have released a new version of MyDAC (8.1.3), it is compatible with Lazarus 1.0.12.

Hello.

FastReport 4 UniDAC Components for C++ Builder XE4 will be added in the next UniDAC version, which we plan to release next week.

If any other questions come up, please contact us.

The point is that you are using the TZSQLProcessor component, which TZSQLProcessor.Connection property has the Nil value. As a result, an attempt to execute the following code:raises Access Violation.

To solve the issue, do the following edits in your project:
  - replace TZSQLProcessor with TUniScript;
  - instead of the TZSQLProcessor.Script property use the TUniScript.SQL property;
  - make sure that the TUniScript.Connection property points to a configured TUniConnection component.

Hello.

Please send a sample demonstrating the problem and the scripts for creating and filling the tables to dmitryk*devart*com .

If any other questions come up, please contact us.

Hello.

1) When using several listening ports simultaneously (SourcePort), a TSSHChannel instance should be created for each of them.
2) When using several applications with TSSHChannel (or several TSSHChannel instances in one application), each TSSHChannel instance should have a unique TSSHChannel.SourcePort property value, since every TSSHChannel instance opens a socket for listening via the port, specified in the TSSHChannel.SourcePort property.

Hello.

By default, Putty is trying to use both server authentication approaches: Password and KeyboardInteractive. On connection, TScSSHClient uses only one approach, that is set in the TScSSHClient.Authentication property (it is set to atPassword by default).

We are glad to see you have solved the problem. If any more issues occur, please feel free to contact us.

Hello.

TUniEncryptor is used in conjunction with TUniQuery or TUniTable. TUniEncryptor works as follows. When changing data via TUniQuery or TUniTable using Insert/Edit/Post, then the linked TUniEncryptor component will encrypt the specified fields only for the current edited record. Similarly, this component will decrypt data in these fields when opening DataSet. If you have a table filled with unencrypted data, then using this component will encrypt only added or changed records. Unchanged records will not be encrypted.
Note that not all data types can be encrypted.
You can find more detailed information on using TUniEncryptor in the "Data Encryption" article of the UniDAC help ( http://www.devart.com/unidac/docs/encryption.htm )

Hello.

When working with Large Object, you can load data to the server in the following way:

when using TUniTable: when using TUniStoredProc:

Hello.

The right way to work in a multithreaded application is to have connection (the TMyConnection component) in each thread. You can have infinite amount of queries running through one connection in one thread, but you should not run several queries from several threads through one connection.