Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vfp50 - SELECT SQL VIEW
Message
De
21/03/1997 08:16:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00025001
Message ID:
00025165
Vues:
50
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform