Where Clause Syntax

Yahoo Archive
1
Works like a charm. Thank you! I'm a long way from schooling with this, and my references all seem to leave out the little stuff like this...arrrggghhh!

Lynn

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Try: Dim whereClause As String = "Key1 = '" & key1 & "' AND CheckBox01 = true"
>
> --- In vantage@yahoogroups.com, "Lynn Thomas 83" <thomasl@> wrote:
> >
> > I'm working in 405A on SQL and need a syntax assist. I have an UltraCombo that populates from a UD Child table, which I've set up with code from the Tool User's Guide. That part works as advertised. But, now one of my users wants to filter the rows that populate, so that inactive rows don't appear. In the table maintenance, I set up a checkbox for 'Inactive'. But, I can't get the whereClause syntax to work right.
> >
> > The base statement is:
> >
> > Dim whereClause As String = "Key1 = '" & key1 & "'"
> >
> > and I've tried several ways of concatenating "AND Checkbox01.Checked = FALSE", but none of them return any rows. Some approaches have crashed my Vantage client altogether. If there's any documentation on how to do this, I can't find it.
> >
> > Has anyone done something like this before, and if so, would you share how?
> >
> > TIA,
> > Lynn Thomas
> > SAIC
> >
>
2
I'm working in 405A on SQL and need a syntax assist. I have an UltraCombo that populates from a UD Child table, which I've set up with code from the Tool User's Guide. That part works as advertised. But, now one of my users wants to filter the rows that populate, so that inactive rows don't appear. In the table maintenance, I set up a checkbox for 'Inactive'. But, I can't get the whereClause syntax to work right.

The base statement is:

Dim whereClause As String = "Key1 = '" & key1 & "'"

and I've tried several ways of concatenating "AND Checkbox01.Checked = FALSE", but none of them return any rows. Some approaches have crashed my Vantage client altogether. If there's any documentation on how to do this, I can't find it.

Has anyone done something like this before, and if so, would you share how?

TIA,
Lynn Thomas
SAIC
3
Try: Dim whereClause As String = "Key1 = '" & key1 & "' AND CheckBox01 = true"

--- In vantage@yahoogroups.com, "Lynn Thomas 83" <thomasl@...> wrote:
>
> I'm working in 405A on SQL and need a syntax assist. I have an UltraCombo that populates from a UD Child table, which I've set up with code from the Tool User's Guide. That part works as advertised. But, now one of my users wants to filter the rows that populate, so that inactive rows don't appear. In the table maintenance, I set up a checkbox for 'Inactive'. But, I can't get the whereClause syntax to work right.
>
> The base statement is:
>
> Dim whereClause As String = "Key1 = '" & key1 & "'"
>
> and I've tried several ways of concatenating "AND Checkbox01.Checked = FALSE", but none of them return any rows. Some approaches have crashed my Vantage client altogether. If there's any documentation on how to do this, I can't find it.
>
> Has anyone done something like this before, and if so, would you share how?
>
> TIA,
> Lynn Thomas
> SAIC
>