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

Click here to load this message in the networking platform