>>
>>the error says that 'alias text2 not found'
>>
>> update customers set company = thisform.text2.value ;
>> where custno = thisform.text1.value
>>
>>
>>
>> insert into customers(company) values (thisform.text2.value)
>
>VFP is being confused by the periods in the values thinking that text2 refers to a table and field like TableName.FieldName You might want to put the value in a local variable and use it for the insert.
>
>lFieldValue = thisform.text2.value
>insert into customers(company) values (lFieldValue)
Hi, Bret-
That doesn't make sense. The INSERT INTO works fine. Though what you say seems to be true for the UPDATE (that he'll need to assign the value to a variable first). But something is screwy. If VFP is looking at Text2 as an alias, it means that it seems to have disregarded the "thisform." And yet, I could do
update SomeTable set SomeField = thisform.caption
just fine.