Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data not updating in primary table of a view
Message
De
09/06/2002 13:07:40
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Data not updating in primary table of a view
Divers
Thread ID:
00666382
Message ID:
00666382
Vues:
64
Hello

I created a dynamic view in my form which receives table name (QorM) as parameter.and i setup the properties of view like this
=CURSORSETPROP("Buffering", 5, "vueTable")
DBSetProp('VUETABLE', 'View', 'UpdateType', 1)
DBSetProp('VUETABLE', 'View', 'WhereType', 3)
DBSetProp('VUETABLE', 'View', 'FetchMemo', .T.)
DBSetProp('VUETABLE', 'View', 'SendUpdates', .T.)
DBSetProp('VUETABLE', 'View', 'UseMemoSize', 255)
DBSetProp('VUETABLE', 'View', 'FetchSize', 100)
DBSetProp('VUETABLE', 'View', 'MaxRecords', -1)
DBSetProp('VUETABLE', 'View', 'Tables', 'QorM')
DBSetProp('VUETABLE', 'View', 'Prepared', .F.)
DBSetProp('VUETABLE', 'View', 'CompareMemo', .T.)
DBSetProp('VUETABLE', 'View', 'FetchAsNeeded', .F.)
DBSetProp('VUETABLE', 'View', 'FetchSize', 100)
DBSetProp('VUETABLE', 'View', 'Comment', "")
DBSetProp('VUETABLE', 'View', 'BatchUpdateCount', 1)
DBSetProp('VUETABLE', 'View', 'ShareConnection', .F.)

*!* Field Level Properties for VUETABLE
FOR gnCount = 1 TO FCOUNT( )  && Loop for number of fields
	DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'KeyField', .F.)
	DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'Updatable', .T.)
	DBSetProp("vueTable."+FIELD(gnCount), 'Field', 'UpdateName', 'QorM.'+FIELD(gnCount))
NEXT
*!* Set the key field to SSN coz previous step makes is not updatable
DBSETPROP("vueTable.ssn","FIELD","KEYFIELD",.T.)
DBSETPROP("vueTable.ssn","FIELD","UPDATABLE",.T.)
DBSETPROP("vueTable.ssn","FIELD","UPDATENAME",'QorM.ssn')
in my save method of my form
llSucess=TABLEUPDATE(.t.)
IF llSucess
	*WAIT WINDOW 'Sucessfully Saved' TIMEOUT .5
ELSE
	MESSAGEBOX('Sorry Record Not saved',16,'Oops Sorry')
ENDIF
the data gets saved in the view,but when i close the form and use the base table i dont see the data get updated.

what am i missing ?

txs for any help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform