> get lineOffset(item 1 to 2 of L, "tStock")
Since the string "tStock" does not contain what you are looking for,
try this instead
get lineOffset(item 1 to 2 of L, fld "tStock")
Jim Ault
Las Vegas
On 1/22/08 11:32 AM, "Peter Alcibiades" <[EMAIL PROTECTED]>
wrote:
> Trying Sarah's suggest
On Jan 23, 2008 5:32 AM, Peter Alcibiades <[EMAIL PROTECTED]> wrote:
> Trying Sarah's suggestion first, but cannot seem to make it work:
>
> on mouseUp
> set the itemDelimiter to tab
> repeat for each line L in field "tSales"
> get lineOffset(item 1 to 2 of L, "tStock")
> if it > 0 then
On 22 Jan 2008, at 19:32, Peter Alcibiades wrote:
on mouseUp
set the itemDelimiter to tab
repeat for each line L in field "tSales"
get lineOffset(item 1 to 2 of L, "tStock")
if it > 0 then subtract 1 from item 5 of line it of field "tStock"
end repeat
end mouseUp
Sure it doesn't do a
Trying Sarah's suggestion first, but cannot seem to make it work:
on mouseUp
set the itemDelimiter to tab
repeat for each line L in field "tSales"
get lineOffset(item 1 to 2 of L, "tStock")
if it > 0 then subtract 1 from item 5 of line it of field "tStock"
end repeat
end mouseUp
I
At 5:46 PM + 1/21/2008, Peter Alcibiades wrote:
So what I am trying to do is go through the sales field using the number and
description from each line, one after the other, and match each line against
the record for that product in the stock field, then if there is a match,
knock down the no
On Jan 22, 2008 3:46 AM, Peter Alcibiades <[EMAIL PROTECTED]> wrote:
> There is a sales file with a varying number of lines, tab delimited.
>
> Each line records one transaction, the sale of one product. These lines
> accumulate throughout the day.
>
> At the end of the day, I want to take (for in
There is a sales file with a varying number of lines, tab delimited.
Each line records one transaction, the sale of one product. These lines
accumulate throughout the day.
At the end of the day, I want to take (for instance) item 1 & tab & item 2 &
tab, and use this to look up the line in the
