Alastair,
I believe Stephen is on the right track. One way to check is to start adding
(or subtracting) columns one at the time, when you add (or subtract) the column
that is creating the problem the error will show (or disappear if subtracting
columns) and that should give you the name of the column creating the issue and
you can investigate further if it has a different definition on an existing
table or perhaps on another active view.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of
Stephen Markson
Sent: Friday, January 27, 2017 1:13 PM
To: [email protected]
Subject: RE: [RBASE-L] - View: Union / Group By - cannot see what's wrong
Alistair, if the COLCHECK setting is solving the problem, that may indicate
that one of view column aliases is the same as a column name in some other
table with a different datatype.
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: [email protected] [mailto:[email protected]] On Behalf Of
Alastair Burr
Sent: January-27-17 12:52 PM
To: [email protected]
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong
Thank you very much, Razzak, setting ColCheck off did the trick.
I notice that if I turn ColCheck back on I immediately get the error message
again as soon as I try to use the view.
I have looked at the names in the view almost endlessly today to try and see
where the error was so I am puzzled as to where R:Base finds a difference.
I think I would rather correct that than run with ColCheck set off all the
time. Obviously I can change the setting in a command file before and after use
but what has raised this problem is the error message is received whenever I
reconstruct the database from unloads. (But not with Reload.)
This may be a complete misinterpretation but I also have a suspicion that this
particular error has been causing problems with my user privileges. Is that
possible? If so, I may have to run with ColCheck set to off all the time. With
that in mind when was ColCheck introduced and/or was it changed with the
upgrade to v10?
Again thanks,
Regards,
Alastair.
On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,
A few questions ...
01. What is the COLCHECK setting?
SHOW COLCHECK
02. What results do you get when turning OFF the COLCHECK setting.
SET COLCHECK OFF
FYI, COLCHECK ON setting checks the consistency for column names and data types
when making views.
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak.
At 11:24 AM 1/27/2017, Alastair Burr wrote:
I know it's Friday but can anybody see what's wrong with this view (an image so
that hopefully the email system doesn't mangle my layout):
If it hasn't, there should be 6 columns so that I could see the columns and
data types (first 5 rows remmed out) more easily.
I am not sure that I am defining the time entries correctly - I've tried with
as well as without quotes.
I am pretty sure I have the data types right - despite the error message.
I am not sure that I have the group by right. I only really need to group by:
T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist
name).
[]
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
