[RBASE-L] - Re: RBW65 - Union Select problem

[Jim Limburg]

 Ben

This gives me an error of Invalid Syntax..
INSERT +
  INTO problemtables tablename, newcount ,oldcount,.#DATE,.#TIME, .vdbold +
  FROM tablecompare WHERE oldcount <> newcount OR newcount IS NULL
Jim limburg

Ben Petersen wrote:
INSERT INTO problemtables Col1, Col2, Col3, .#DATE,.#TIME, .vdbold +
 FROM tablecompare  +
 WHERE oldcount <> newcount OR newcount IS NULL
On 19 Jun 2003, at 16:00, Jim Limburg wrote:


G-Day

OK, I don't think I'm far off, but I have a table in want to insert into
values from another table along with some static info..
Here is the statement I'm using..

  INSERT INTO problemtables SELECT * FROM tablecompare +
  WHERE oldcount <> newcount OR newcount IS NULL +
  UNION SELECT (.#DATE,.#TIME, .vdbold) FROM dummy
The table is created like this
CREATE TABLE problemtables (tablename TEXT (18), newcount INTEGER,oldcount +
  INTEGER, tmstampdt date, tmstamptm time, dbname TEXT (18))
Dummy is by
CREATE TABLE dummy (x TEXT (1))
INSERT INTO dummy x VALUES ('x')
vdbold is populated..

I'm figuring the select fills the first three columns, and the union fills
the rest, but I keep getting the error 2148 - Expression contains extra comma
What am I doing wrong here?
Jim Limburg