[Joe Boyle]

would it help to say 'FROM CONSULTAS , DUAL' ?
  ----- Original Message ----- 
  From: jmalmaga at wanadoo.es 
  To: powerh-l at lists.sowder.com 
  Sent: Friday, September 07, 2007 2:22 PM


  Hi  all,

  I have problems with oracle and one cursor using qdesign

  this is the cursor 

  SQL IN SGBASE &
   DECLARE CSR_CONS_PEND CURSOR FOR                                           &
   SELECT                                                                     &
  (TRUNC (SYSDATE - TO_DATE (fecha_origen, 'YYYYMMDD')))  &

  FROM CONSULTAS 

  *E* Error parsing SQL statement.

  DMS-E-GENERAL, A general exception has occurred during operation 'prepare 

  request'.

  DMS-E-RBI_COLUMN, Column SYSDATE was not found.


  the problem is in the field sysdate,  Anybody Know how solve this problem?


  ¡Viva los novios! En Match.com lo gritamos todos los días 


------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070907/63227959/attachment.html