Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update table using cursor
Message
From
14/07/2000 04:16:56
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Update table using cursor
Miscellaneous
Thread ID:
00392267
Message ID:
00392267
Views:
42
Help,

I've got a command button that prints a report, what I'd like to be able to
do is after the report is printed, MOVE (copy) the data from the cursor to
a history table. But before the move, I'd like a yes or no message
box to open and say "Do you want to Post this data ?" If yes move data
to hist table, if no loop back to the start of program and zero the form.
The very last line of my code explains my proublem.
Can anyone add to my code below ?

Thanks
John

set deleted on
SELECT *;
FROM TEST, pay ;
WHERE test.ss_numb = pay.ssnumber .AND. INS_CO_NAM = "A. U. L." AND PAY.GROUP_CODE = "1" ;
INTO Cursor CuReport ;
order by test.last_name
IF _TALLY > 0
BROWSE
report form payment3 preview
***DO FORM POSTMAD
ELSE
MESSAGEBOX("FOUND NO RECORDS THAT MATCH YOUR REQUEST")

ENDIF
RELEASE THISFORM
**** report form payment3 preview
close all
DO FORM POST1AUL **** THIS IS WHERE I DO MY POSTING program would go
****. IT CLOSES ALL AND START FROM THE BEGAINING, WHICH I SOMEHOW FEEL IS incorrect.

Help
Next
Reply
Map
View

Click here to load this message in the networking platform