G'day! Any client-server gurus out there?
I've installed SQL Server, run the upsizing wizard, and I'm playing around with the forms in one of my apps in an attempt to convert to client-server. This is for educational purposes only - I'm not going to be using it in production this way - at least not for a while.
I now have a remote view for my 'student' table , rather than a local view - works like a charm. EXCEPT when I try to add a new student. The existing code has a newid() method as a stored procedure in the DBC, which uses the ID table to get the next primary key value for the new student.
However, the Codebook5 Onnew method in the bizobj calls a stored procedure on the SQL server to get the ID. Of course, there ain't no such animal.
What is the best way to proceed? I could try to figure out how to write the NewID() code as a stored procedure on the SQL server. (If any of you have done this, an example would help)
Is there another way (a better way?) to do this?
Any pointers to sources on this kind of stuff?
Thanks
Larry
Larry Bradley (lhbradley .at. igs D.O.T net)
FoxPro Developer
Ottawa, Canada
©2001 Larry Bradley |
