i will develop a program that catches an event from an external app. then save the textfile data to sql
okay i'll give you an example
there is an existing system that checks the static energy of a person and a text file database,
once the static checking process is finished the existing system will save the information to a text file
the system that I will develop will fetch the data from the textfile..
or should I say the system that I will develop will save only the textfile to database after the process from the external application finishes
the part that when will be my program will execute the saving to sql..
it's the "when" , my program should execute "only" when the external programs process ends, it's kinda what event should I use, i'ts like my program will run in background and monitors the process of the existing system..
well, that's another problem.. because i don't want any records to be duplicated..
I need to stick on what my client want to happen so i'm really on to how to figure out, it's like my program only reacts after the external program ends a certain process
Consider this and check if this suits your requirement.
1. Initially insert al other details into the Person table except statis_energy column and set the se_status to 0.
2. when the external process runs creat the output into a text file with name same as ID of the person and update the status in the table to 1.
continue this process for all other person details.
3. Run a procedure to read the text file and update the static_energy column of the corresponding record (based on ID).
You keep accepting all options, it appears you've not stated clearly what you want to do. That's the first thing to do
hmmmm.. because those options are possible?, I think i'm on the right path, but, that existing application that comes with the machine gives me the problem, I don't know how can my program will react everytime that machine finishes a certain process..