Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid, Appending Records To
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00118383
Message ID:
00118828
Vues:
14
>>I have created a grid populated with fields from a table called Vac (for displaying Vacation data). I have provided a combo box for the user to select an employee from. The combo box RowSource is from a Master Employee parent table, Prlink, and is related to Vac by Employee nmbr. I now need to provide a way for the user to add a new vacation record for the selected employee. I placed a cmdbutton on the form with the caption Add A Record. Is there any way I can just append a blank line onto the bottom of the grid and let the user type the data in right then and there. I have already tried the following in the cmdbutton.valid with no success (except that it indeed does append a blank record which I can't seem to see on the grid, but I can see from the status bar that a record has been added).
>>
>>
>>SELECT Vac
>>APPEND BLANK
>>ThisForm.Refresh()
>>
>>
>>Any help would definantly be appreciated. Thanks, CH.
>
>You should replace the employee number for link purposes.
>
>INSERT INTO vac (vac.empno) VALUES (employee.empno)
>Thisform.Refresh()
>
>HTH

Worked. Thank you, thank you, thank you! I also SetFocus on the first column of the grid and temporarily disabled the empnmbr+DTOS(DATE)INDEX tag so as to make the record appear at the bottom of the grid instead of at the top (automatically went top because of no date yet being entered when you click on the 'Add a Record' button). Thanks Again, CH.
Chuck Henry
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform