Re: odbc_tables()

Hi Matt, >Thanks very much Frank, how about dtproperties ? I never created it but it >still comes up .. do you know what it's for ? It is created by Visual Interdev and is used by that application. I dont use Visual Interdev so I'm not getting the extra table :-) >But thanks, seems like you know what you're talking about ! :) > >About the odbc_tables function, I have played with it for ages and i've read >your post TWO DAYS ago and I still can't get it to work. Great post but >maybe you could provide an example. As I said before I can odbc_result_all >it but I can't actually extract individual values. I only have a complex code where all the functions are put into an ODBC object, but I can write a small sample from that later to day and send you ? - Frank >-- Matt > > >>From: "Frank M. Kromann" <fmk@swwwing.com> >>Reply-To: "Frank M. Kromann" <fmk@swwwing.com> >>To: Matt <icq2000site@hotmail.com> >>CC: <php-general@lists.php.net> >>Subject: Re: [PHP] odbc_tables() >>Date: Wed, 15 Nov 2000 21:47:33 -0600 >> >>Hi, >> >>I have no problems with the functio, but you need to understant the >>parameters ! Read my comments in the manual. >>http://www.php.net/manual/function.odbc-tables.php >> >>If you want to do the same with a SQL statement (On MS SQL Server) you >>sould look at sysobjects. >> >>select name from sysopjects where type='U' >> >>returns the name of all user tables. >> >>- Frank >> >> >I'm sure that many of you have encountered a problem >> >with odbc_tables. After calling this command it is possible >> >to perform a odbc_result_all on it and the entire result is >> >printed nicely however it is far more difficult to store this >> >information into a variable. It's actually a bug, fetch_into_row >> >and fetch_result both do not work. >> > >> >Has anyone found a work around to this ? >> > >> >Btw, does anyone know an SQL statement that will perform a >> >"show tables" function or another way of querying an MSSQL >> >database to retrieve the desired information ? >> > >> >Thanks very much ! >> > >> > >> >-- Matt >> >_________________________________________________________________________ >> >Get Your Private, Free E-mail from MSN Hotmail at >> >http://www.hotmail.com. >> > >> >Share information about yourself, create your own public profile at >> >http://profiles.msn.com. >> > >> > >> >-- >> >PHP General Mailing List (http://www.php.net/) >> >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >> >For additional commands, e-mail: php-general-help@lists.php.net >> >To contact the list administrators, e-mail: php-list-admin@lists.php.net >> > >> > >> > >> >> >> > >_________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com. > > >