I need some guidance on whethern the following is good programming practice.
I am running a SQL query to extract data from 2 MS Access tables.
tblORDHeader
tblORDDetail
This information then needs to be passed to a Com object to insert into a SQL database to generate the same information, in the following format
CreateHeader
"Header Information"
CreateDetailLines
"Detail Line 1"
"Detail Line 2"
etc
I am populating an ADO recordset with the result of the query and then using that to fill in the header and detail information.
Is this good programming practice, or should I be handling the header information differently.
I am running a SQL query to extract data from 2 MS Access tables.
tblORDHeader
tblORDDetail
This information then needs to be passed to a Com object to insert into a SQL database to generate the same information, in the following format
CreateHeader
"Header Information"
CreateDetailLines
"Detail Line 1"
"Detail Line 2"
etc
I am populating an ADO recordset with the result of the query and then using that to fill in the header and detail information.
Is this good programming practice, or should I be handling the header information differently.