Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local view problems
Message
From
05/08/1998 08:22:57
John Baird
Coatesville, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00123814
Message ID:
00124013
Views:
20
>Ah. How can I specify which fields are updateable using CREATE VIEW? (Couldn't see this in the help file anywhere, apologies if I'm not looking hard enough).

Here is a snippet from a save data routine:
PARAMETERS tcViewName, tcNewList

lcOriginalList = CURSORGETPROP('UpdatableFieldList',tcViewName)
lcUpdateList = tcNewList + lcOriginalList

IF .NOT. CURSORSETPROP('UpdatableFieldList',lcUpdateList,tcViewName)
	=AERROR(laError)
	*DISPLAY MEMO LIKE laError
	=MessageBox('ERROR in Set List')
	RETURN
ENDIF

SELE (tcViewName)
IF .NOT. TABLEUPDATE(.T.)
	=AERROR(laError)
	*DISPLAY MEMO LIKE laError
	=MessageBox('ERROR in Update')
	RETURN
ENDIF
IF .NOT. CURSORSETPROP('UpdatableFieldList',lcOriginalList, tcViewName)
	=AERROR(laError)
	*DISPLAY MEMO LIKE laError
	=MessageBox('ERROR in restore list')
	RETURN
ENDIF
thisform.lDirty = .F.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform