Re: Syntax for multiple WHERE in recordset?
- From: "Bob Butler" <tiredofit@xxxxxxxxxx>
- Date: Fri, 29 Jul 2005 09:15:10 -0700
"Kahuna" <none@xxxxxxxxxxxx> wrote in message
news:Ow3UIfFlFHA.3568@xxxxxxxxxxxxxxxxxxxx
> Yep tried it Bob and fails... so far - the reason I built it this way
> was because the syntax is the only way I could get the basic query
> working - and then I extrapolated it to inbclude the Ands.
>
> Is it possible to create a command object on an un-bound control and
> build the relevant sql criteria that way and subsequently copy the
> criteria string?
Sorry, I don't understand what you are asking. ADO command objects have
nothing to do with other controls.
> I will reformat it and try your syntax again.
If it still fails post the code, the actual SQL statement and what the error
actually is.
--
Reply to the group so all can participate
VB.Net: "Fool me once..."
.
- References:
- Syntax for multiple WHERE in recordset?
- From: Kahuna
- Re: Syntax for multiple WHERE in recordset?
- From: Bob Butler
- Re: Syntax for multiple WHERE in recordset?
- From: Kahuna
- Syntax for multiple WHERE in recordset?
- Prev by Date: Re: Syntax for multiple WHERE in recordset?
- Next by Date: Retrieving the name of a datasource for a text box
- Previous by thread: Re: Syntax for multiple WHERE in recordset?
- Next by thread: Retrieving the name of a datasource for a text box
- Index(es):
Relevant Pages
|
