On Wed, Jun 17, 2009 at 4:08 PM, MB Software Solutions General Account < [email protected]> wrote:
> My Fox apps have never had a problem using the GetNewID stored proc that > came with Fox samples all the way back to (I think) VFP5 days. Sylvan > uses a similar set of commands but because their app uses free tables, > this code exists inside our main PRG, which is called from various areas > in the app. Not the best design, but this app was created in the early > 90s so I'm not complaining. ;-) > > We've got a vendor who's got a DotNet app (C#) that's using VFP OLEDB > and instead of RLOCK, he's using FLOCK (and calling it without even > checking the return value---yeah, I know...bad idea!). > > My question is this: I thought that RLOCK only works from your instance > of FoxPro, but I was successful in using it for years since I was > calling a common stored procedure in the database. Please confirm! > > Also, how would this outside C# vendor best be advised to approach > replicating the same logic? My first thought---because our Sylvan app > uses FREE tables, not a DBC---was for me to create a DBC that would > reside on the LAN in the FREE tables folder that would contain the > GetNewID stored proc logic and his C# app would just call that stored > proc to return a value to him? Remember that all the tables will remain > free tables, so I can't put them into this new DBC. > > Steve had emailed me offline and I appreciated that, but now I want to > know about this idea of creating a stored-proc-only dbc. Also, I should > have that DBC on the server where the free tables resides, right? I think > I couldn't have it locally because the LOCK wouldn't be respected? > > ----------------------------------- What is the insert velocity of that table, in a rate per hour or per day ? That is important to consider how to approach this from an outside of VFP POV. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
