it that way,
> though it may not be as maintainable if you did X.
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
> Bourke
> Sent: Wednesday, May 26, 2021 8:42 AM
> To: profoxt...@leafe.com
> Subject: R
Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Wednesday, May 26, 2021 8:42 AM
To: profoxt...@leafe.com
Subject: Re: Form designer rules?
On Mon, 24 May 2021, at 3:54 PM, Eric Selje wrote:
> I know you're all probably tired of hearing this drumb
On Mon, 24 May 2021, at 3:54 PM, Eric Selje wrote:
> I know you're all probably tired of hearing this drumbeat, but having SQL
> statements in UI controls is a bad idea. Do what you can to separate that
> out.
I agree.
___
Post Messages to:
I know you're all probably tired of hearing this drumbeat, but having SQL
statements in UI controls is a bad idea. Do what you can to separate that
out.
Eric
On Sun, May 23, 2021 at 11:07 PM Tracy Pearson
wrote:
> Combobox1 selects into a cursor. Use that cursor name in the where clause
> of
Combobox1 selects into a cursor. Use that cursor name in the where clause of
the select statement in combobox2.
In the valid event of combobox1, call the requery method of combobox2.
The initial queries are processed after the form load event. They only requery
when told to.
HTH
Tracy
On May
My data is in a table called labels with three fields, space, location, and
label.
I thought my problems were solved but now when I setup my second combo box
with the row source set to
select location distinct from labels where labels.space =
thisform.combo1.value = labels.space into cursor T2
I
Tracy,
I did another test form using days of the week like yours. I still got the
error. Then I removed the quotes around the CSL statement and it worked!
Somewhere in my surfing I had read that the quotes were required but that
is apparently incorrect.
More details:
1. When does the SQL
Hi Joe,
don't put in quotes or double quotes the sql statement!
Gianni
On Sat, 22 May 2021 15:03:50 -0400, Joe Yoder wrote:
I want to use an sql select statement as the row source for a combo box..
- When I set the row source type to 3-SQL and enter the row source as
"select space
Hi Joe,
Those settings are working for me in my quick test.
Does the SQL statement you have in the RowSource work in code?
As a test I built a cursor with the days of the week in it in the Load event
of a form.
CREATE CURSOR ComboBoxData (id i, displaytext c(30))
I set the
9 matches
Mail list logo
