Extract Files With SQL Version
Extract Files With SQL Version
Version 10 R R SQL____I am familiar with exporting either ^Result Sets^ or Xbase DBF files and calling subsequent R R Reports using the CMD file script method using the XBase version of R R. This has allowed me to use a single extract and different Reports can be called and Printed from a single extraction.____I often find this the best way to create totals from previously totalled fields especially when a requirement to ^Scan multiple DBF files and create multiple totals within them, i.e. Totals of Totals.__This also affords me ease with final printed layouts not having to concern myself with Groups/Sorting other than that for Print Layout Purposes.____My current SQL requirement would best be solved if I extract data and to use that extract with subsequent Reports. Also in the longer term when I convert some 250 Reports from Xbase to SQL it will not mean a complete re-write.____Based on a similar requirement how do I use a ^Result Set^ with the SQL version i.e. I cannot find an MDB export capability. We also use Advantage Database Server and Microsoft SQL not just Access so a solution for all would be good.________
=> RE: Extract Files With SQL Version
Result set creates a Foxpro table in the SQL version just like it does in the Xbase. There is no provision for direct export to MDB format.____Kathleen__R&R Support
=> RE: Extract Files With SQL Version
Thanks Kathleen,____I understand that, it is not the extracting of files that I have a problem with. I need to link the extract to the existing database to enable me to create further queries based upon the ^extracted file^ and the original database.____e.g. go find records in the original Access Database that match the ^extract file^.____That^s what I am familiar with doing almost as a matter of course. Some of my original reports use multiple extracts to get a variety of totals and then print them nicely on the report____e.g. on a SINGLE HORIZONTAL LINE (similar to a spread sheet I can print:____Total value of stock from data file no 1__Total amount in stock at ^date^ from data file no 2__Total value of stock item sold in the period. from data file no 3__Last used upto (total i.e. Max date) from data file no 4____By starting with the Xbase version and exporting a tempary Xbase file it has meant that I can total individual files and then link all the Xbase extract files and chosen original files together making it simple for the the final print report. Otherwise due to required Grouping/Sorting it is not possible to produce all the above on a single line. This is something which I do on several hundred different Xbase reports.____I can only choose from one data Source which is Access based so therefor need to link that to the extracted file.____I hope this is clear, it is not easy to explain in written form____I will also send you a separate email attaching my CMD and TXT files which may help you understand what I mean________