Re: datenow() fails my program!

[Heather Simpkins <heather.simpkins@HEROFFICE.COM.AU>]

Check that all your Begin-Select / End-Select and Begin-SQL / End-SQL match
up.  You sometimes get that message if there is a mismatch.

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Kathy Anderson
Sent: Friday, 21 July 2000 06:56 AM
To: SQR-USERS@list.iex.net
Subject: Re: datenow() fails my program!

I wrote a quick program with your line of code and it did not err out.  So
it must really be a memory error (sometimes I don't always believe the Out
of space . . . use -mfile . . .error is really due to a memory issue.)  You
should increase the expressionspace value in your .max file or whatever file
your -m flag is pointing to.

If you're a PeopleSoft user your -mfile is allmaxes.max
 <<...>>

> -----Original Message-----
> From: Sayre John [SMTP:John_Sayre@GAP.COM]
> Sent: 20 July 2000 6:31 PM
> To:   SQR-USERS@list.iex.net
> Subject:      datenow() fails my program!
>
> I am attempting to use datenow() in a program.  It causes an
> expressionspace
> error.
> Expressionspace is set in -mfile to the max, but I get this error:
>
>    (SQR 4038) Out of space while processing expression; Use -Mfile to
> increase
> EXPRESSIONSPACE.
>
> I have lifted, verbatim, two different formats from previous questions in
> the
> group.
>
> I am using V4.0.3.1
> The offending code is:
> let $date_string = edit(datenow(),'YYYY-MM-DD HH24:MI:SS')
>
> What is wrong?