RE: [sqr-users] insert sql

[kevin.reschenberg@sparkpath.com]

If the column is defined as numeric, you don't need the quotes.  In that
case, instead of
     '{QUINCE}'  
just use
     {QUINCE}  

Also, if your program really says
#DEFINE QUINCE  15                  THIS IS A NUMERIC VALUE
including the "THIS IS A NUMERIC VALUE", be sure to make that a comment:
#DEFINE QUINCE  15                 !  THIS IS A NUMERIC VALUE

Otherwise, {QUINCE} will include both the 15 and the words.


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

www.sparkpath.com

 
-------- Original Message --------
Subject: RE: [sqr-users] insert sql
From: Eduardo_Bugarin@hdm.honda.com
Date: Wed, October 06, 2004 9:37 am
To: sqr-users@sqrug.org

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 , 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')

it will work as long as is defined to include quotes:

#define Cat  'Cat'

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

''


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 (
    ,
    $GROUP_ID,
    ,
    $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 


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