Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01043177
Message ID:
01043303
Vues:
10
Yes, it must :-)

>>>hi all,
>>>
>>>would you help,
>>>
>>>i need to save (append) all fields and records except one field from mygrid to another table,
>>>
>>>code to built the grid
>>>
>>>SELECT course.coursenumb,  course.coursename, ;
>>>       table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ;
>>>        table2.g4, table2.g5, table2.wm2, table2.g6, table2.tot2, table2.ltot  ;
>>>  from Course ;
>>>  inner join TABLE2 on table2.no = course.no ;
>>>  into cursor csrCourseStats readwrite
>>>
>>>Thisform.Grid1.RecordSource = "csrCourseStats"
>>>
>>>i try as
>>>use stud && i get error message file is in use
>>>append from (...........)
>>>
>>>thanks
>>
>>
>>LOCAL lbFlUsed
>>IF NOT USED("Stud")
>>   USE Stud IN 0
>>   lbFlUsed = .t.
>>ENDIF
>>SELECT Stud
>>APPEND FROM (DBF("csrCourseStats"))
>>IF lbFlUsed
>>   USE IN Stud
>>ENDIF
>>
>
>Not to be picky, but should not the variable be called lbFlNotUsed? < g >
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform