SQL Update

[jworley]

Hi,<br><br>I am playing around with converting some of my existing VFP apps so that they make more use of SQL.&nbsp;&nbsp;However, I am having problems with the UPDATE command - whenever I reference an object i.e. a text box on a form, I get the error message &quot;TXTADDRESS3 is not an object&quot;.&nbsp;&nbsp;My question is, why the error message, and how can I grab a value from a text box by referencing it directly instead of storing it to a memory variable first (which seems to work).<br><br>UPDATE customer ;<br>&nbsp;&nbsp;&nbsp;&nbsp;SET ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;address1 = m.address1, ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;address2 = m.address2, ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;address3 = thisform.txtAddress3.value ;<br>&nbsp;&nbsp;&nbsp;&nbsp;WHERE ; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;custno = 0<br><br>Thanks<br>

 

[JDurbin]

Are you sure the textbox control sits directly on the form and not in some other container? <p>John Durbin<br><a href=mailto: > </a><br><a href= > </a><br>ICQ VFP ActiveList #73897253

 

[JDurbin]

Aslo not trying your code but just looking you may need prenthesis around the textbox reference or EVAL() <p>John Durbin<br><a href=mailto: > </a><br><a href= > </a><br>ICQ VFP ActiveList #73897253