|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | duplication of records in data search | |
| joe v 9/8/2010 6:13:43 AM | Anybody ever encounter a second set of identical records in a data search? I tried rebuilding from scratch, and the very first query was perfect, but subsequent searches doubled the results, skewing the values in the data window. I'm stumped. Joe
| |
| jeff 9/8/2010 1:34:49 PM | This appears to be a continuation from this thread from a day or two ago: http://www.jcapper.com/messageboard/TopicReader.asp?topic=819&forum=JCapper%20101 There are two ways to populate the StarterHistory Table: 1. Data Window Export 2. Build Database Routine Both are valid and both work. Here's what has happened: I had you populate the table with a Data Window Export. That gave you a table that was completely populated as of a given point in time. Afterwards, you ran a Build Database (Append) routine which added records to the table. The Build Database (Append) routine included records that were already in the table - resulting in duplicate records. The easiest way to fix this: Clear and repopulate the table using the procedure posted in the earlier thread. Do this for any and all previous folders but not the current folder you are working on. After clearing the table and repopulating it for older folders using Data Window Export(s), populate the table for the current folder by running a Build Database routine in Mode 4. Then, run all subsequent Build Database routines for the current folder in Mode 5. Continue building that folder in Mode 5 until you decide it's time for a new folder - at which point you want to perform the first build on your next folder in Mode 4... followed by sugsequent builds to that folder in Mode 5. -jp .
| |
| joe v 9/9/2010 2:49:09 PM | Jeff, I followed those directions and upon my first query following the rebuild I still had duplicate records and now all new downloads go to playlist and must be exported to SQL. Obviously I really did something wrong. Should I just delete the program and start from scratch? Joe
| |
| jeff 9/9/2010 6:03:43 PM | Delete the program? No. Clear the starterhistory table and repopulate? Yes. Or call and let me talk you through things? Yes. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |