The problem I have is that I am creating a literal string that is too long. I would be able to solve this if I could have TEXTMERGE within TEXTMERGE but that does not work. So I suppose I will need to make the changes manually.
>It looks like you're inserting field into the table from the same table? I think there's some sort of circular reference problem in that code.
>
>+++ Rick ---
>
>>Hi,
>>
>>I am getting an error a line very similar to the following. The error says "command contains unrecognize phrase/keyword".
>>
>>
>>cSqlInsert = "insert into Mytable (fld1, fld2, fld3) values (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)"
>>
>>
>>The list of fields is actually considerably longer. But what should I be looking at? TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham