>>>I must be losing the plot...
>>>
>>>I have the following line of code
>>>
>>>
>>> REPLACE IDNO WITH jcIdNo
>>>
>>>
>>>On compiling I get the error "Command contains unrecognised phrase/keyword"
>>>
>>>If I change "IDNO" to be anything else it works! It is as though IDNO is a keyword. The problem is that this is a field name in an underlying table and is not something I wish to change.
>>>
>>>Am I missing something very basic here?
>>>
>>>Thanks
>>>Barry Sutton
>>
>>
>>No, IDNO is not a keyword.
>>Make sure you didn't have a header file where you change IDNO to something else.
>
>Borislav
>
>That's it! I had a constant defined IDNO in a header file. Thanks - that would have taken me ages to locate.
>
>Now I just have to decide if I want to change the header file or the table!
>
If IDNO is a standard name for your PKs, change it in the header file.
Confucius say always listen to Borislav about SQL ;-)