Hi,
  
 I am querying a Firebird 1.5.3 database with python code using the python 
firebirdsql module. All works well (query returns values as expected) with up 
to 10 columns from two tables, but when I add an 11th column I get the error:
 “NameError: global name ‘INFO_SQL_SELECT_DESCRIBE_VARS’ is not defined” from 
the SQL execute statement. If I remove any one of the 11 columns from the query 
it works so it doesn’t appear related to a bad column name.
  
 The database is not one I created, so I don’t know if the creator did 
something to lock it down in some way, or if Firebird is even able to do this.
  
 My SQL query is as follows …
  
 strquery="SELECT t.measured_datetime , t.results_dose, t.results_axsym, 
t.results_trsym, \
                 t.results_qaflat, t.signature, t.set_key, d.beam_on_time, \
                 d.d24_counts, d.d34_counts, d.d44_counts \
                 FROM dqa3_trend t \
                 JOIN tomo_data d ON (t.data_key = d.data_key) \
                 WHERE extract (month from t.measured_datetime) = extract 
(month from CURRENT_DATE) \
                 AND extract (year from t.measured_datetime) = extract (year 
from CURRENT_DATE) \
                 AND (t.set_key=25 OR t.set_key=26)"
  
 Any suggestions as to what might be causing this observed behaviour?
  
 In appreciation,
 Gary
 

  • [firebird-support] ... ggoo...@yahoo.com [firebird-support]

Reply via email to