MB Software Solutions, LLC wrote: > Stephen Russell wrote: > >> On Thu, Apr 22, 2010 at 10:36 AM, Rafael Copquin <[email protected]> >> wrote: >> >>> I do not understand you fully. Are you suggesting I use SQL Server for >>> that single table, while the rest of the app uses DBF's? >>> >> ---------------- >> >> Exactly. >> >> If you need a different tool for a specialized functionality then get >> it and implement it. >> > > > What about JOINs he'll have to do? Mixing DBFs and SQL Server isn't a > good strategy, imo. > Getting away from the main subject I think, but I do that all the time with good results. You SQLExec() to the remote server and get one or more cursors which can then be joined with dbf's at will. Only caveat is with big data sets (over 1,000,000 lines) where you *might* loose some data (this has only happened sparsely on complicated long queries). You might protect from that by also adding a """ select @@ROWCOUNT as 'RowCount'""" after every select in your query script (sent to MS SQLServer) and checking your return cursor has that many lines.
--- 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.
