Devart Forums

MaximG

VirtualQuery is built using the SQLite engine. When the SQLite engine cannot determine the type of the field returned by the query, we create the corresponding Field of the Memo type. In order for such fields to be created with the type required by a developer, you can use DataTypeMapping, a special mechanism provided by our components. You can use this feature both in Design Time with the help of VirtulalQuery Editor, and in Run Time:

VirtualQuery.DataTypeMap.AddFieldNameRule ('My_Memo_txt', ftString, 255);

MaximG

Indeed, a standard dataset component cannot provide a unified text output from disparate queries. This task can be accomplished by using specialized reporting components.

MaximG

When using the Direct mode, you don't have to set the HomeName property or install any additional components.
The Direct mode is embedded in our components. Please try to specify the server address as follows: servername:1521:sn=XE, where servername is the hostname of the Windows 10 instance running in the VM.

MaximG

When using CLOB parameters, we recommend explicitly specifying their type. In any case, we will investigate the behavior you describe. For this, compose and send us a small sample, which when executed causes the "value is too long" error. It is convenient to do it using the e-support form (https://www.devart.com/company/contactform.html)

MaximG

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning UniDAC usage.

MaximG

No, it wasn't fixed in ODAC 12.0.2. We are working on the necessary changes.

MaximG

Thank you for your patience. We will investigate the described issue and let you know the results shortly.

MaximG

As I understand, you want to combine output from multiple queries into a single text output. You can use OraQuery to run queries and save the results to a file in the XML format, which you can later parse and produce a report.

MaximG

To execute the VACUUM command in the Direct mode, use the ForceCreateDatabase option :

Code: Select all

...
  UniConnection: TUniConnection;
begin
  UniConnection := TUniConnection.Create(nil);
  try
    UniConnection.ProviderName := 'SQLite';
    UniConnection.Database := 'C:\Users\Fejleszto\Documents\test.db';
    UniConnection.SpecificOptions.Values['Direct'] := 'True';
    UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'True';
    UniConnection.Connect;
    UniConnection.ExecSQL('VACUUM main INTO ''C:\\Users\\Fejleszto\\Documents\\test123.db''');
  finally
    UniConnection.Free;
  end;
...

MaximG

Hi!
Thanks for contacting us! Working with the TMyConnection class is done by calling EntityDAC.DataProvider.MyDAC.
This provider does not provide the ability to use the TMyConnection features you are interested in.
A possible solution is to create your own provider. Implementation examples of such providers are provided with EntityDAC :

[EntityDAC folder]\Demos\DataProviders\

MaximG

Hi Jens!

Thanks for following up. We are currently investigating various ways of solving this issue. We will keep you posted.

MaximG

Hi Mark!

Thanks for your inquiry!
Please Try running the query you provided using the OPENQUERY (or EXEC) statement and let us know the results.

MaximG

Indeed, setting up an installed Oracle client is an additional operation that does not depend on the operation of our access components: https://www.oracle.com/database/technol ... lang.html
We will add the relevant recommendation to our Knowledge Base so that our users can find the right solution as quickly as possible if necessary.
To set the required codepage you can try using the CHARSET option: https://docs.devart.com/unidac/using-oracle.htm

MaximG

Please feel free to contact us if you have any questions

MaximG

Please describe the issue in more detail. Which exact error you get when attempting to load UniDAC 9.1.1 ?

Devart Forums

Search found 1951 matches

Re: Memo and DBGrid

Re: Output stream, spooling

Re: How to connect to Oracle 11g database with Direct mode? URGENT

Re: Oracle - error "value is too long" assigning huge string to clob parameter

Re: Unidac - SQLite - VACUUM Into

Re: Using SQL*Net Native Encryption with Direct TCP/IP

Re: Call a DB function / procedure from Delphi

Re: Output stream, spooling

Re: Unidac - SQLite - VACUUM Into

Re: EntityDac/MyDac Lost Connection

Re: Problem with DBMS_OUTPUT.GET_LINES

Re: SQL Server - Linked Server to Salesforce JOINs error

Re: Unidac - Oracle - Batch

Re: Free vs Delete

Re: unidac 9.1.1 sqlite provider