It could certainly work in u2 SQL - not sure how you would do this in
English (MVQuery or whatever) tho
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: 08 April 2010 06:55
To: U2 Users List
Is there a way in SQL without resorting to subqueries to select a table, then
save the resulting field,
Then use that list for a future SQL query?
ex. select customerid from invoicefile;
save the list of customerid for later use
later
get that list of customerid
select
INSERT INTO temptable (customerid)
SELECT customerid FROM invoicefile
You then have your temp table with customerIDs so can use as such
select cust.name , cust.addr , cust.city from customerfile cust inner join
temptable temp on temp.customerid = cust.id where cust.st = 'ny'
So you can then
So for each listname you would need to create a new temp table,
and clear the table prior to saving a list?
Thanks for the info...
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent:
If you mean UniVerse SQL - for a regular query in the same way as a retrieve
statement, you can supply an active select list using the SLIST clause.
SELECT BOOK_TITLES WITH GENRE = FICTION
SELECT * FROM BOOK_TITLES SLIST 0
But if you're not using it in the same way as a retrieve statement i.e.
Would those of you mind responding that use 3-Tier or N-Tier architecture - I'm
trying to gather some quick numbers for some decision makers (somewhat urgent).
Please respond if your site, or sites who you service have UniData, UniVerse,
or any other MV db on the backend, and any fully
Hi Baker,
There's no way to respond to this that doesn't sound like an ad, so I marked
the response as an ad...
We have multiple product lines and numerous customers who do various types of
GUI interfaces to MV, with some great successes in the list.
Most of our larger customers that do these
The reason I asked about what you're doing exactly Bill, is that it's not
strictly necessary to wake up a phantom every minute to decide if there is
anything to do. You can also write routines that poke the phantom to wakeup
right now.
Will
___
You might try...
select custname, custaddr, custcity from customerfile where
custid in (select EVAL @RECORD from SAVEDLISTS
'the_saved_list_name');
Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
Hi Symeon,
I have been trying to think how you would use CTE (or equivalents) in u2
SQL. Are you willing to enlighten us?
Regards
Phil
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent:
If processes are putting things in a queue for a phantom to process and
you use PAUSE, the processes can use WAKE to signal the phantom that it
has something to do. This way, the cycle time can be much longer,
reducing the number of periodic checks. The result is better response
time on items
How about
SELECT CUSTNAME, CUSTADDR, CUSTCITY FROM CUSTOMERFILE SLIST 'saved_list-name';
Regards,
Clif
--
W. Clifton Oliver, CCP
CLIFTON OLIVER ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
On Apr 8, 2010, at 1:28 PM, Perry Taylor wrote:
You might try...
select
Dan, what version of UniData are you running. I reported a similar bug
several years ago and it was fixed in version 6.1.7. With that bug, it
happened when the process was killed, and then even logging out wasn't
sufficient; any process reusing the UDTNO of the killed process could no
longer
I tested it in UniData 7.2.5 and the problem I described exists.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
dean.armbrus...@ferguson.com
Sent: Friday, 9 April 2010 7:34 AM
To: u2-users@listserver.u2ug.org
Hi Baker,
We are heavily into layers, using UniVerse Microsoft VB.Net.
User level: VB.Net using menus, data entry, queries, Pick reports, Forms,
prompts, processing.
VB/UV interface level: between UniVerse and user, in VB.Net, using UniVerse
Objects.
Tools level: UniVerse parameters
Hi Baker,
We're doing a lot of java through web services and servlets. Mostly with
Tomcat and Glassfish.
Several servlets for reports and inquiries.
Several java user interfaces that utilize web services that connect to
UD for wireless picking, tag and label printing.
HTH
Jeff
On
Hi Baker
We have 2 tier with the business rules in the database and a VB.Net frontend.
We are also installing 3 tier with webservise based on IINet. The backend is
UniVerse
We use VB.Net as it has better interaction with office, that C# cannot easily
do and it is easier for people who have
That should be pretty straightforward in U2 SQL - I'd probably put a DISTINCT
clause in - otherwise you'll probably get repeating customer records:
SELECT DISTINCT customerid FROM invoicefile TO SLIST 9;
SELECT cust.name , cust.addr , cust.city, etc FROM customerfile SLIST 9
WHERE
One scenario off the top of my head would be to allow recursive selects. This
would be similar to a qselect, where you select a list of MVs from a record,
but would also allow you to include the parent id and any child ids and
grandchild ids, etc as a result of the CTE select.
Eg. A master
In the last 2 days we have had problems with our sendmail routine. It
seems to get hung up sporadically.
I just did a mailq -v -d | more and got this information
-
QAA44132 211524 691719 Apr 8 16:44
There is *NO* CTE functionality in U2 at all as far as I'm aware. However, I
think it would be a worthwhile addition if it could be implemented both for
Retrieve (mvquery) and U2 SQL.
CTEs are now supported in the major SQL DBs...
Stuart Boydell
-Original Message-
From:
We're also using Apache Tomcat 6 w/ a Java Servlet.
The front end has Java 1.6, hibernate (writing to PICK), ajax, and html.
The back end is done in UniVerse BASIC which we use for our reports and
database.
It's basically one medium size web application.
-Chris
Date: Thu, 8 Apr 2010
Hi Baker,
a) We, and our VARS/clients, utilize a middle tier, and you could also
introduce an intermediate MV application server in the chain for
execution of business rules intermediate staging if necessary
(conducted Proof on Concept for one prospect).
b) Not us
c) We use Microsoft IIS and
I'd have to think about it a bit, but wouldn't your scenario be a good case for
a BY-EXP clause? I haven't used a BY-EXP in years! :o
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Thursday,
24 matches
Mail list logo
