Hi robert
Describe a scenario: with reproduceable steps. Because you know we are a lot of load code from MC and we do not have problem. Stef On Sep 1, 2009, at 11:48 PM, Robert Sirois wrote: > Code loaded via Monticello from a directory on my hard drive. Its > stuff I have written. > > RS > > > From: [email protected] > > Subject: Pharo-project Digest, Vol 17, Issue 9 > > To: [email protected] > > Date: Tue, 1 Sep 2009 20:38:20 +0200 > > > > Send Pharo-project mailing list submissions to > > [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > or, via email, send a message with subject or body 'help' to > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of Pharo-project digest..." > > > > > > Today's Topics: > > > > 1. Re: ODBC: table names and column names/types? (Benoit St-Jean) > > 2. Re: Class Version (Michael Roberts) > > 3. Re: ODBC: table names and column names/types? (Benoit St-Jean) > > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Tue, 1 Sep 2009 10:15:10 -0700 (PDT) > > From: Benoit St-Jean <[email protected]> > > Subject: Re: [Pharo-project] ODBC: table names and column names/ > types? > > To: "Schwab,Wilhelm K" <[email protected]> > > Cc: [email protected] > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset="iso-8859-1" > > > > To get a list of tables for SQL Server (or even MySQL 5.x): > > > > SELECT > > TABLE_SCHEMA, TABLE_NAME > > FROM > > INFORMATION_SCHEMA.TABLES > > > > > > > > Hope this helps... > > > > ----------------- > > Benoit St-Jean > > Yahoo! Messenger: bstjean > > Blog: lamneth.wordpress.com > > A standpoint is an intellectual horizon of radius zero. > > (Albert Einstein) > > > > > > > > > > ________________________________ > > From: "Schwab,Wilhelm K" <[email protected]> > > To: Benoit St-Jean <[email protected]> > > Sent: Tuesday, September 1, 2009 9:59:06 AM > > Subject: RE: [Pharo-project] ODBC: table names and column names/ > types? > > > > > > That is very > > interesting. Where there is immediate need, 5.x is installed. > > Thinking about this some more, the mix of clients and servers is > more > > like: > > > > Clients: > > windows, linux > > > > Servers: > > SQL server > > on Windows > > MySQL on > > Windows and Linux > > .mdb file > > (mostly migrated to MySQL) > > > > Is > > there a similar schema trick on SQL server? However, I just gave > myself > > query access to the MySQL schema, and would not have such control > over the SQL > > server. It might pay for me to write the code to read the > > schema via ODBC functions. > > > > Bill > > > > > > > > > > ________________________________ > > From: Benoit St-Jean [mailto:[email protected]] > > Sent: Tuesday, September 01, 2009 8:11 AM > > To: [email protected] > > Cc: Schwab,Wilhelm > > K > > Subject: Re: [Pharo-project] ODBC: table names and column > > names/types? > > > > > > Which > > version of MySQL? Since version 4.1, there's all you need in the > > "INFORMATION_SCHEMA" database, in the "TABLES" table. But because > of some > > bug in 4.1, query against that database sometimes caused the > server to > > crash. I'd recommend that method only for 5.x and upwards. > > > > ----------------- > > Benoit St-Jean > > Yahoo! Messenger: > > bstjean > > Blog: lamneth.wordpress.com > > A standpoint is an intellectual > > horizon of radius zero. > > (Albert Einstein) > > > > > > > > > > ________________________________ > > From: "Schwab,Wilhelm K" > > <[email protected]> > > To: "[email protected]" > > <[email protected]> > > Sent: Tuesday, September 1, 2009 6:58:49 > > AM > > Subject: Re: [Pharo-project] > > ODBC: table names and column names/types? > > > > > > Primarily > > MySQL running on Windows (Linux as soon as reasonable to do so) > accessed from > > both Windows and Linux. There will also be the occaisional .mdb > > file. > > > > > > > > ________________________________ > > From: [email protected] > > [mailto:[email protected]] On Behalf Of > Mariano > > Martinez Peck > > Sent: Tuesday, September 01, 2009 3:18 AM > > To: [email protected] > > Subject: Re: [Pharo-project] ODBC: > > table names and column names/types? > > > > > > > > > > On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <[email protected] > > wrote: > > > > I > > > looked through it in MC, but did not see anything obvious. Even > then, I > > > doubt it is a workable choice for me because regardles of what X > and - mean in > > > their doumention, one of the DBMS/OS pairs I need is not > supported. > > > > > > > > > > Hi Bill! Which is the combination of your RDBMS / OS ? > > > > Regards from the ESUG :) > > > > Mariano > > > > > > > > >-----Original Message----- > > >From: [email protected] > > > >[mailto:[email protected] > ] > > > On Behalf Of Esteban A. Maringolo > > >Sent: Monday, August 31, 2009 6:38 > > > PM > > >To: [email protected] > > >Subject: > > > Re: [Pharo-project] ODBC: table names and column names/types? > > > > > >Hello > > > Bill, > > > > > >2009/8/31 Schwab,Wilhelm K <[email protected]>: > > >> > > > Hello all, > > >> > > >> Is there anything available for Pharo that gives > > > schema information about a database? > > > > > >Doesn't SqueakDBX do > > > that? > > > > > >Regards, > > > > > >Esteban A. > > > Maringolo > > > > > >_______________________________________________ > > >Pharo-project > > > mailing list > > >[email protected] > > >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > > > > >_______________________________________________ > > >Pharo-project > > > mailing list > > >[email protected] > > >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > > > > > > ________________________________ > > Make your browsing faster, safer, and easier with the new Internet > Explorer? 8. > > Optimized for Yahoo! Get it Now for Free! > > > > > > __________________________________________________________________ > > Yahoo! Canada Toolbar: Search from anywhere on the web, and > bookmark your favourite sites. Download it now > > http://ca.toolbar.yahoo.com. > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > http://lists.gforge.inria.fr/pipermail/pharo-project/attachments/20090901/b555fc7b/attachment-0001.htm > > > > ------------------------------ > > > > Message: 2 > > Date: Tue, 1 Sep 2009 18:19:53 +0100 > > From: Michael Roberts <[email protected]> > > Subject: Re: [Pharo-project] Class Version > > To: [email protected] > > Message-ID: > > <[email protected]> > > Content-Type: text/plain; charset=ISO-8859-1 > > > > Can you provide a bit more info? This is code you have typed in > > directly? or loaded via changeset, Monticello etc? > > > > Cheers > > mike > > > > On Tuesday, September 1, 2009, Robert Sirois > <[email protected]> wrote: > > > > > > > > > > > > > > > > > > Pharo doesn't seem to be using the correct version of my > classes. I have tried deleting the entry point and remade it and > saved and quit the image and all that. Is there a way to get it to > re-register them or something? > > > > > > Thanks, > > > RS > > > > > > Windows Live: Keep your friends up to date with what you do > online. Find out > more.?<http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009 > > > > > > > > > > > > > > ------------------------------ > > > > Message: 3 > > Date: Tue, 1 Sep 2009 11:38:11 -0700 (PDT) > > From: Benoit St-Jean <[email protected]> > > Subject: Re: [Pharo-project] ODBC: table names and column names/ > types? > > To: "Schwab,Wilhelm K" <[email protected]> > > Cc: [email protected] > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset="iso-8859-1" > > > > I know, it's a mess... I have a persistence framework that > supports DB2, Oracle, MySQL, SQLServer and Interbase and it's a > nightmare whenever you try to do anything related to catalogs... And > planning to integrate PostgreSQL as well... > > > > In case you wanna try to implement that stuff differently by > calling the ODBC function, have a look at : > > > > http://msdn.microsoft.com/en-us/library/ms711831%28VS.85%29.aspx > > > > Caution: since you're in Linux, I'd also check iODBC (or whatever > you use) for the same API... just in case they would differ (most > likely!). This might be a simpler way to accomplish what you need... > > > > For Oracle, you might wanna query against the DICTIONARY view to > get the same information... > > > > Hope this helps. > > > > ----------------- > > Benoit St-Jean > > Yahoo! Messenger: bstjean > > Blog: lamneth.wordpress.com > > A standpoint is an intellectual horizon of radius zero. > > (Albert Einstein) > > > > > > > > > > ________________________________ > > From: "Schwab,Wilhelm K" <[email protected]> > > To: Benoit St-Jean <[email protected]> > > Sent: Tuesday, September 1, 2009 2:14:06 PM > > Subject: RE: [Pharo-project] ODBC: table names and column names/ > types? > > > > > > It might be helpful. Something similar works for > > the columns, but getting it to work with a where clause seems to > be needlessly > > fragile. I have code that generates SQL that works just about > anywhere, > > but not with the SQL server information schema. Given MS' > involvement, I > > can't help but think that they might be using a different query > engine or > > something equally stupid. I have also seen documention suggesting > that > > this will not work with Oracle, which is also on my list. Still, > this > > might provide a nice shortcut to the ODBC schema functions. > > > > Thanks, > > > > Bill > > > > > > > > ________________________________ > > From: Benoit St-Jean [mailto:[email protected]] > > Sent: Tuesday, September 01, 2009 12:15 PM > > To: Schwab,Wilhelm K > > Cc: [email protected] > > Subject: Re: [Pharo-project] ODBC: > > table names and column names/types? > > > > > > To > > get a list of tables for SQL Server (or even MySQL 5.x): > > > > SELECT > > TABLE_SCHEMA, TABLE_NAME > > FROM > > > > INFORMATION_SCHEMA.TABLES > > > > > > > > Hope this helps... > > > > ----------------- > > Benoit > > St-Jean > > Yahoo! Messenger: bstjean > > Blog: lamneth.wordpress.com > > A > > standpoint is an intellectual horizon of radius zero. > > (Albert Einstein) > > > > > > > > > > ________________________________ > > From: "Schwab,Wilhelm K" > > <[email protected]> > > To: Benoit St-Jean > > <[email protected]> > > Sent: Tuesday, September 1, 2009 9:59:06 AM > > Subject: RE: [Pharo-project] ODBC: table > > names and column names/types? > > > > > > That is very > > interesting. Where there is immediate need, 5.x is installed. > > Thinking about this some more, the mix of clients and servers is > more > > like: > > > > Clients: > > windows, linux > > > > Servers: > > SQL server > > on Windows > > MySQL on > > Windows and Linux > > .mdb file > > (mostly migrated to MySQL) > > > > Is > > there a similar schema trick on SQL server? However, I just gave > myself > > query access to the MySQL schema, and would not have such control > over the SQL > > server. It might pay for me to write the code to read the > > schema via ODBC functions. > > > > Bill > > > > > > > > > > ________________________________ > > From: Benoit St-Jean [mailto:[email protected]] > > Sent: Tuesday, September 01, 2009 8:11 AM > > To: [email protected] > > Cc: Schwab,Wilhelm > > K > > Subject: Re: [Pharo-project] ODBC: table names and column > > names/types? > > > > > > Which > > version of MySQL? Since version 4.1, there's all you need in the > > "INFORMATION_SCHEMA" database, in the "TABLES" table. But because > of some > > bug in 4.1, query against that database sometimes caused the > server to > > crash. I'd recommend that method only for 5.x and upwards. > > > > ----------------- > > Benoit St-Jean > > Yahoo! Messenger: > > bstjean > > Blog: lamneth.wordpress.com > > A standpoint is an intellectual > > horizon of radius zero. > > (Albert Einstein) > > > > > > > > > > ________________________________ > > From: "Schwab,Wilhelm K" > > <[email protected]> > > To: "[email protected]" > > <[email protected]> > > Sent: Tuesday, September 1, 2009 6:58:49 > > AM > > Subject: Re: [Pharo-project] > > ODBC: table names and column names/types? > > > > > > Primarily > > MySQL running on Windows (Linux as soon as reasonable to do so) > accessed from > > both Windows and Linux. There will also be the occaisional .mdb > > file. > > > > > > > > ________________________________ > > From: [email protected] > > [mailto:[email protected]] On Behalf Of > Mariano > > Martinez Peck > > Sent: Tuesday, September 01, 2009 3:18 AM > > To: [email protected] > > Subject: Re: [Pharo-project] ODBC: > > table names and column names/types? > > > > > > > > > > On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <[email protected] > > wrote: > > > > I > > > looked through it in MC, but did not see anything obvious. Even > then, I > > > doubt it is a workable choice for me because regardles of what X > and - mean in > > > their doumention, one of the DBMS/OS pairs I need is not > supported. > > > > > > > > > > Hi Bill! Which is the combination of your RDBMS / OS ? > > > > Regards from the ESUG :) > > > > Mariano > > > > > > > > >-----Original Message----- > > >From: [email protected] > > > >[mailto:[email protected] > ] > > > On Behalf Of Esteban A. Maringolo > > >Sent: Monday, August 31, 2009 6:38 > > > PM > > >To: [email protected] > > >Subject: > > > Re: [Pharo-project] ODBC: table names and column names/types? > > > > > >Hello > > > Bill, > > > > > >2009/8/31 Schwab,Wilhelm K <[email protected]>: > > >> > > > Hello all, > > >> > > >> Is there anything available for Pharo that gives > > > schema information about a database? > > > > > >Doesn't SqueakDBX do > > > that? > > > > > >Regards, > > > > > >Esteban A. > > > Maringolo > > > > > >_______________________________________________ > > >Pharo-project > > > mailing list > > >[email protected] > > >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > > > > >_______________________________________________ > > >Pharo-project > > > mailing list > > >[email protected] > > >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > > > > > > ________________________________ > > Make your browsing faster, safer, and easier with the new Internet > Explorer? 8. > > Optimized for Yahoo! Get it Now for Free! > > ________________________________ > > Looking for the perfect gift?Give the > > gift of Flickr! > > > > > > __________________________________________________________________ > > The new Internet Explorer? 8 - Faster, safer, easier. Optimized > for Yahoo! Get it Now for Free! > athttp://downloads.yahoo.com/ca/internetexplorer/ > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > http://lists.gforge.inria.fr/pipermail/pharo-project/attachments/20090901/664b59d8/attachment.htm > > > > ------------------------------ > > > > _______________________________________________ > > Pharo-project mailing list > > [email protected] > > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > > > End of Pharo-project Digest, Vol 17, Issue 9 > > ******************************************** > > Windows Live: Make it easier for your friends to see what you’re up > to on Facebook. Find out > more._______________________________________________ > Pharo-project mailing list > [email protected] > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project _______________________________________________ Pharo-project mailing list [email protected] http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
