Hi, I finally found that when called in C with the same api calls that those made by opendbx, sqlite correctly returns datatype of columns when fetching rows, the problem is clearly that the data type is stored in SQueakDBX column description for the resultset the first time it fetches the first row. For sqlite, squeakdbx should call the sqlite api to retrieve column datatype for each row and each colum while fetching data. But it may have implications I don't know. Perhaps squeakDbx could get only true object values (are rawValues really needed) ?. Or perhaps another solution would be to call the sqlite api if the stored datatype is UNKNOWN in column description ... (only for sqlite, but sounds like a bad trick) I am perplexed ...
Any idea is welcome Cheers Alain "Mariano Martinez Peck" <[email protected]> a écrit dans le message de news: CAA+-=mw69g-mp3fqutj9vvhajrop9ezdv5z0zkv9junyzet...@mail.gmail.com... On Sat, Aug 13, 2011 at 12:06 AM, Alain Rastoul <[email protected]> wrote: It doen't work. Howerver googling for opendbx msg00483, I found http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.html yes, that one :) it seems to be the problem of the issue 10, and I think the same problem I have.. yes Sorry, I cannot do more.... :( Strange that it doesn't work with MSSQL too.. "Mariano Martinez Peck" <[email protected]> a écrit dans le message de news: CAA+-=mW4rwrLMhMAzsLhQ5zEWZBG_Jg=BF2dKu3wsxw0=io=iq-jsoawuisxosn+bqq9rb...@public.gmane.org... On Fri, Aug 12, 2011 at 11:14 PM, Alain Rastoul <[email protected]> wrote: I used the following script (about 2 months ago I think ) in Pharo 1.3 "SqueakDBX" Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfSqueakDBX'; load. ConfigurationOfSqueakDBX project latestVersion load. "GLORP" Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfGlorpDBX'; load. ConfigurationOfGlorpDBX project latestVersion load. Yes, you are using SqueakDBX ;) you will move soon to DBXTalk :) II use DBXTestCase for my test with the code I send in my email (is it ok for you?), but I will have alook at DBXQueryTest too. No problem to put it in the test suite - it makes me remember that I still didn't send my license agreement to Stephane but I will do it asap... I hate papers ;-) in our case we don't need that ;) http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.html The link is broken http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.html this one works? -- Mariano http://marianopeck.wordpress.com -- Mariano http://marianopeck.wordpress.com
