Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append to table
Message
De
07/04/2008 01:41:36
 
 
À
07/04/2008 01:27:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01308490
Message ID:
01308636
Vues:
13
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()
>>>>>
>>>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform