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!
Unidac and Midas Tecnology
-
Joao Cadilhe
- Posts: 27
- Joined: Wed 30 Jan 2008 19:29
- Location: Brazil
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.
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.
-
Emerson_Azevedo
- Posts: 4
- Joined: Mon 02 Mar 2009 14:26
Thank's
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.
Thank you about your explanation!!!
Great!
After this adjusts Tier-Midas in insert mode works fine and speed up of IBOQuery.
Congratulations.