Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a Cursor
Message
 
 
To
10/03/2005 15:49:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00994604
Message ID:
00994636
Views:
22
>I have a form with a grid based on a cursor. The grid is used to fill out a time sheet:
>
>Mon Tue Wed etc.. Total
>
>Note: Each day has a Regular Time and an Overtime column.
>
>I would like the total column to be only visual. Note that there can be multiple entries under each day that have different job numbers so the total has to be for each row.
>
>In short what I need is a row total: regular overtime
>
>My cursor is used to append/update data to a remote table.

Create a cursor with a "total" field that is numeric or whatever you need. In the LostFocus of each of the column textboxes, do your calculations and replace that "total" field with this value. Your "Total" column in the grid should have the "Total" field as its source. Then make the "Total" column ReadOnly
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform