Re: Fields that match condition

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/20/04 

Date: Mon, 19 Jul 2004 22:34:19 -0400

Hi,

If you just getting recordset from somewhere (not SQL), then I do not think
you can find it out which fields where involved into the selection criteria.
In a case of SQL you will know it only from the query 

-- 
Val Mazur
Microsoft MVP
"Julio" <Julio@discussions.microsoft.com> wrote in message 
news:2292DE5E-7189-461F-AFC6-8876DDCCDEFA@microsoft.com...
> My recordset brings around 190 fields, and i need to know in wich fields 
> the value match the condition
>
> "Val Mazur" wrote:
>
>> Hi Julio,
>>
>> When you build filter string, you use specific field names and if you 
>> have
>> matching records, then it means all these fields are matched. I think 
>> your
>> question is not so clear. Could you please specify what you try to 
>> achieve?
>> -- 
>> Val Mazur
>> Microsoft MVP
>>
>>
>> "Julio" <Julio@discussions.microsoft.com> wrote in message
>> news:84620D2F-8E45-4A85-9EDE-A2034D205890@microsoft.com...
>> > Is there any way to know which are the fields that match a condition 
>> > using
>> > the Filter Property?
>> >
>> > Thanks in advance
>> >
>> > Julio Cotroneo
>>
>>
>>

Relevant Pages

  • Re: Fields that match condition
    ... Julio Cotroneo ... "Val Mazur" wrote: ... > If you just getting recordset from somewhere (not SQL), ...
    (microsoft.public.data.ado)
  • Re: Emailing a Report
    ... the reason Debug.Print was done was to test the SQL of what is being generated. ... If you will add and change data here, you need to set this up as a main/subform -- or just a main form that DISPLAYS data from Users and allows modifications to Agreements. ... If you are just going to send Agreements, then AgrID should be added to the form RecordSet so you can capture it. ... maybe also some kind of category for this followup type ...
    (microsoft.public.access.modulesdaovba)
  • Re: What is the advantage of Event programming?
    ... >> dice what lumps of data you need. ... which wouldn't work if the recordset has more than ... >My knowledge on using SQL statements is somewhat limited. ... Requesting a limited number of records at a time, was useful in the old days ...
    (microsoft.public.vb.general.discussion)
  • Re: REPOST: One Web Service updates SQL, the other cant
    ... insert is executed a reference to rs.eof is invalid and the program bombs. ... > get recordset back and ADO could generate error here. ... Another instance of the same Web Service code, ... >> Watching both the debugger and the trace, SQL is receiving what I send ...
    (microsoft.public.vb.database.ado)
  • Re: using Command to set Parameters and Recordset to retrive the Query
    ... doesn't the rsData will be interpretate as an input parameter in the SP? ... >> Query and retrive the Recordset so I can use the Paging property ... > Even if this technique of using the parameters in the ORDER BY does work for> you, I suspect that this will defeat your objective of preventing sql> injection. ... See below for a more efficient solution> using a stored procedure. ...
    (microsoft.public.inetserver.asp.general)