Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
I'm still new at using Perl to drive OLE Automation. I'm to the point where I need to specify enumeration values as function arguments, and I am having problems stumbling onto the right syntax which makes everyone happy.
As for the particulars, I'm trying to get the RecordSet given a QueryDef. According to what I have found on MSDN, the format is:
Set recordset = object.OpenRecordset(type, options, lockedits)where type, options, and lockedits are all enumerations defined as RecordsetTypeEnum, RecordsetOptionEnum, and LockTypeEnum defined in the Microsoft DAO 3.6 Object Library type library.
For onlookers, ActiveState's OLE Browser is cool for finding what classes, methods, properties, and enumerations are exposed through all installed type libraries.
Thanks for any insight that you can provide.j