Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check fields for changes
Message
 
To
14/07/2005 14:00:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01031731
Message ID:
01032738
Views:
12
Hi Beth,
I am glad you resolve your problem, but I think you thanks to the wrong person, me :o))

>Hi Borislav and Hilmar,
>
>After much debugging I have finally got my code to work correctly. It took a combination of both of your's suggestions to do what I needed done.
>Below is my solution.
>
  lnFldcnt = FCOUNT()
>  IF lnFldcnt > 0
>    FOR lnloop1 = 1 TO lnFldcnt
>      lcfldname = FIELD(lnloop1)
>      IF UPPER(RIGHT(lcfldname,3)) = "_PT"
>        IF !ISNULL(OLDVAL(lcfldname))
>          IF OLDVAL(lcfldname) <> EVALUATE(lcfldname)
>            laDate[1] = DATE()
>            lcfldname = STRTRAN(lcfldname, "_PT", "_GT")
>            GATHER FROM laDate FIELDS (lcfldname)
>          ENDIF
>        ENDIF
>      ENDIF
>    ENDFOR
>  ENDIF
>
>
>Thanks to both of you.
>Beth
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform