I am automating a healthcare application in which I have to update prescription status from Uncollected to NoShow.
Please help me with the code to connect to the SQL SERVER 2000 database and a query to update the status
Search this forum with the keyword of "ADODB" you will be getting your code.
i have never seen bugs sleeping
Chakravarthi are you using database for storing test data ; or you are updating applications database
or to put it other ways , when is it expected from us to make changes in the application database
To err is to CODERS , to TEST is divine
I have to connect to the applications database, update a prescription status 'Uncollected' to 'No Show'.