RE: [sqr-users] insert sql

["Bill Winkfield" <bwinkfield@gia.edu>]

Eduardo,

It looks like your problem is due to a missing bracket in your SQL.

begin-procedure INSERT_DAT
begin-sql
  insert into SOME_TABLE values (
      {ARHDM},
      $GROUP_ID,
      {ARHDM},
      $CLIENTE,
      $FOLIO_FACT,
      #CNT_GRP,
      ' ',        <== this is a space, not a null
      {FECHA},
      {CERO_CD},
      ' '
        )               <== you need a closing bracket here
end-sql
end-procedure



-----Original Message-----
From: Eduardo_Bugarin@hdm.honda.com [mailto:Eduardo_Bugarin@hdm.honda.com] 
Sent: Tuesday, October 05, 2004 12:45 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] insert sql

hello everyone

I need to insert data by sql, but I have the next message

ORA-00984: COLUMN NOT ALLOWED HERE

I know that this is about the fields on the Oracle table

could some one tellme if this is correct:

begin-procedure INSERT_DAT
begin-sql
  insert into SOME_TABLE values (
      {ARHDM},
      $GROUP_ID,
      {ARHDM},
      $CLIENTE,
      $FOLIO_FACT,
      #CNT_GRP,
      ' ',        IN THIS FIELD I NEED TO INSERT AN EMPTY DATA, BUT THE
FIELD DOSENīT ACCEPT NULLS
                  HOW CAN I INSERT ????????????????????
      {FECHA},
      {CERO_CD},
      ' '
end-sql
end-procedure


thank you for your help






_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users