Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha scritto: > It pardons me, but the table in object is not part of mine database, > but of the same motor of MySQL. > The fact that is complete with the data, or without data, is not the > true problem. > My function reads the content of this table in order to determine the > structure of a database, and not the data. > The data contained in this table, come inserted automatically from the > motor of MySQL, when they come created objects in the database. > > In the normal situation, the table contains the information > approximately the structure of the objects that MySQL creates of > default, when it comes created database any. > The table “routines” is of property of the “information_schema” > schema, that it is of property of MySQL, and on which writing > operations cannot be made, but only of reading. > The same library of Gambas2, uses this table for populate the objects > “Table”, “Field”, etc > > To this point, it still pardons me, I I do not believe that to send > the dump of this table he is of great usefullness since, if an > installation of MySQL is had, it is possible to verify the problem > directly. > As creed of to have written, the problem does not seem that or caused > from the reading of the field, but its maintenance in memory, if > managed from a complex application… This, obviously, is only a > hypothesis… > > Thanks to you for the patience!
In attached the dump of the database of test. A table is present only... Thanks
-- MySQL dump 10.11 -- -- Host: localhost Database: luigi -- ------------------------------------------------------ -- Server version 5.0.51a /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `table1` -- DROP TABLE IF EXISTS `table1`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `table1` ( `campo1` int(11) NOT NULL auto_increment, `campo2` varchar(50) default NULL, `campo3` decimal(5,2) default NULL, PRIMARY KEY (`campo1`), UNIQUE KEY `campo1` (`campo1`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `table1` -- LOCK TABLES `table1` WRITE; /*!40000 ALTER TABLE `table1` DISABLE KEYS */; INSERT INTO `table1` VALUES (1,'riga','0.00'),(2,'riga','0.00'),(3,'riga','0.00'),(4,'riga','0.00'),(5,'riga','0.00'),(6,'riga','0.00'),(7,'riga','0.00'); /*!40000 ALTER TABLE `table1` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET time_zo...@old_time_zone */; /*!40101 SET sql_mo...@old_sql_mode */; /*!40014 SET foreign_key_chec...@old_foreign_key_checks */; /*!40014 SET unique_chec...@old_unique_checks */; /*!40101 SET character_set_clie...@old_character_set_client */; /*!40101 SET character_set_resul...@old_character_set_results */; /*!40101 SET collation_connecti...@old_collation_connection */; /*!40111 SET sql_not...@old_sql_notes */; -- Dump completed on 2008-12-22 19:46:40
------------------------------------------------------------------------------
_______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user