[Gambas-user] Rex2: fields limit? (console outputs)

[Nx GT-R BOY]

Ok, wont happen the upper case issue

My db server is MySQL 5.0.38

By the way, in Mexico (at least) in a business environment, theres no 53
week-year, because you cant have 371 days (53x7), if you start a week at
2008 but ends at 2009, that would be a 2009-week, since they are going to
pay you at 2009, its like 52-paycheck-days.

After adding the gb.debug component (I didn't have it enable), I was able to
do what you said, this are the outputs:

   1.

   First, with a "fresh" database, everything goes perfect, the form
   opens and I cant write my values (and they are ok, since I check my database
   from console), but my program "crash"

Output #1 (with a cleared console):

mysql: 0x81488f8: show columns from `asistencia` like 'empleados_numero'

mysql: 0x81488f8: show columns from `asistencia` like 'semana1'

mysql: 0x81488f8: show columns from `asistencia` like 'semana2'

mysql: 0x81488f8: show columns from `asistencia` like 'semana3'

mysql: 0x81488f8: show columns from `asistencia` like 'semana4'

mysql: 0x81488f8: show columns from `asistencia` like 'semana5'

mysql: 0x81488f8: show columns from `asistencia` like 'semana6'

mysql: 0x81488f8: show columns from `asistencia` like 'semana7'

mysql: 0x81488f8: show columns from `asistencia` like 'semana8'

mysql: 0x81488f8: show columns from `asistencia` like 'semana9'

mysql: 0x81488f8: show columns from `asistencia` like 'semana10'

mysql: 0x81488f8: show columns from `asistencia` like 'semana11'

mysql: 0x81488f8: show columns from `asistencia` like 'semana12'

mysql: 0x81488f8: show columns from `asistencia` like 'semana13'

mysql: 0x81488f8: show columns from `asistencia` like 'semana14'

mysql: 0x81488f8: show columns from `asistencia` like 'semana15'

mysql: 0x81488f8: show columns from `asistencia` like 'semana16'

mysql: 0x81488f8: show columns from `asistencia` like 'semana17'

mysql: 0x81488f8: show columns from `asistencia` like 'semana18'

mysql: 0x81488f8: show columns from `asistencia` like 'semana19'

mysql: 0x81488f8: show columns from `asistencia` like 'semana20'

mysql: 0x81488f8: show columns from `asistencia` like 'semana21'

mysql: 0x81488f8: show columns from `asistencia` like 'semana22'

mysql: 0x81488f8: show columns from `asistencia` like 'semana23'

mysql: 0x81488f8: show columns from `asistencia` like 'semana24'

mysql: 0x81488f8: show columns from `asistencia` like 'semana25'

mysql: 0x81488f8: show columns from `asistencia` like 'semana26'

mysql: 0x81488f8: show columns from `asistencia` like 'semana27'

mysql: 0x81488f8: show columns from `asistencia` like 'semana28'

mysql: 0x81488f8: show columns from `asistencia` like 'semana29'

mysql: 0x81488f8: show columns from `asistencia` like 'semana30'

mysql: 0x81488f8: show columns from `asistencia` like 'semana31'

mysql: 0x81488f8: show columns from `asistencia` like 'semana32'

mysql: 0x81488f8: show columns from `asistencia` like 'semana33'

mysql: 0x81488f8: show columns from `asistencia` like 'semana34'

mysql: 0x81488f8: show columns from `asistencia` like 'semana35'

mysql: 0x81488f8: show columns from `asistencia` like 'semana36'

mysql: 0x81488f8: show columns from `asistencia` like 'semana37'

mysql: 0x81488f8: show columns from `asistencia` like 'semana38'

mysql: 0x81488f8: show columns from `asistencia` like 'semana39'

mysql: 0x81488f8: show columns from `asistencia` like 'semana40'

mysql: 0x81488f8: show columns from `asistencia` like 'semana41'

mysql: 0x81488f8: show columns from `asistencia` like 'semana42'

mysql: 0x81488f8: show columns from `asistencia` like 'semana43'

mysql: 0x81488f8: show columns from `asistencia` like 'semana44'

mysql: 0x81488f8: show columns from `asistencia` like 'semana45'

mysql: 0x81488f8: show columns from `asistencia` like 'semana46'

mysql: 0x81488f8: show columns from `asistencia` like 'semana47'

mysql: 0x81488f8: show columns from `asistencia` like 'semana48'

mysql: 0x81488f8: show columns from `asistencia` like 'semana49'

mysql: 0x81488f8: show columns from `asistencia` like 'semana50'

mysql: 0x81488f8: show columns from `asistencia` like 'semana51'

mysql: 0x81488f8: show columns from `asistencia` like 'semana52'

mysql: 0x81488f8: show columns from `asistencia` like 'periodo'

mysql: 0x81488f8: INSERT INTO `asistencia` ( `empleados_numero`, `periodo` )
VALUES ( 1, 2008 )

mysql: 0x81488f8: SELECT COUNT(*) AS nRecord FROM asistencia

mysql: 0x81488f8: SELECT FROM asistencia LIMIT 64

mysql: 0x81488f8: SELECT FROM asistencia LIMIT 64

   1.

   After step #1, now the form wont work (it opens, give me the LIMIT 64
   error, and close), the console (after a clean up) output is this:

Output #2:

mysql: 0x8148920: SELECT FROM asistencia LIMIT 64

So, It looks like the form keeps doing the "SELECT FROM asistencia LIMIT 64"
statement Ntimes, since the first time did it twice then only do that.....


 Thanks a lot

Nx GT-R

-- 
http://www.cardomain.com/ride/645756
http://nxgtrturbo.googlepages.com/
http://www.fotolog.com/nxgtrturbo/
http://tallerhuertas.googlepages.com/