Good evening Emmitt
I have heard of Fernwood BBS it contained a lot of OS/2 tips and drivers
did it not??
I used it and Hobbes site a lot ...... those were the days ......... I
thought.
Thanks for the help I'm busy trying to find some documentation and
samples of your suggestions.
I can't believe I didn't hang on to my books ... they would be a real
lifesaver now.
Is it just me or was R:base for OS/2 faster than the windows versions
....... I'd love to see an R:Base for Linux too.
Regards
Mike Fakaro
Emmitt Dove wrote:
<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal,
li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt;
font-size:12.0pt; font-family:"Times New Roman","serif"; color:black;}
a:link, span.MsoHyperlink {mso-style-priority:99; color:blue;
text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99; color:purple; text-decoration:underline;}
span.EmailStyle17 {mso-style-type:personal-reply;
font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault
{mso-style-type:export-only; font-size:10.0pt;} @page Section1
{size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.Section1
{page:Section1;} -->
Mike,
Ah! Another former-OS/2-ite. Ever hear of Fernwood BBS?
To update your Work_orders table whenever you enter parts or labour,
you will need to create a trigger on the parts table and one on the
labour table. A trigger is nothing more than R:BASE code placed into
a stored procedure. You then create the trigger specifying the stored
procedure as the code to execute. Go to http://www.razzak.com/fte/
and search on trigger; I'm pretty sure Razzak has a document there.
For your report, the easiest way is to create a view that links
together your Work_order table and the other two. Presumably on the
parts table you have a key field such as part_id which is also found
on Work_order. That would be the linking column. A similar link
between Work_order and labour must exist. Once you have built your
view you base your report on the view. If the view is properly
constructed, there will be no duplicate parts/labour entries in your
report.
Emmitt Dove
Manager, DairyPak Business Systems
Evergreen Packaging, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(203) 643-8022
*From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of
*Michael Fakaro
*Sent:* Friday, May 09, 2008 4:22 PM
*To:* RBASE-L Mailing List
*Subject:* [RBASE-L] - A couple of questions
I am a former R:base 5.5 for OS/2 user and am now working with R:base
7:6 for windows
I guess my memory is not as good as I had hoped, I am hopeful that
someone on this list can point me in the right direction
I am not afraid to read and learn so if anyone can point me to the
documentation for what I am trying to do the would be great!
I have 3 tables involved "Work_orders" & "Parts" & "Labour"
1) I am trying to get a form to update the "Work_orders" table as each
line item is inputed in either "Parts" or "Labour". I have a work
order form that allows me to punch in parts to the "Parts" table and
labour to the "Labour" table but I want the form to add the ongoing
totals up into the main "Work_orders" table. IE: the "Parts" table
records the items individual cost and the "Work_order" table records
the sum of the parts costs. I can't for the life of me remember how I
used to do this, I wish i still had my old books!!!
In enter mode I am adding rows that include the cost of individual
parts or labour into "Parts" or "Labour" at the same time I want the
cost of these items added to "Work_orders" on an accumulative manner
...... when I hit [Enter] in the last column in "Parts" or "Labour" I
want the form to add the cost to "Parts" and also to add the cost of
that part just entered to the total in "Work_orders" so as I enter
each part the total in "Work_orders" grows to reflect the increasing
totals ..... I can then run a report showing me the totals of "Parts"
and "Labour" using the "Work_orders" table
2) I need to make a report based on the Work_orders table that will
tally up and list all the line items from the parts table and the
labour table. I can easily do it with just the parts or labour and
have ....... but trying to get both in the same report has been very
frustrating I end up with massive amounts of duplicates ...... I have
not done this in the past as I have only had to deal with a single
table as is in the R:Base sample databases.
I use the "Work_order" table to store the cutomer number, work order
number, parts total costs, labour total costs ....etc etc ..... for
the work orders, the Parts and Labour tables records just that .....
Parts and Labour linked to the "Work_order" table by the Work order
number.
I need to create a report that will show all related Parts and Labour
to that work order number. I can do this easily with just Parts or
Labour but when I attempt to add both I get duplicates coming out my ears.
I am thinking it is just the placement of my breaks .... it seems that
breaks are nested, I need to list all the labour ..... based on the
break being the work order number and then run the parts next .....
breaking again on the work order number.
I may not be explaining this very well .... but my head is swimming
and I think the way I wrote this magnifies the fact. Looked through
the samples but they only show you how to pull items using a single
table and a break and I do get that! It's like I need to run the same
break twice but on different tables one after the other .... again I
can't find any help in the documentation and I know you must be able
to do this.
Thanks
Mike
