×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Jon,
I'm just curious about the usage of a SEQUENCE object. A SEQUENCE object is a just a Data Area object which holds the sequence value.
I would think this expression would be the same: Right(Digits(Row_Number() Over()),2) As Team
Jim
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Jon Paris <jon.paris@xxxxxxxxxxxxxx>
Sent: Sunday, September 30, 2018 11:51 AM
To: Midrange-L
Subject: Re: Database What the ...
Warning ... danger Will Robinson ...
Read this if you use Run SQL Scripts _AND_ use the save results facility!
The problem described in my previous posting appears to be caused by selecting the ACS option to save results!
If I deselect that option the SQL works perfectly as it has always done. With the option selected the generated sequence values are wrong. I have no idea what other potential problems can be caused by this - just beware!
Right now I'm using the dBeaver plugin for RDi instead of ACS and it is working as expected.
Jon Paris
www.partner400.com<
http://www.partner400.com>
www.SystemiDeveloper.com<
http://www.SystemiDeveloper.com>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
