>I have not added any of my own stored procedures, but kbizobj.OnNew() queries the backend for sp_newid(). I am assuming that there is a store procedure created in SQL Server that handles this. Maybe I am mistaken?
>
> *-------------------------------------------------------
> =SQLEXEC(lnHandle, "sp_NewID " + lcBaseTable, "newid")
>
> lcDefaultValue = "newid." + FIELD(1)
I have no first hand info on this and I am rolling out my Y2k system this month I can't set up a test db and check this. But FWIW, the BizObject knows that this is a remote view. For local data it checks to itself (id.dbf) and for a remote db it checks to the real DB.
In my past work we would hit the SP on the databse, and that DB was from a third party vendor that did a heck of key, id# + date + time. That is all via the insert triger on the table that is part of the setup of SQL Server. So yourbizobject1.new() should work just fine IMUO. (untested oppinion).
Jump on in here Kevin if this is wrong.