Hello,
I'm converting some VBA code into C++! Some problems I'm having is ... converting the following VBA code shown below:
Dim Temp As ADODB.Recordset, F As ADODB.Field
Temp = New ADODB.Recordset
int i = 0
For Each F In tableOne.Fields
Temp.Fields.Append(tableNames(0) & F.Name, F.Type, F.DefinedSize, F.Attributes And adFldisNullable)
With Temp(tableNames(0) & F.Name)
.Precision = F.Precision
.NumericScale = F.NumericScale
End With
i = i + 1
Next
I would like to loop through the fields like the code shown above using CRecordsets and append them into a new CRecordset...
is that possible? if not, what other ways can I do this?