> > > Hallo, > > hab ein kleines Problem - ich mu� ein Recordset nachtr�glich > nach einen > Monatswert in einem Datumsfeld filtern (gegen eine Oracle DB). > > Mein Ansatz war : > > objRS.filter = "to_number(to_char(pgueltig,mm)) <= " & > clng(pi_lPeriode) > (oracle syntax) > geht nat�rlich nicht - > > aber habe ich bei Filter �berhaupt die M�glichkeit, so etwas > zu realisiern, > oder bleibt mir nichts anderes �brig, als das Recordset zu loopen ? >
Das filter property kann nicht beliebig komplexe ausdr�cke enthalten, wie z.B. eine where clause... MSDN Lib: The criteria string is made up of clauses in the form FieldName-Operator-Value (for example, "LastName = 'Smith'"). You can create compound clauses by concatenating individual clauses with AND (for example, "LastName = 'Smith' AND FirstName = 'John'") or OR (for example, "LastName = 'Smith' OR LastName = 'Jones'"). Use the following guidelines for criteria strings -- Operator must be one of the following: <, >, <=, >=, <>, =, or LIKE. -- There is no precedence between AND and OR. Clauses can be grouped within parentheses. However, you cannot group clauses joined by an OR and then join the group to another clause with an AND, like this: (LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John' Instead, you would construct this filter as (LastName = 'Smith' AND FirstName = 'John') OR (LastName = 'Jones' AND FirstName = 'John') In a LIKE clause, you can use a wildcard at the beginning and end of the pattern (for example, LastName Like '*mit*'), or only at the end of the pattern (for example, LastName Like 'Smit*'). Claudius | [aspdedatabase] als [email protected] subscribed | http://www.aspgerman.com/archiv/aspdedatabase/ = Listenarchiv | Sie k�nnen sich unter folgender URL an- und abmelden: | http://www.aspgerman.com/aspgerman/listen/anmelden/aspdedatabase.asp
