Devart Forums

Hi,
I can´t insert a record using a UniQuery+DSP+CDS , but , i can read and update records in the SGDB.
What hapened ?
I don't changed any properties in UniQuery!
I only replace the IBOQuery to UniQuery.
After this replace, my application works fine for read and update , but don't insert records ?????
Help me!

Excuse my poor english!

Hi, Emerson.

I use Unidac and midas with Firebird 2.1 and SqlServer 2008.

To use Unidac with Midas you have to:

1 - Use separate DataModule with Uniconnection,
one transaction configured with readonly = true (read transaction)
one transaction configured with readonly = false (write transaction)

2 -Don't put any UniQuery in the same datamodule where Uniconnection and these two transaction components are.

3 - Each Uniquery component must have Unidirectional property = True
Transaction and update transaction properties configured with the read transaction and write transactions of the uniconnection datamodule.

4 - Be careful with ProviderFlags of the Uniquery TFields.
Primary key fields must be: [pfInUpdate,pfInWhere,pfInKey]
other fields only with [pfInUpdate] or Datasetprovider can't generate correct update and insert sql instructions (it's not Unidac specific situation).

If you follow these steps i think you will not have problems.

Best regards.

Joao Cadilhe.

Hi João

Thank you about your explanation!!!

Great!

After this adjusts Tier-Midas in insert mode works fine and speed up of IBOQuery.

Congratulations.