|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Database Build & Data Window Question | |
| dvlander 3/22/2010 12:48:57 PM | Jeff, I'll apologize upfront because I have been JC idle for quite a while and what skills I had have become even more primitive with my layoff. I hope this a simple question to answer. I did database builds on a couple folders for 2010 (Q1 & Q2). In the Data Window when I do SQL UDM queries, it doesn't seem to matter if I switch folders, it only pulls results from the most recent folder built. For example, I did a build on Q1. Next I did a build on Q2. In the Data Window, I switched the folder to Q1 and queried a UDM. The results are from Q2. Thanks for the help. Dale
| |
| jeff 3/22/2010 2:22:13 PM | Hey Dale, Great to see you posting again! Switching folders is something you do in the Data Window when you are running it in playlist file mode. When you run the Data Window in SQL Mode, keep in mind that you are querying data sitting in the StarterHistory Table found in the c:\JCapper\Exe\JCapper2.mdb file. The data sitting in that table is the source for the queries you run. Very easy to populate the table using data from playlist files in multiple folders: 1. Put the Data Window in Playlist file mode and point the Data Window at your first target folder. 2. Click Menu, Click Exports, Click StarterHistory Table Export Clear First... and toggle a StarterHistory Table Export Clear First "ON." 3. Run an All Button query. Data from the starters in the playlist file used as the source for your query will be used to populate your StarterHistory Table. Because you cleared the table first, at this point - data from the current folder will be the only data sitting in the table. Keep going. Move to the next folder... 1. Point the Data Window at your Next target folder. 2. Click Menu, Click Exports, Click StarterHistory Table Export APPEND... and toggle a StarterHistory Table Export Clear First "ON." 3. Run an All Button query. Data from the starters in the playlist file used as the source for your query will be used to populate your StarterHistory Table... except this time because you selected Append - new data will be appended to the table. And at this point you will have data from both folders sitting in the table. 4. Run a Compact and Repair on your c:\JCapper\Exe\JCapper2.mdb file... Be sure to make a backup copy of the file too. Btw, I'm scheduled to post a program update tonight (Mon 3/22/2010)... and in that program update, one of the new features is a Data Window that enables the user to select (switch back and forth between) different JCapper2.mdb files. -jp .
| |
| dvlander 3/22/2010 11:26:53 PM | Great, Thanks Jeff.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |