>>Thanks, I was hoping you would see this *g*. I have read some of your other posts.
>>
>>So you have a SQL Server table (rather than a VFP table) that keeps track of the next PK for a given table, and you call the stored procedure from VFP, VB, or some other client? And the stored procedure accepts the name of a table, gets the next PK, then bumps up the value and stores it in the table? Are you using Integer keys?
>
>Yes to SQL Server table question. And yes the SP can be called from any front end. Yes, I am currently using integers but because the PKs are generated in a user-defined SP and not some WinAPI call or SQL function, it can be easily changed (relatively). ;-)
Thanks. I am reading up on sprocs now. One more question: what are good sources for learning SQL Server 7.0 from a VFP perspective? I have the pre-release version of the Hentzenwerke book on Client Server with VFP and SQL Server, as well as Professional SQL Server 7.0 Programming from Wrox. Can you recommend any magazines, or any online sources that you use? TIA.
Chris McCandless
Red Sky Software