I have an estimating package which has a RATES table and a SCHEDULE table.
The RATES table includes an item description (column de) and, as the
description for the same item can vary depending on the consultant preparing
the schedule, another column which includes the basis of a select clause
used to identify the item (column al). Each row in the RATES table has a
unique number identified by column rseq.
eg: de: 400 dia spigot with damper
al: (de contains ‘400’ and de contains ‘spigot’)
rseq: 100
While using a cursor to step through the RATES table, and an update clause,
I can extract the appropriate rates and update the SCHEDULE table
(update schedule set .... where and &val; val being the variable extracted
from the al column using the fetch statement)
I am trying to develop this package to allow manual entry of the data into
the SCHEDULE table (so far this is imported from a spreadsheet supplied). As
part of this I need to determine a way of doing this from an EEP in a form
as soon as the description is entered into a form. This would require a
command which selects a row in the RATES table where a select clause returns
a match between the description in the SCHEDULE table (which would be a
variable from the form) and the predefined select clause stored in the RATES
table.
Select rseq from RATES where &al is true
If anyone has any suggestions as to how this can be achieved I would
appreciate your assistance. (Maybe I have just missed the obvious here.)
Thank you,
John Docherty
--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.271 / Virus Database: 264.9.3 - Release Date: 17/09/2004
