Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
I created an updatable recordset that fetch records from two related tables Employer and Employees and I join dis tables inorder to get the name of Employer and here's my code:
Dim EmployeesRs as ADODB.Recordset
odal.GetRecordset "SELECT A.m0_Employees,A.SSSNum,A.FullName,B.EmployerName,A.BirthDate,A.DateHired,A.DateSep FROM Employees A INNER JOIN Employer B ON A.f0_Employer = B.m0_Employer ORDER BY A.m0_Employees", EmployeesRs, adUseClient, adOpenStatic, adLockOptimistic
GetRecordset is a method from a Class(odal) that would Return a Recordset to EmployeesRs
My problem is when i delete a record in Employees Recordset(EmployeesRs.Delete), The referenced Record in Employer will also deleted. My purpose of having dis recordset is 4 my data entry.
I came up with one solution but i think it's not a good practice, I use 2 recordset one 4 data entry(updatable recordset)and one 4 viewing only(read only recordset that uses join)
Maybe there is a good solution 4 dis, I want to use only 1 recordset 4 the sake of performance.....Thanks in advance
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement