Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - SELECT SQL VIEW
Message
From
21/03/1997 08:16:43
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00025001
Message ID:
00025165
Views:
48
>>ok Jeff... thanks.. that really helps.
>>after the TABLE is create, what will the code
>>look like to make an updateable table using the programatically approach?
>
>Good question. I use the following code in the init method of my data environment. The view I created is a remote view. The first CURSORSETPROP allows updates to be sent. The second one enables buffering. The last one lists the fields that can be updated. I discovered a bug in the last command: it appears to be limited to 255 characters in the field list. Add_update is the name of my remote view.
>
>=CURSORSETPROP("SendUpdates", .t., "add_update")
>=CURSORSETPROP("Buffering", 3, "add_update")
>=CURSORSETPROP("UpdatableFieldList","claim_number,claimant_name,ss_number,;appt_type,date_of_birth,date_of_accident,address_1,address_2,city,state,zip,udds,fund,hrly_rt_at_toi,claim_status,claim_type,weekly_wage,wklywage_indicator,part_of_body,max_weekly_wage,weekly_ttd_rt,daily_ttd_rt","add_update")
>
>Hope this helps.
>
>Jeff Rusch
>jrusch@jvlnet.com

Thanks Jeff... that helps...Rob
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Reply
Map
View

Click here to load this message in the networking platform