Opps, seems it should be
APPEND FROM (dbf('crsTemp'))
- as an expression.
>Hi Vlad,
>
>I am now getting an "Operator/Operand type mismatch" How do I determine which fields are causing this error? The fields are of the same name, type and width so could it be something else?
>
>>>Hi!
>
>>>You cannot do this within a single statement.
>
>>>"APPEND FROM" could not be part of the SELECT - SQL statement.
>
>>>So, in your case this will look probably as following 3 commands:
>
>
>>>Select tableA.field5 as fieldtotal ;
> FROM tableA INNER JOIN tableB ;
> ON tableA.namefield = tableB.namefield ;
> WHERE tableA.datefield = tableB.datefield ;
> into cursor crsTemp
>SELECT MyTableForAppending
>APPEND FROM dbf('crsTemp')
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.