Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update table using cursor
Message
 
À
14/07/2000 04:16:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00392267
Message ID:
00392280
Vues:
9
>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.

Questions:

1. Where are you calling this form - contains the above code? Is it via a menu bar?
2. Is the form POST1AUL is the same form that contains the above code?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform