On Thu, Apr 22, 2010 at 11:43 PM, MB Software Solutions, LLC <[email protected]> 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. -----------------------------------
Michael, my suggestion was for Rafael to make a function that extracted a key VALUE from SQL Server much like you would call a com object to do a process and give you a result. Use that VALE in the fox dbf table(s) as the PKey. Rafael needed a Key Generator, that is all. I was not suggesting that he co-mingle data between dbf and mdf yet. Just use SQL to produce a key for you. Over time you could consider placing more data in that container or never approach the subject. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
