After talking to Epicor support I did find an answer to my question and figured I'd post it. The quick explanation is that a TIME statement works by default with Vantage8 in Progress as well as E9 in Progress and SQL.
Having said that, you can trick it into working in Vantage 8 on SQL by putting a FIRST or LAST selection in your BAQ criteria (instead of an EACH). This forces the query to run with Progress syntax rather than SQL. Once you've got that in there a TIME command will work just fine!
For my BAQ calculated field I used this format to return the current time:
expression: STRING(TIME,"HH:MM:SS")
format: x(8)
data type: Character
Hope it helps someone some day!
Eric
Having said that, you can trick it into working in Vantage 8 on SQL by putting a FIRST or LAST selection in your BAQ criteria (instead of an EACH). This forces the query to run with Progress syntax rather than SQL. Once you've got that in there a TIME command will work just fine!
For my BAQ calculated field I used this format to return the current time:
expression: STRING(TIME,"HH:MM:SS")
format: x(8)
data type: Character
Hope it helps someone some day!
Eric
--- In vantage@yahoogroups.com, sysadmin@... wrote:
>
> Hello Len,
>
>
>
> The "4GL reference guide" would be Progress-related and of questionable
> value to you for your SQL implementation. But, if you are still interested,
> you can check out one or both of the following web pages:
>
>
>
> OpenEdge 10.1C: http://communities.progress.com/pcom/docs/DOC-15987
>
>
>
> OpenEdge 10.2A: http://communities.progress.com/pcom/docs/DOC-15972
>
>
>
> Near the top of both pages, you will see a link to download the entire
> OpenEdge documentation set for the respective version, or you can download
> individual documents.
>
>
>
> Regards,
> Scott
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Len Hartka
> Sent: Wednesday, February 03, 2010 5:45 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] How can I show the current system time?
>
>
>
> Good Day Eric:
>
> Is the 4GL book you refer to something from\within Epicor or from a
> third party?
>
> Sun Is on M2K (Informix) but,
> Going to: Epicor 9, 9.04 ( maybe 9.05), SQL (live 7/1/2010- maybe
> 8/1/10)
>
>
> len.hartka@sunautom <mailto:len.hartka%40sunautomation.com> ation.com
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf
> Of precisionwirecomponents
> Sent: Wednesday, February 03, 2010 5:36 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] How can I show the current system time?
>
> We have a number of BAQs and dashboards that use the TODAY function to
> filter data. Is there a similar command for getting the current system
> time into a dashboard filter or calculated BAQ field?
>
> The 4GL reference guide mentions TIME and DATETIME but I can't seem to
> get them to work in a BAQ.
>
> Just wondering if anyone has tackled this before?
>
> Thanks,
> Eric
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>