>when I use an update command I get the following message:
>
>Alias 'TXTP_DPO_INT' is not found.
>
>my sql update looks like the following:
>
>update person_tbl set P_dpo_int = alltrim(.txtP_dpo_int.value), ;
>P_dte_assign = .txtP_dte_assign.value, ;
>P_dte_due = .txtP_dte_due.value, ;
>P_crtcase = alltrim(.txtP_crtcase.value), ;
>P_lname = alltrim(.txtP_lname.value), ;
>P_fname = alltrim(.txtP_fname.value), ;
>P_mi = alltrim(.txtP_mi.value), ;
>P_dte_sent = .txtP_dte_sent.value where p_nextid = lcid
>
>where I'am going wrong? the p_nextid exist. Help appreciated
>
>thanks
For some reason VFP is not resolving the object reference for you; the issue may be scoping and duration of a WITH...ENDWITH block. If one is in effect, the UPDATE is not resolving the object reference for you properly. You might try using an explicit objectname reference rather than an implied object reference.