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

[Benoit Minisini]

On vendredi 25 janvier 2008, Nx GT-R BOY wrote:
> 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), 

You don't have to add this component, it is not related to database. It is 
only used by the IDE for talking with the internal debugger of a running 
Gambas program.

> 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

It seems that this sql statement is incorrect. There should be something 
between SELECT and FROM, shouldn't it?

>
> 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

Did you add a primary key to your table? This is mandatory in most part of the 
Gambas database things.

As for the 'LIMIT 64': The Data* controls do not get the full result of the 
SQL requests it sends to the database driver, but only a small part (64) at 
once. This way, you can put Internet between your application and your 
database, and things are yet usable!

Regards,

-- 
Benoit Minisini