Re: dbcopy problem

roger@star2000.com.tw wrote: > Dear Art: > I migrate a table by your shareware dbcopy, > This table 't1' has a column 'colx' datatype is varchar(8,1), > It been migrated successfully , but If I run a SQL statement > " select length(colx) from t1 " , > It response that" 202: An illegal character has been found in the > statement". > I tried other ways to migrate , unload ,load or insert .. select , It > is OK! > Is that dbcopy's bug? > Doesn't sound like it has anything to do with dbcopy. The data's already in the target table and dbaccess and/or the engine is complaining about your SELECT statement not the data contained in the table. I don't SEE anything wrong, but I'm only seeing a copy of the statement after all. For example, one of the spaces may not be a space or one of the parenthesis may in fact be a brace, I just don't know. Try creating the SQL in a text editor like emacs that will let you examine each character individually so you know it's clean before you pass it to dbaccess in a saved .sql file. Art S. Kagel