On Tuesday 09 January 2007 00:37, Carl Karsten wrote: > johnf wrote: > > OK I have tested our current dbMsSQL.py with Northwind SQL2000. It has > > at least one issue. It currently does not understand the image type. > > Image is new and will not be going away. The data appears to be a single > > hex (0xFFF123A000000 etc...) continuous line. What do you guys feel > > would be best to handle this field. There are other issues. When > > browsing the tables from the "Add From Data Environment" some tables do > > not display their fields. At first I thought this was because a field > > type was not recognize but they work in testing form. So I don't know at > > the moment. > > > > Ed: It DOES work with "ntext" and I think it is working with 'money' > > (changed it to numeric). > > oh, why didn't you say so.. :) > > Check out what I just committed. it handles everything - images, text, > etc., but the UI doesn't. I am guessing this is an improvement? > > also, I think your code has a bug: the database name wasn't being used. so > I think if there was the same table name in two different db's, it would > ... something bad. i fixed that, but with a hack. I couldn't figure out > how to get the db name from the connection. > > Carl K > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
I don't understand the need to do anything with database name??? I doubt your code does any harm - so why not. The problem has always been the UI not handling the special data types not getting the types. I have been able to get the data and I think all the fields are present. Did your testing reveal an error in getting the fields? I'm unsure how the dabo types are handled - which is why the special fields are not displaying. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
