[Gambas-user] Signal error #11

[Leonardo Miliani]

Leonardo Miliani ha scritto:
> As I posted some threads ago, I still continue to receive a signal error
> #11 when I run my project.
> 
> Run it, enter the password "password" (very easy, isn't it? :-)), and
> then click on the first big icon on left (or choose
> "Moduli/Anagrafica/Gestione clienti"). Then, click on the "new" icon.
> A little window will compare, where you can choose the type of
> customer (i.e., choose "Mensile" and then click OK). After that, click
> on the "save" icon in the new panel and you'll get the error.
> 
> It seems that there are problems in the edit section but I cannot find
> them...
> The table "codici" (this is the real name of my table) contains only 2
> integer fields.
> 
> (P.S.:
> the project lacks some graphics but I think this archive
> should contain all the necessary stuff to run it).
> 
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user

I've found a solution.
I've converted the field types of "codici" table from INTEGER to CHAR
and setting a primary key.
So, the table changed from SQL
create table codici ("mensili" integer, "passanti" integer)
to
create table codici ("tipo" CHAR(50) NOT NULL, "valore" CHAR(10),PRIMARY
KEY ("tipo"))

The first declaration didn't work, generating that error. More over, I
found that without a referring field, Gambas didn't work properly.
I mean that create a simple table with 1 row and 2 columns (2 fields), I
didn't find no way to tell Gambas to direct the edit/update operations
to that unique row. Maybe this was what generated the signal #11.
Maybe...

-- 
Ciao.
Leo.

Web: www.leonardomiliani.com
E-mail: leonardo at ...1237...
Scegli software opensource - Choose opensource software