Yep
All permission's are set to PUBLIC
It is frustrating since most of the DOCS give examples of utilizing SQL
statements as if you attempting to manipulate Unidata data within the
Unidata server itself (duh -- now why would I be attempting to make like
more complicated for no good reason?) OR
I have a table with a MV status code and date field. I am trying to
select just those records that have both status code A and B and when
the date associated with code B is blank
I tried
SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE =
But this will select records which might have a
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B and when the date associated with code B is blank
I tried
SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE =
But this will select records which might have a
I haven't actually tried this...but you could create a new dictionary;
e.g.
1 S
2 0
3 Status*Date
8 A;2:*:3
9 L
10 10
Then select where new dict = A*] and B*
Mark
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
How about something like:
SELECT TAB WITH STATUS = A AND WITH EVAL 'IF STATUS = B THEN IF ST_DATE
= THEN 1 ELSE 0 ELSE 0 ' = 1 '
HTH,
Bill
__
From: Noah Hart n...@lipmantpa.com
Sent: 2/17/2009 10:26 AM
What is the actual sql command you are performing ?
It is a bit confusing as the error talks about an insert but it is a select
it is showing.
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin
Sent: 17