MySQL Forums
Forum List  »  Delphi

problem with string in query
Posted by: Zoe Feltwell
Date: February 14, 2007 09:09AM

i have a simple query taking all fields of one table (informix) and putting them into an empty mysql table.

one of the records will not insert into the mysql table, error message: db2Query: Field " is of an unknown type.

St Mark's Church : James D Clarke Lower Bdg

i suspect it is something to do with the ' and : but can't understand exactly why
there are other longer records that work so it'd not the field length.
there are 1000's of records and this is the only one with a problem. several others have ' and : in but not together

Options: ReplyQuote

Written By
problem with string in query
February 14, 2007 09:09AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.