General information
Category:
The Mere Mortals Framework
Title:
NewID() - how does it work?
Greetings!
I have a business object on a form that I am using just to add records when a certain event occurs in a different business object. The event causes a custom form method to be called and a business objects records are processed in a SCAN. Records are added to the business object I mentioned first during this SCAN.
I have set the business object that I am adding records to as the Primary Business Object on the form. Also, I use NEWID() for all primary keys in this system since everything is done through views, some a little complex.
Here's some of the code:
SELECT SCANnedView
SCAN
Thisform.bizobjname.new()
REPLACE some non-PRIMARY KEY information in the bizobjview && view associated with the busines object)
Thisform.save(.f.,.t.) && save the primary business object just added record
lnID = v_bizobjview.PKID && Save the PK ID because I need to update the SCANned View with the value
REPLACE foreignkey with lnID in SCANnedView
ENDSCAN
This appears to be ok...however, the lnID will contain a value, like 28. But, when I close the application and go look at the table that was updated by v_bizobjview, the value is 29????
Also, I noticed that the NEWID() method seems to skip numbers for every single record in every single table that I am using? There must be something I am missing here?
Any ideas?
Thanks!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only