Here's the deal, I am working with a Fox Pro Database that has seven tables, I wrote a program that takes that a comma delimited text file, puts it into a cursor, and then from that cursor updates the record in the table...
The update procedure is works as follows, One of the employees is in charge of maintaining sample numbers and information on that, collection date, etc. This is inserted into the database by hand when the samples come in. The samples are then set to a lab to be analyzed, results returned are in the form of a comma delimited text file...with each sample on a different line. This information has to be put back into the database matching sample num to sample num...no new records are added, just updated...
My program works great...All, the data is updated correctly...
I know this by going to the respective table, searching for the sample number(PK) and verifying the data....
My update routine also works wonderful, I start the manual update program, search for the sample_num, and get the same information that is currently in the database....everything matches up....
The problem comes with the serch routine...It is this routine that we let employees not associated with the data input use, basically lets them run a search based on particular criteria, and then output that information to a report....(Here's the Problem)the information returned from the search only includes data that is manually entered not the information that was updated using the program that I wrote. It reads the field and returns a blank field... For instance, Sample_Num, Collection_date, Collector, are all returned...Data input manually, carbon, magnesium, floride, ph, etc., data input by the program, doesn't show up, but is in the database....
Any suggestions,
Things I've checked...
My routines are all pointing at the right tables...In fact, before I start the Search/Input routines, I execute the command close all databases, run the routine, and browse the tables that are opened(by the program), search those tables for the sample_num, and the data is there....
I run the query at embedded in the program at the command prompt of the database, and all the data is returned....
I've reindexed all the tables after the updates were done....
I've rewritten the search routine from scratch...
Anyway, I hope someone else has an idea, because I am fresh out....
Thanks...
The update procedure is works as follows, One of the employees is in charge of maintaining sample numbers and information on that, collection date, etc. This is inserted into the database by hand when the samples come in. The samples are then set to a lab to be analyzed, results returned are in the form of a comma delimited text file...with each sample on a different line. This information has to be put back into the database matching sample num to sample num...no new records are added, just updated...
My program works great...All, the data is updated correctly...
I know this by going to the respective table, searching for the sample number(PK) and verifying the data....
My update routine also works wonderful, I start the manual update program, search for the sample_num, and get the same information that is currently in the database....everything matches up....
The problem comes with the serch routine...It is this routine that we let employees not associated with the data input use, basically lets them run a search based on particular criteria, and then output that information to a report....(Here's the Problem)the information returned from the search only includes data that is manually entered not the information that was updated using the program that I wrote. It reads the field and returns a blank field... For instance, Sample_Num, Collection_date, Collector, are all returned...Data input manually, carbon, magnesium, floride, ph, etc., data input by the program, doesn't show up, but is in the database....
Any suggestions,
Things I've checked...
My routines are all pointing at the right tables...In fact, before I start the Search/Input routines, I execute the command close all databases, run the routine, and browse the tables that are opened(by the program), search those tables for the sample_num, and the data is there....
I run the query at embedded in the program at the command prompt of the database, and all the data is returned....
I've reindexed all the tables after the updates were done....
I've rewritten the search routine from scratch...
Anyway, I hope someone else has an idea, because I am fresh out....
Thanks...