>Can anyone please help with this? Urgent!!!!
>
>When i use the command
>
>mcomp = thisform.txtcompany.value
>Update company set company = mcomp
>=tableupdate(.T.)
>
>I get an error 'Update Conflict'
>
>The problem is the variable gets passed over as a numeric field thus
>giving the error. Why does it do that?
>How can i fix this?
>
>Many thanks in advance
Check the initial value of the textbox. By default the value is character unless you initialize it to some other data type. Yu can also add code to transform the type to character if that is what is needed [see Transform function in VFP help].
Also, you should use a WHERE clause in your UPDATE SQL command.
Mark McCasland
Midlothian, TX USA