RE: [sqr-users] insert sql

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

Do this instead if you are bringing QUINCE as a string value.  You can place
it right before the insert:

LET #QUINCE = to_number($QUINCE) then 
begin-sql
insert into PS_SOME_TABLE values (
      '{ARHDM}',
      $GROUP_ID,
      '{ARHDM}',
      $CLIENTE,
      $FOLIO_FACT,
      #QUINCE)


Thanks,

José A. Aguirre
504.568.2455

-----Original Message-----
From: sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org
[mailto:sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org] On Behalf Of
Eduardo_Bugarin@hdm.honda.com
Sent: Wednesday, October 06, 2004 11:37 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] insert sql


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

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