in my project i used vb6 and oracle. the connection method is DAO. i can execute query by writing --- Set rs = db.OpenRecordset("select * from patient_profile", dbOpenDynaset, dbExecDirect, dbOptimisticValue)--- but when i am going to execute -- Set rs = db.OpenRecordset("select max(id) from patient_profile", dbOpenDynaset, dbExecDirect, dbOptimisticValue)-- it gives me error, and also when i used to distnict function its show error. plz help me. how can i solve it?
plz reply me as soon as possible.

what is the error?

i have solved my problem. thnak u. if u want that code i can give u. so thnx again

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.