|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Dear colleagues,
Is there any way to filter ADO Recordest using criteria "[SomeColumn]
NOT LIKE 'SomeExpresion'". I don't mean "NOT LIKE" criteria within SQL
statement used in Recordset.Open(that's work correctly), but in context
Recordset.Filter = "[SomeColumn] NOT LIKE 'SomeExpresion'".
Wider context: I need to obtain the index(-es) - row position
value(-s) of row(-s) within some data table, which satisfy some
multiple column criteria, including also "NOT LIKE" criteria. The data
source table is located in Excel Worksheet, and it doesn't contain
"Primary Key" - index column(row unique identifyer).
I will appreciate any help regarding this issue.
Thank You in advance. Regards. Mirom.
|
|
|