gb 2.17 Debian sid
qt
SQL requests are written, not using intrinsic
postgresql 8.4.1
table test(
id serial primary key,
label varchar(8) not null,
date_cre timestamp default now(),
date_mod timestamp default NULL,
mri_users_cre integer default 1,
mri_users_mod integer default NULL,
front boolean default true
);
==========================================
Hi,
Former state:
rows 1-7 have values,
rows 8-10 have been deleted
DataBrowser have all table fields but only display: label & front =>
WITH datbro_Civ.GridView
' La colonne 'id' est là pour retourner une réf, pas pour être vue
.Columns[0].Width = 0
.Columns[0].Resizable = FALSE
.Columns[1].Text = "Civilités"
.Columns[1].Width = 175
.Columns[1].Resizable = FALSE
' Y'a ptêt une autre manière pour avoir accès à ces champs
' que de les cacher, mais je ne sais pas comment (?)
.Columns[2].Width = 0
.Columns[2].Resizable = FALSE
.Columns[3].Width = 0
.Columns[3].Resizable = FALSE
.Columns[4].Width = 0
.Columns[4].Resizable = FALSE
.Columns[5].Width = 0
.Columns[5].Resizable = FALSE
' La dernière colonne est tjrs visible même à largeur 0 :( (bug? => oui)
' donc comme on en a que 2 à afficher sur 6, il faut que la 2nde soit la
dernière (évangile selon St-Gridview)
' ET ne pas oublier de changer l'ordre des champs dans le DataBrowser
.Columns[6].Text = "Devant ?"
.Columns[6].Width = -1
.Columns[6].Resizable = FALSE
END WITH
INSERT into table => Refresh of DataBrowser shows new row ONLY when
it is ascending sorted on 'label'
(descendant order don't show it AND is totally false - even in an ASCII way!)
Sort by 'front' => New row doesn't appear anymore AND descending order
is totally false (shows: True, False, F..., False, True)
Making the primary key column visible don't change anything.
Well, after a small test, any descending order is *always* false :(
ie ascending:
Co.
GmBH
Inc.
SA
SARL
sarl2
sarl3
SAS
sro
descending:
SARL
SA
sro
GmBH
Inc.
Co.
SAS
sarl2
sarl2
as a matter of fact is seems to be superseded by primary key ascending order.
so it is truly unusable at all.
JY
--
No group of professionals meets except to conspire against the public at large.
-- Mark Twain
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
