Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append to table
Message
From
07/04/2008 01:41:36
 
 
To
07/04/2008 01:27:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01308490
Message ID:
01308636
Views:
12
Select * from payroll into cursor mycur readwrite where .f.
>yes,
>i mean how i can create empty cursor,the fields as payroll.dbf
>thanks
>
>>I don't understand, do you have more questions?
>>
>>>thank you for reply,
>>>
>>>an empty curgrid cursor must be created in the form's load event.
>>>
>>>as select fields form payroll into cursor curgrid.but it is not empty
>>>thanks
>>>
>>>
>>>>I must confess that I don't exactly understand your question, but I guess this is what you eally want
>>>>Select *something* into cursor mycur readwrite
>>>>Select curgrid && the cursor which "drives" your grid
>>>>zap
>>>>append from dbf('mycur')
>>>>thisform.grid1.refresh()
>>>>For this to work, an empty curgrid cursor must be created in the form's load event.
>>>>
>>>>>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()
>>>>>
>>>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform