Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from grid
Message
De
07/03/2006 05:05:48
 
 
À
07/03/2006 04:56:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01101962
Message ID:
01101983
Vues:
18
sorry,no errors, but nothing append

i insert records with data, and empty records.


>
>Append from dbf('csrMyCursor') for !empty(csrMyCursor.bookno) and !empty(csrMyCursor.sticket);
> and !empty(csrMyCursor.eticket)
>
>Add more fields if necessary!
>
>>hi,
>>this is the fields.
>>
>>Select bookno,sticket,eticket,NOOFTICKET,BOXNO,shipno,trans_type from trans1 into cursor csrmyCursor readwrite where .F.
>>SELECT csrMyCursor
>>With thisform.Grid1
>>  .RecordSource = "csrMyCursor"
>>  .Columncount = 7
>>  .Column1.ControlSource = "csrMyCursor.bookno"
>>  .Column2.ControlSource = "csrMyCursor.sticket"
>>  .Column3.ControlSource = "csrMyCursor.eticket"
>>  .Column4.ControlSource = "csrMyCursor.noofticket"
>>  .Column5.ControlSource = "csrMyCursor.boxno"
>>  .Column6.ControlSource = "csrMyCursor.shipno"
>>.Column7.ControlSource = "csrMyCursor.trans_type"
>>    append blank
>>  .Refresh()
>>ENDWITH
>>
>>
>>>I am sure that you don't have a FIELD called bookno.sticket.eticket in your csrCourse cursor???
>>>
>>>>hi,
>>>>thank you,
>>>>i try as under, but still take the empty records
>>>>
>>>>   Append from dbf('csrMyCursor') for !empty('csrMyCursor.bookno.sticket.eticket')
>>>>
>>>>
>>>>thanks
>>>>
>>>>
>>>>>Append from dbf('csrCourse') for !empty(csrCourse.somefield) && Replace somefield with a real field name!
>>>>>
>>>>>>hi all,
>>>>>>any idea,help
>>>>>>
>>>>>>i need to append at my table only records not empty from my grid1(csrCourse)
>>>>>>
>>>>>>APPEND FROM (DBF("csrCourse"))&& only record!empty
>>>>>>
>>>>>>thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform