Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Access the Buffer ???
Message
From
22/04/1998 13:16:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
22/04/1998 10:34:36
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00093978
Message ID:
00094059
Views:
23
>Thanks,
>
>I understand the commands you suggested but I don't understand how they help in this situation.
>
>I have a form in which a user inputs data (buffered) then I need that data displayed in another form in a grid (before it is committed) to make additional changes/updates. The second form does not show the buffered data only data that has already been written to the table.
>
>Any other suggestions?
>
>Thanks Again
>
>
>>Aaron,
>>
>>If using row buffering, the current record would be the bufferred record.
>>
>>In table buffering, you could use GETNEXTMODIFIED to cycle thru all
>>the modified records.
>>
>>You can use GETFIELDSTATE to determine what fields have changed.
>>
>>You can use the field value, CURVAL(), OLDVAL() to determine the
>>your current value, the value currently on disk, and the value when you
>>originally read the record.
>>
>>-myron kirby-
>>==================================================
>>>I am using Pessmistic Table/Row buffering - is there a way to display the buffer (in a form?) before the data is commited with tableupdate()?
>>>
>>>Thanks
>>>
>>>Aaron
As Nancy said if you're using another datasession or "use again" you won't see the buffered data. Besides you may want to add to grid something like backcolor to show modified data :
*Grid.init
for ix = 1 to this.columncount
	with this.columns(ix)
		cField = substr(.controlsource,rat(".",.controlsource)+1)
		.DynamicBackColor =	"iif(oldval(["+cField+"])#"+cField+" or recno()<0,"+;
			str(rgb(255,0,0))+","+str(this.backcolor)+")"
	endwith
endfor
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform