The temp views must each be a single table view. If you have more than
one table in the view it is not editable. On the other hand, you may be
doing my stupid and trying to edit while in the form designer. I must
admit that I am using temp tables rather than views, as mentioned below.
Steve Martin wrote:
Since I'm adding the LinkCol column to each of the temp views, I suppose
it is, by definition, a multiple table view; because I don't seem to be
able to edit the data within the form.
So close and yet...
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert
Berry
Sent: Thursday, April 17, 2008 9:14 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Forms and multiple tables
You are more than welcome.
How I actually use this is to dynamically display a list of customers in
a form used to set report parameters. As the user selects parameters I
change the value of LinkCol in a temporary table based on the user
parameters. In this case, it is whether the Customer is Active, Inactive
or All customers, and whether or not the customer has Active, Inactive
or Any Parts.
The temp table is in a scrolling region, and also has a T/F check box in
the region and a column in the temp table CustPick TEXT (1) that the
user can use to select one or more customers. By changing the value of
LinkCol in the temp table to 1 or some other number the customers
magically appear and disappear.
Albert
Steve Martin wrote:
That would work! A little more overhead but hey, nobody would see
it...dbgrids and dbnavigators would still work...gotta nice beat, easy
to dance to...I'll give it a 7.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert
Berry
Sent: Thursday, April 17, 2008 8:47 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Forms and multiple tables
You may create single table views for each table that have a column in
common, even though such a column does not exist. I use this for drop
down menus quite often.
CREATE TEMP VIEW vwCusts (LinkCol, CustID, CustName) AS +
SELECT 1, CustID, CustName FROM Customers
CREATE TEMP VIEW vwCities (LinkCol, CityName, State) AS +
SELECT 1, CityName, State FROM States
Ridiculous example, but you get the idea.
Albert
Steve Martin wrote:
Quick question for the group...
I want to use an Enhanced Control Tab in order to edit multiple
tables
in a single form. The tables have nothing in common. Is there a way
to
fool the form so that it isn't looking for common columns?
Thanks,
Steve
