Message
From
20/12/2006 09:25:05
Mk Sharma
Shrishti Solutions
Mumbai, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
How to add records in grid
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01179181
Message ID:
01179181
Views:
59
i am using pagedown button to add records in grid.

in keypress event of every column.textbox in grid.
i have below code in pageframe.page1.grid1.column1.textbox
Lparameters nKeyCode, nShiftAltCtrl
If nKeyCode=3
   Select INWARD1
   Flush
   This.Refresh
   Flush
   Select INWARD1
   If (qty+Free)<>0
      Insert Into INWARD1 (VNO, Status, Type, RECO1, machineid, lqty) Values (INWARD.VNO, INWARD.Status, INWARD.Type, INWARD.RECO1, INWARD.machineid, .T.)
      Go Recno()
      Thisform.pageframe1.page1.grid1.Refresh()
      Thisform.pageframe1.page1.grid1.SetFocus()
      Thisform.pageframe1.page1.grid1.colUMN1.SetFocus()
   Endif
Endif
warm regards,
mk.
Next
Reply
Map
View