Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programatic value change in a grid cell
Message
From
20/05/1998 11:44:27
Craig Smith
Pima County Information Technology
Tucson, Arizona, United States
 
 
To
19/05/1998 18:24:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00100421
Message ID:
00100574
Views:
37
I am not sure I understand your problem but I think you might want to try something like this

Set Century On
select table
dtOld = table.field
dtNew =YourProgram(dtOld)
Update table SET field = dtNew WHERE field = dtOld

or without going to an external program

select table
do while not eof('table'
if YEAR(field) <= nRollOverYear
dtold = table.field
dtNEW ={DAY(field)/MONTH(field)/YEAR(field)+ 100}
* You will have to add the time if this is a datetime field
endif
skip
enddo
Update table SET field = dtNew WHERE field = dtOld

I hope this helps
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform