Bernie, Buddy Thanks,
Quotes were missing. Gave me a clue what to look for. But still did not work. Turns out I'm trying to insert info into a table with a varchar and varbit column. These are both currently null. The insert does not quite know how to figure out inserting nulls into these two types. Changed these two columns to text to insert nulls. Looks like I need to send an alter table alter column command after the insert. Jan ----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, October 13, 2004 3:07 PM Subject: [RBG7-L] - Re: Unload & Load > Jan > It is normally caused by a missing quote, paren or even and + for continuation line. > > Buddy > > > -----Original Message----- > From: Jan Johansen [mailto:[EMAIL PROTECTED] > Sent: Wed 10/13/2004 5:27 PM > To: RBG7-L Mailing List > Cc: > Subject: [RBG7-L] - Re: Unload & Load > > > > Bernie, > > Thank you. > > Follow on question. > > Getting the error message > -ERROR- An expression cannot end with binary operator. (2149) > when I try to use an > INSERT INTO tablename1 (column1, column2, etc.) > SELECT > column1, column2, etc. > FROM tablename2 > > The error does not really help me figure out what I am doing wrong. > > Any ideas; > > Jan > >
