How use Uniquery CashUpdate mode identity field FB3?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mrUlugbek
Posts: 9
Joined: Fri 18 Nov 2011 04:21

How use Uniquery CashUpdate mode identity field FB3?

Post by mrUlugbek » Sat 17 Dec 2016 17:08

Hello
Help me how use Uniquery CashUpdate mode identity field FB3?

Create Table
id identity
name
Uniquery.sql = select * from table
generate all sql

Uniquery DMLRefresh =True
Uniquery.fields id reuqered = false
Uniquery.KeyField =ID

After ApplyUpdate i got error id value "null" etc

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How use Uniquery CashUpdate mode identity field FB3?

Post by ViktorV » Mon 19 Dec 2016 10:26

To solve the problem, please set TUniQuert.SQLInsert.Text in an empty string. For example:

Code: Select all

  UniQuery.SQLInsert.Text := '';

mrUlugbek
Posts: 9
Joined: Fri 18 Nov 2011 04:21

Re: How use Uniquery CashUpdate mode identity field FB3?

Post by mrUlugbek » Thu 22 Dec 2016 07:04

ViktorV wrote:To solve the problem, please set TUniQuert.SQLInsert.Text in an empty string. For example:

Code: Select all

  UniQuery.SQLInsert.Text := '';
Thank you for your reply
I will try

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How use Uniquery CashUpdate mode identity field FB3?

Post by ViktorV » Tue 27 Dec 2016 07:06

If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply