RE: [sqr-users] insert sql

[Eduardo_Bugarin@hdm.honda.com]

Hi all:
other question:

when i execute my sqr program, I have the next message error:
A NON-NUMERIC CHARACTER WAS FOUND WHERE A NUMERIC WAS EXPECTED

some of my code is:

#DEFINE QUINCE  15                  THIS IS A NUMERIC VALUE
#DEFINE ARHDM  ARHDM

begin-sql
insert into PS_SOME_TABLE values (
      '{ARHDM}',
      $GROUP_ID,
      '{ARHDM}',
      $CLIENTE,
      $FOLIO_FACT,
      '{QUINCE}'              IS THIS IS CORRECT TO PUT THE NUMERIC VALUE
15 ???
      )
end-sql


I will appreciate any suggestion

thank you for your time



|---------+--------------------------------------------------------->
|         |           kevin.reschenberg@sparkpath.com               |
|         |           Enviado por:                                  |
|         |           sqr-users-bounces+eduardo_bugarin=hdm.honda.co|
|         |           m@sqrug.org                                   |
|         |                                                         |
|         |                                                         |
|         |           05/10/2004 03:26 p.m.                         |
|         |           Por favor, responda a "This list is for       |
|         |           discussion about the SQR database reporting   |
|         |           language from Hyperion Solutions."            |
|         |                                                         |
|---------+--------------------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       Para:     "This list is for discussion about the SQR database 
reporting     language   |
  |        from Hyperion Solutions." <sqr-users@sqrug.org>                      
                 |
  |       cc:       (cco: Eduardo Bugarin/HDM/AM/HONDA)                         
                 |
  |       Asunto:   RE: [sqr-users] insert sql                                  
                 |
  
>----------------------------------------------------------------------------------------------|




It looks like you are asking about two problems--the null column and the
error message.  I have a suggestion for the error.

Check to be sure that the contents of your substitution variables, such
as {ARHDM}, contain quotes if necessary.  A value without quotes may
look like a column name to Oracle.  The following example will get the
"column not allowed here" error because the second value is not
enclosed in quotes:

insert into ps_animal_tbl values('CAT',Cat,'Cat')

If we use a substitution variable:

insert into ps_animal_tbl values('CAT',{Cat},'Cat')

it will work as long as {Cat} is defined to include quotes:

#define Cat  'Cat'

You could also get around the error by simply enclosing the entire
substitution variable in quotes:

'{ARHDM}'


Kevin Reschenberg
SparkPath Technologies, Inc.
(949) 466-1674

www.sparkpath.com


-------- Original Message --------
Subject: [sqr-users] insert sql
From: Eduardo_Bugarin@hdm.honda.com
Date: Tue, October 05, 2004 12:44 pm
To: sqr-users@sqrug.org

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


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