I have data already in a database table. I am using MS SQL server 2000 as a backend and use VB 6.0 as a front end. Now I want to validate the dataset as in write a code that will check for inconsistencies in that table.
For example, for a person to be married, he/she must be > 15 years.
If married=1 and age < 15 then , too young to be married. I want to dispaly the Id for that particula record and then send it to the .txt file where I will be able to have the hard copy and then I can do the changes.
This I have to do for a very big file