Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Update table using cursor
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement