q-lang-users

[q-lang-users] Cannot query table after odbc_columns

[Jiri S. <jir...@bl...>]

Hello Albert,

I am not able to query a table using ODBC after a call of odbc_columns:

  > odbc_columns DB "units"
  > [("sector","varchar",(),()),("producer","varchar",(),()), .......
  > sql DB "select * from units" ()
  > q[pid 3108]: caught signal 11, exiting

I am using Windows version and it does the same with both Access and 
Postgres.

Cheers,

Jiri

Re: [q-lang-users] Cannot query table after odbc_columns

[Albert G. <Dr....@t-...>]

Jiri Spitz wrote:
> I am not able to query a table using ODBC after a call of odbc_columns:
> 
>   > odbc_columns DB "units"
>   > [("sector","varchar",(),()),("producer","varchar",(),()), .......
>   > sql DB "select * from units" ()
>   > q[pid 3108]: caught signal 11, exiting
> 
> I am using Windows version and it does the same with both Access and 
> Postgres.

I don't have an ODBC install right now to test this, but I remember 
running this on Linux (using MySQL, I guess) and it worked. The code 
looks ok (in fact I lifted it from an MSDN page). Can you reproduce this 
with Postgres on Linux?

Albert

-- 
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email:  Dr....@t-..., ag...@mu...
WWW:    http://www.musikinformatik.uni-mainz.de/ag

Re: [q-lang-users] Cannot query table after odbc_columns

[Jiri S. <jir...@bl...>]

Albert Graef wrote:
> I don't have an ODBC install right now to test this, but I remember 
> running this on Linux (using MySQL, I guess) and it worked. The code 
> looks ok (in fact I lifted it from an MSDN page). Can you reproduce this 
> with Postgres on Linux?
> 

Yes, I can:

==> import odbc

==> def A = odbc_connect "DSN=efom"

==> odbc_columns A "units"
[("sector","varchar",(),()),("producer","varchar",(),()), ..............

==> sql A "select * from units" ()
q[pid 8967]: caught signal 11 (Segmentation fault), printing 
backtrace... 2 stack frames
q(__qq__segv_handler+0x8c)[0x8050d8c]
[0xb7f4b420]
Segmentation fault

OTOH, it is nothing urgent. There is an easy workaround - I can open the 
DB twice and perform SSQLs on the second DB handle.

Cheers,

Jiri

Re: [q-lang-users] Cannot query table after odbc_columns

[Albert G. <Dr....@t-...>]

Jiri Spitz wrote:
> OTOH, it is nothing urgent. There is an easy workaround - I can open the 
> DB twice and perform SSQLs on the second DB handle.

Ok, if it's not a showstopper then I'll have another look when I port 
that module to Pure.

-- 
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email:  Dr....@t-..., ag...@mu...
WWW:    http://www.musikinformatik.uni-mainz.de/ag