[Babase] Query trouble
Catherine Markham
amarkham at princeton.edu
Thu Mar 19 17:18:20 EDT 2009
Hi Karl,
It was the caps in the column names that messed me up. After reading
your comments, I changed everything to lower case and the query worked
perfectly. Thanks!
Catherine
Karl O. Pinc wrote:
>
> On 03/18/2009 08:24:01 PM, Catherine Markham wrote:
>> Hi all,
>>
>> Has anyone ever got the SQL error code that a column in their table
>> does not exist? Two tables that I recently created in my schema are
>> having the same query problem, but other (older) tables in my schema
>> and the Babase tables work great with comparable queries.
>>
>> Any thoughts? Would any other info help to figure out what the
>> problem is?
>
> Are you qualifying the column names with the table name and the
> table name with the schema name? There may be another table
> with the same name in another schema that's confusing it.
> There's a "search path", but I forget what it's called.
> If you're using the ppa sql popup window it's in the window
> somewhere.
>
> Do you have any upper case in the column names?
> If so you may need to enclose
> the names of the columns in single quotes 'tablename.colname' or
> just 'colname'. Using upper case is not a good idea.
>
>>
>> Thanks - I'm definitely stumped since I know the query structure
>> itself works in other tables (leading me to believe it is something
>> funky with these tables).
>>
>> Catherine
>>
>> P.S. Specific example resulting in the same error message from a
>> simplified query here:
>>
>> SQL error:
>>
>> ERROR: column tempcode.grp does not exist
>>
>> In statement:
>> select tempcode.grp from tempcode
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list