I was just going to add I think UniData has the STATUS() function. So I test
locks
like:
** Read vendor route selection
READU VREC FROM APVENDOR, VENDNO LOCKED
LOCK.SW= 1
FileString = NULL$
LogFlag= NULL$
CALL LOCK.MSG (FileString, LogFlag, LockMsg) ; LockMsg := Press
Jeff
SELECT DISTINCT @ID TO SLIST 0 FROM UNNEST FILENAME ON FIELD WHERE
NOT(FIELD LIKE
'SF%' OR FIELD LIKE 'SH%') ;
The SQL is less of an overhead than doing a by-exp with SAVING UNIQUE @ID in
RetrieVe.
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Perhaps a UniBasic program would be workable.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeffrey Butera
Sent: Friday, June 20, 2008 11:26 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
I can't get my head around the
I'm sure there's a much cleverer query-only way of doing this. But I'd
just do a merge list. Select all the records into one list. Select
into another all records WITH EVERY FIELD LIKE 'SF...''SH...' Then grab
the difference.
Katie
Katie Morgan
Datatel Programmer/Analyst
Linfield College
I think you are on the right track with this one, but change the AND to OR. I
wanted to include the EVERY keyword before each field but I think that is
assumed.
SELECT FILE WITH FIELD UNLIKE SF... AND FIELD UNLIKE SH...
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2]
I have an xml map that looks like: (partial)
ColumnMap Node=REASON Column=REASON/
ColumnMap Node=ODOMETER Column=ODOMETER/
ColumnMap Node=TRAVELTIME Column=TRAVELTIME/
The record is built and each of the Columns is a dictionary item.
The xml used to look like this (partial):
VEHICLE ID=23485
Use WHEN instead of WITH on MV fields?
Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Why not write a new dictionary item?
This can set a flag if FIELD is neither SF456 nor SH456.
Let's call it VALID.FIELD
I would use the following A-correlative
A;IF N(FIELD) = SF456 THEN ELSE IF N(FIELD) = SH456 THEN ELSE 1
That would work at least in UniData - not sure if UV supports
