>>>
>>>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.
I took a guess at a solution because I think I have seen this before and it would be something I would try as a work around. It could be a bug, I do not know. But his error 'alias text2 not found' is one I know I have seen before.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope