Re: sql-odbc: accessing row elements by column name?

[address@hidden]

Scott McKay wrote:
> "Chris Double" <chris@double.co.nz> wrote in message
> uy9ad5jsm.fsf@double.co.nz">news:uy9ad5jsm.fsf@double.co.nz...
> 
>>Carl Gay <carlgay@attbi.com> writes:
>>
>>
>>>I like JDBC's ability to access row elements by name.  Is there any
>>>way to do that in the SQL-ODBC library?
>>
>>There doesn't seem to be a way unfortunately. The source for the
>>SQL-ODBC library shipped with Harlequin Dylan 1.0 and was removed in
>>later versions. If you can find the personal edition of HD 1.0 then
>>you can get the source and play with it.
>>
>>Chris.
> 
> 
> Is the return value a single vector of columns?
> 
> It would probably be simple enough to extend it to return a second value
> that has the column names.  Although, now that I remember who wrote
> this code, maybe that's not so simple.
> 
> Is this not open-source in FunO Dylan?  I guess it's probably only in the
> professional edition...
> 
> 


If I recall correctly, when I wrote the SQL-ODBC library 6 or 7 years 
ago, ODBC either didn't support this feature or it wasn't working well 
for the targeted DBMSes. Although, it’s possible that not supporting 
this feature was an oversight on my part.

Given all the changes that have occurred in the DBMS landscape over the 
last 7 years, this library could use a redesign. In terms of feature 
sets, it won't compare to JDBC.

While my design and programming skills in Dylan were not at Scott's 
level, the library was designed to be extensible. And yes, the library 
does have some design shortcomings. However, I would have preferred that 
Scott looked at the code instead of recalling my face before judging its 
extensibility.


Edward