Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manupulating record fields
Message
 
To
13/06/1998 15:32:43
Tan Gay Cheong
Cybercomp Computer Services
Singapore, Singapore
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00107808
Message ID:
00107905
Views:
22
>I tried, but I dun seem to replace the record.
>
>numinstal = this.value
>for i=1 to numinstal
>lcFieldName = "instal.d_date" + alltrim(str(i))
>replace &lcFieldName with {day(date_commence)/((month(date_commence) + i)/year(date_commence)}
>endfor
>
>THISFORM.PAGEFRAME1.PAGE3.REFRESH()
>
>the record field d_date1, is not replaced. why?
>Could it be something to do with the table buffering?
>
>the above codes is place in the valid procedure of "text4" which is the user will enter the number of months for the increament.

Tan, it is difficult to see what is wrong without seeing all your code. Did you see my suggestion that you use GOMONTH() instead of the date function you have used? If your starting date is the 30 or 31 of the month your system will not work, nor will it update years correctly.

Try to place this code into a PRG and work with it until it is testing correctly. Then add it to your form.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform