Hi Benoit,
Please, exec this sentences as a script in mysql server. It creates a table
an a view.
If you make a new connection to this database from the gambas3 IDE. If you
select the view from the list, IDE crash (with no 11 signal)
I'm using ubuntu 10.10 x64 with gambas3 rev 3537
Regards,
2011/2/6 Benoît Minisini <[email protected]>
> > Hi to all,
> >
> > When you got in the IDE a connection to MySQL database, if you click over
> a
> > view (not over a table), IDE crash.
> >
> > Views have been declared in mysql as "create view SomeName as select *
> from
> > SomeTable" and runs ok from mysql command line.
> >
> > I was looking for in gambas3 sources about the crash and the problem
> occurs
> > when Table.Type is read from connection.
> >
> > Regards,
> > Ricardo Díaz
>
> Can you send me a database sql dump with views? I don't need a big one!
>
> Regards,
>
> --
> Benoît Minisini
>
>
> ------------------------------------------------------------------------------
> The modern datacenter depends on network connectivity to access resources
> and provide services. The best practices for maximizing a physical server's
> connectivity to a physical network are well understood - see how these
> rules translate into the virtual world?
> http://p.sf.net/sfu/oracle-sfdevnlfb
> _______________________________________________
> Gambas-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
CREATE DATABASE IF NOT EXISTS DB;
USE DB;
DROP TABLE IF EXISTS `DB`.`TBLMAAlmacenes`;
CREATE TABLE `DB`.`TBLMAAlmacenes` (
`Clave` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`CreadaPor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
`FechaDeCreacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Eliminada` tinyint(1) DEFAULT NULL,
`Delegacion` int(11) DEFAULT NULL,
`Nombre` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
`Descripcion` text COLLATE utf8_spanish_ci,
`Ubicaciones` text COLLATE utf8_spanish_ci,
`Predeterminado` tinyint(1) DEFAULT '0',
`Notas` text COLLATE utf8_spanish_ci,
PRIMARY KEY (`Clave`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `DB`.`TBLMAAlmacenes` VALUES ('OS01CBxs6ToRpQkHPbEjUGcMy9u1GSdLBmTvXxR9x9WO','ADMINISTRADOR','2011-01-26 15:30:13',0,1,'ALMACEN','','ZONA DE PORTATILES;ZONA DE FIJOS',0,''),
('OS01Gn2rIJXhS29iTBq84HQkoCp32uoyYQfhTtiC6qqq','ADMINISTRADOR','2011-01-26 15:30:27',0,1,'TIENDA','','',-1,''),
('OS01gyyZxGNQKVXmc6ax87isaWIZ1TXJtKoRhAaeOG0Q','ADMINISTRADOR','2011-01-29 17:10:07',0,1,'RESERVAS','Se utiliza para mover productos que quedan reservados para clientes',NULL,0,'');
create or replace view HQLMAAlmacenes as select * from TBLMAAlmacenes where Eliminada = '0';
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Gambas-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user
