Print Thread
numeric(N,M) in PK with Instead of trigger
#723 07/27/00 11:48 AM
Joined: Oct 1999
Posts: 3
Tallinn, Estonia
D
Dimik Offline OP
Member
OP Offline
Member
D
Joined: Oct 1999
Posts: 3
Tallinn, Estonia
There is hard catched but very small bug in DOA 3.3.3. When you using subj, DOA try to receive ROWID by select it from table with where clause for filtering by PK. Numeric(N,M) is TFloatField in Delphi _BUT_ DOA try to compare it with inserted value usign "=" in where. I think it is clear now why I get an error ('Error determining ROWID: no record found') when I try to insert a new row into dataset.

[This message has been edited by Dimik (edited 27 July 2000).]

Re: numeric(N,M) in PK with Instead of trigger
#724 07/27/00 05:40 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Very tricky! Wel'll see what we can do about this. What are the values of N and M in your situation?

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


Marco Kalter
Allround Automations
Re: numeric(N,M) in PK with Instead of trigger
#725 07/27/00 06:09 PM
Joined: Oct 1999
Posts: 3
Tallinn, Estonia
D
Dimik Offline OP
Member
OP Offline
Member
D
Joined: Oct 1999
Posts: 3
Tallinn, Estonia
N>M>0 [Linked Image]
But if it is has sense: N=13, M=7


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 14 (0.011s) Memory: 2.5005 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-27 10:17:55 UTC
Valid HTML 5 and Valid CSS