Advantage Database Forum

Question

Hi,

I have the following statement in a SP :-

    INSERT INTO
  #supplier_proofinfo
(
  job_no,
  [rowid],
  proofingtype
)
SELECT
  job_no, [rowid], GetTCardProofType(note)
FROM
    optimadata.tcard
WHERE
      code =    '42'
  AND note LIKE '%With Supplier%'
order by startdate
;

When I try and save the SP I get an 'expected token: Order' error.

If I remove the 'order by' clause it is fine.

What am I doing wrong?

Regards

Mike

Answer 1

0

I am assuming that ORDER BY is not supported with INSERT INTO so I did a work around using a temporary table and SELECT INTO instead.

link

answered 10 Sep '14, 03:12

Mike
970●74●77●94
accept rate: 12%

@Mike you are correct. An Order By is not valid syntax for an INSERT statement.
You can find the grammar for the INSERT statement here: http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11.1/index.html?master_insert.htm

(10 Sep '14, 07:30) Edgar Sherman

Advantage Database Forum

Insert into problem with Order by clause

Follow this question

Announcements

Related questions