Thanks, Jim, I'll bear that in mind when I check again (see my reply to Javier). Other view(s) may well be the cause and that I didn't check.
Regards, Alastair. On 29/01/2017 00:07, 'James Bentley' via RBASE-L wrote: Alistair, To the best of my knowledge, if you are relying on the LIST COLUMN command you see only the table columns you DO NOT see the columns defined in views you need to access the SYS_COLUMNS table to determine if there is a conflict between previously defined view columns and the View columns you are trying to create. The SYS_COLUMNS table contains column names for both TABLE Columns and View Columns. The LIST COLUMNS command only shows info on Table columns not view columns. Jim Bentley, American Celiac Society 1-504-305-2968 ________________________________ From: Alastair Burr <[email protected]><mailto:[email protected]> To: "[email protected]"<mailto:[email protected]> <[email protected]><mailto:[email protected]> Sent: Friday, January 27, 2017 1:39 PM Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong Thanks, I don't _think_ that's the case as part of the reason I laid the view out so precisely was to try and double/triple check the types and see what each referred to in both selects. Nevertheless, I will go back and look again just in case. And Albert, thanks, I will try quoting the dates as well. Regards, Alastair. On 27/01/2017 19:12, Stephen Markson wrote: 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]> [mailto:[email protected]] On Behalf Of Alastair Burr Sent: January-27-17 12:52 PM To: [email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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.
