RE: newby question

To Whomever this concerns

Try giving the max(date_prepared) an alias like max(date_prepared) mdate
and see if that works.

John Endsley

Fourth Generation Software
700 Galleria Parkway
Suite 480
Atlanta, Georgia 30339  USA
770.432.7623  Ext. 4889
800.374.6157  Ext  4889
770.432.3448  Fax


-----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


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 8/5/2006


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 8/5/2006