Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create new group
Message
From
21/01/2019 11:57:15
 
 
To
21/01/2019 11:03:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01665534
Message ID:
01665586
Views:
66
>My dear respected Sir,
>Thank you very much for helping me. The first solution meets my needs perfectly.
>Here is another issue.
>I have added a new column called "updown" in junk cursor.
>
>The logic is:
>Go top
>replace updown with 1
>
>Then
>if next row (qty) is greater then updown is equal to 1
>if next row (qty) is smaller then updown is equal to 0
>
>I need this result:
>
>The above code does not work in first group (column idid)

After this I'm going to start charging you by the hour. :-)
* Replace this line:
* REPLACE idid WITH lnId

* With this one:
REPLACE idid WITH lnId, updown WITH IIF(qty >= lnLastQty, IIF(llGoingUp, 1, 0), 0)
Previous
Reply
Map
View

Click here to load this message in the networking platform