Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from grid
Message
From
07/03/2006 05:05:48
 
 
To
07/03/2006 04:56:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01101962
Message ID:
01101983
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform