What about running a cursor that created and populates a temp table with your
sales and company information, base your form off of that, and update your real
table based on the temp. Maybe put some kind of update function in the Table
Setting -- On Row Exit. You sould be able to "ORDER BY cname" when starting the
form
SET VAR vCName TEXT = NULL
DROP TABLE tWhatEver
CREATE TEMPORARY TABLE `tWhatEver` +
(`cid` INTEGER , +
`cname` INTEGER , +
and other sales information needed
----------------------------
DECLARE c1 CURSOR FOR SELECT +
cid, +
and other sales information needed
FROM Sales table
OPEN c1
FETCH c1 INTO +
vcid INDIC ivcidr, +
and other sales information needed
WHILE SQLCODE <> 100
SELECT cname INTO vCName INDIC ivCName FROM Company TABLE +
WHERE cid = .vcid
WHAT EVER, WHAT EVER, WHAT EVER
INSERT INTO tWhatEver +
(cid,cname,and other sales information needed ) +
VALUES +
(.vcid,.vcname,and other sales information needed)
FETCH c1 INTO +
vcid INDIC ivcidr, +
and other sales information needed
ENDWHILE
DROP CURSOR c1
On 19 Jun 2003 at 11:52, Albert Berry wrote:
> Unfortunately, a view that has more than one table in it is not editable. One could
> use such a view for a form used to only view the data, but not for editing.
>
> "Victor Timmons" <[EMAIL PROTECTED]> wrote:
>
> >create a view bringing your data together and base your form off of that.
easy
> >
> >
> >On 18 Jun 2003 at 14:22, Gary L. Winzeler wrote:
> >
> >> With the Company table as the master table you then only see one company
at a
> >> time.
> >>
> >> Which only provides for the region to see one companies sales at a time,
vs
> >> what I would like - all the sales for the month ordered by company name.
> >>
> >> GARY
> >>
> >>
> >> At 04:32 PM 6/18/2003 -0400, you wrote:
> >>
> >> � � At 12:40 PM 6/18/2003 -0700, Gary Winzeler wrote:
> >>
> >> � � Using Windows 6.5++ Ver 1.866xRT03 Is there any way to order rows
> >> � � in a single table form with a region based on a column in another
table.
> >> � �
> >> � � Here is what I have:
> >> � �
> >> � � Company table
> >> � � cid integer - Unique id
> >> � � cname (company name text 30)
> >> � � ...
> >> � �
> >> � � Sales table
> >> � � cid integer
> >> � � ...
> >> � �
> >> � � I need to edit data in the sales table only -
> >> � � Edit form is single table based on the sales table and I would like to
> >> � � order by cname, I would rather not add the column to the sales table.
> >> � �
> >> � �
> >> � � Gary,
> >> � �
> >> � � Yes, you CAN!
> >> � �
> >> � � 01. Copy that form and use the Company as Master Table.
> >> � �
> >> � � 02. In Form Designer, Add Sales table as Slave table and then
> >> � � �set Sales as your current table.
> >> � �
> >> � � �Create a region with everything based on Sales table.
> >> � �
> >> � � �Note: You don't need to locate any field or anything related to
> >> � � �Company table, etc. on that form.
> >> � �
> >> � � 03. EDIT USING SalesData +
> >> � � �ARRANGE Sales BY OrderDate ASC +
> >> � � �ORDER BY CName
> >> � �
> >> � � �That will give the results you need.
> >> � �
> >> � � �All records will be sorted by CName (table=Company)
> >> � � �along with the OrderDate (table=Sales).
> >> � �
> >> � � �or simply:
> >> � �
> >> � � �EDIT USING SalesData ORDER BY CName
> >> � �
> >> � � Hope that helps!
> >> � �
> >> � � Very Best R:egards,
> >> � �
> >> � � Razzak.
> >>
> >>
> >> Gary L. Winzeler
> >>
> >> DAQtech, Inc.
> >> Data Acquisition Technology
> >> and Sensor Instrumentation
> >> <mailto:[EMAIL PROTECTED]>
> >> <http://www.daqtech.com/>
> >>
> >> Office 408-847-4800
> >> Fax408-847-4097
> >> Cellular408-483-7739
> >
> >
> >
> >Victor Timmons �
> >Tiz's Door Sales, Inc
> >425-258-2391
> >
> >
>
>
> --
> Albert Berry
> Full Time Consultant to
> PSD Solutions
> 350 West Hubbard, Suite 210
> Chicago, IL 60610
> 312-828-9253 Ext. 32
>
>
> __________________________________________________________________
> McAfee VirusScan Online from the Netscape Network.
> Comprehensive protection for your entire computer. Get your free trial today!
> http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397
>
> Get AOL Instant Messenger 5.1 free of charge. Download Now!
> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
>
>
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
