Re: Database What the ...

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