RE: newby question

Hi Connie,

Something in the code above this line does not appear to be correct,
start looking above this SQL statement,  You do have a function named in
your 4GL code right?

Eg.

Function do_something()
   define h_last_ship date,
          p_accust record like accust.*

   select max(date_prepared) into h_last_ship
   from sncordm
   where custnum = p_accust.cust_code


End function


   _____


Richard Turner

Software Developer



Phone: (613) 226-5511 ext. 2142 Fax: (613) 226-3377
Email: [email protected]
1 Antares Drive, Suite 400
Ottawa, Ontario, Canada
K2E 8C4

This message is intended exclusively for the individual or entity to
which it is addressed. This communication may contain information that
is proprietary, privileged or confidential or otherwise legally exempt
from disclosure. If you are not the named addressee, you are not
authorized to read, print, retain, copy or disseminate this message or
any part of it. If you have received this message in error, please
notify the sender immediately by e-mail and delete all copies of the
message.



-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Connie Cocanougher
Sent: Monday, August 07, 2006 4:47 PM
To: [email protected]
Subject: [fourjs-users] newby question



Any idea why I would get an error with this when trying to compile using
BDS?

    select max(date_prepared) into h_last_ship
| A grammatical error has been found at 'select' expecting: $ FUNCTION
REPORT.
| See error number -6609.
       from sncordm
       where custnum = p_accust.cust_code