Resolved insert SQL incorrect

[jimpoe]

DOA 3.4.6.1
Delphi 7
Oracle 8.1.7.4.1
I am using many OracleDatasets in a datasnap server. I have a few datasets that are generating the wrong insert SQL. The select is 'SELECT A.*, ROWID FROM PUBDOC_CAT A
ORDER BY RANK' It returns 5 columns, no LOB type. We populate the key column with a number on the client. We populate 3 other columns, post, and applyupdates. The insert sql includes the three columns but not the key column. Anyone know why? The only event handler on the provider is the DataRequest event. This would not interfere with the insert.

Thanks

 

[Marco Kalter]

Are these datasets connected to a TDataSetProvider? If so, it ResolveToDataSet set to True or False?

------------------
Marco Kalter
Allround Automations

 

[jimpoe]

Originally posted by mkalter:
Are these datasets connected to a TDataSetProvider? If so, it ResolveToDataSet set to True or False?

Hi,

ResolveToDataSet is False. This may not be a DOA issue. Looking further, I found this:

I have a master/detail on my DataSnap appserver. When I do an insert
into the master, the primary key column contains a value that was
populated on the client. During the resolving of the sql in
Provider.GetInsertSQL, the ReadOnly property of this column is True.
This results in the column and its value not being included in the
insert statement. The column's ReadOnly property is set to False on
the client dataset and the server's dataset. Where and why would the
ReadOnly property be set to True?

Thanks for any help.

 

[Marco Kalter]

I have just sent you a modified OracleData unit that may fix this.

------------------
Marco Kalter
Allround Automations

 

[Garrido]

I'm using DOA 4.0.7.1 in Delphi 2007 and having the same problem.
This issue still not resolved? Can you send me this OracleData unit that resolves this?

Tks

I have just sent you a modified OracleData unit that may fix this.

------------------
Marco Kalter
Allround Automations

 

[Marco Kalter]

This issue is resolved in 4.0.7. Are you sure you are having the same problem?