Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append to table
Message
From
06/04/2008 05:16:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Append to table
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01308490
Message ID:
01308490
Views:
53
hi all,

is there away to replace all fields (from talias1.payroll) i have at mygrid ,to my talias1.payroll

thanks
SET DELETED  on
SELECT TAlias1.employeeid,TAlias2.nam,TAlias2.nam4,TAlias1.workdays,TAlias1.absencewp,TAlias1.absencew,TAlias1.uovertimeh,TAlias1.whovertime,TAlias1.vacations,TAlias1.sickvacati,TAlias2.wark  ;
 FROM payroll TAlias1, mstr TAlias2 ;
 WHERE  TAlias1.employeeid = TAlias2.no ;
  ORDER BY employeeid ;
  INTO cursor  mycur readwrite

      thisform.Grid1.RecordSource=" mycur"  
         thisform.Grid1.refresh()
Next
Reply
Map
View

Click here to load this message in the networking platform