Remember to use TRIM function when comparing data in two recordsets in LotusScript. After an ADO Database Connection has been created, create the Recordset. Proceed to extract, transform and/or load your data. This is an example of appending data to a recordset. In this case from SQL to DB2. ==================================================================== Do While Not SQLRS.EOF And Not Db2RS.EOF And Not Done dubugthis = "Inside update" record = Trim (Db2RS("YourID").Value) & " - " & Trim (projRS("YourOtherID").Value) Print record If Trim(Db2RS("YourID").Value) = Trim(projRS("YourOtherID").Value) Then Db2RS.MoveNext projRS.MoveNext ...
A repository of information related to STEM education, software integration and development.