Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #2013 > unrolled thread

Columns in bBrowser move together

Started byLu <lu2k@hotmail.com>
First post2011-09-15 03:23 -0700
Last post2011-09-19 07:26 +0200
Articles 8 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Columns in bBrowser move together Lu <lu2k@hotmail.com> - 2011-09-15 03:23 -0700
    Re: Columns in bBrowser move together "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-09-15 21:26 +1000
      Re: Columns in bBrowser move together Lu <lu2k@hotmail.com> - 2011-09-15 06:45 -0700
        Re: Columns in bBrowser move together "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-09-16 00:36 +1000
    Re: Columns in bBrowser move together Joachim Bieler <support@votools.com> - 2011-09-16 07:25 +0200
      Re: Columns in bBrowser move together Lu <lu2k@hotmail.com> - 2011-09-16 01:48 -0700
      Re: Columns in bBrowser move together "richard.townsendrose" <richard.townsendrose@gmail.com> - 2011-09-16 01:49 -0700
        Re: Columns in bBrowser move together Joachim Bieler <support@votools.com> - 2011-09-19 07:26 +0200

#2013 — Columns in bBrowser move together

FromLu <lu2k@hotmail.com>
Date2011-09-15 03:23 -0700
SubjectColumns in bBrowser move together
Message-ID<e3b31b1a-49e0-40d1-ba59-ce686758c10e@k29g2000yqf.googlegroups.com>
Hi VO experts!

When I click on a minimized window on the taskbar the columns in the
bBrowser moved together that it is impossible to read the content. The
distance between the columns is only some millimeters. When I resize
the window or when i push the refresh button the columns are shown
correct. There are used 5 bbrowsers in this window. Each time I open
the minimized window, the columns at 2 bbrowsers are moved together,
the columns of the other 3 bbrowsers only shrink sometimes (they are
in a Tab Control).
They are filled with a bArrayServer.

I think this problem occurs since we upgrade to VO2.8 SP3 and bBrowser
3.
Has anybody the same problem?  How can I solve this?

Thanks in advance for your help.

Lu

[toc] | [next] | [standalone]


#2018

From"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au>
Date2011-09-15 21:26 +1000
Message-ID<Zilcq.2462$7r4.742@viwinnwfe02.internal.bigpond.com>
In reply to#2013
Lu

Try assigning a size to each column, usually it won't shrink past that.
or
Assign a FieldSpec{} to each column, using an ArrayServer they aren't 
automatically created like they are when using DBF as the source

CYA
Steve 

[toc] | [prev] | [next] | [standalone]


#2020

FromLu <lu2k@hotmail.com>
Date2011-09-15 06:45 -0700
Message-ID<ed942e57-a865-4052-bef8-fbe4878e687d@dq7g2000vbb.googlegroups.com>
In reply to#2018
Hi Steve!

Thank you for your quick reply. At the bottom you see the method where
the bbrowser is filled. Each column has a size but if I open the
minimized window the columns shrink. This window is quite old so do
not be scared if you see the code :-).

When I tried the window with VO2.7 the columns do not shrink.

METHOD ShowData() CLASS dtaGVData
	LOCAL oError as USUAL
	LOCAL oldErrorBlock as CODEBLOCK
	LOCAL columns			as ARRAY
	LOCAL columnFormats		as ARRAY
	LOCAL format			as bNameArray
	LOCAL db				as sqlGVZugDB
	LOCAL stmt				as STRING
	LOCAL currentRecNo 		as int
	LOCAL aoColumn			as ARRAY
	LOCAL ocvCaption		as bCompoundValue
	LOCAL oFont				as Font
	LOCAL iPos, iSize		as DWORD
	LOCAL auStruct 			as ARRAY
	LOCAL oaServer 			as bArrayServer
	LOCAL oRs 				as AdoRecordset
	LOCAL lDatenVorhanden	as LOGIC

	self:Pointer := Pointer{ POINTERHOURGLASS }

	currentRecNo := self:oDCbBrowserVerz:currentRecNo

	auStruct := {;
			{"Zugnummer", "N", 6, 0},;
			{"vonBsStelle_ID", "N", 20, 0},;
			{"vonBst", "C", 7, 0},;
			{"bisBsStelle_ID", "N", 20, 0},;
			{"bisBst", "C", 7, 0},;
			{"Abfahrt", "C", 5, 0},;
			{"Zugkennung", "C", 25, 0},;
			{"ZugDBVerz_ID", "N", 20, 0},;
			{"FplPeriode_ID", "N", 10, 0},;
			{"ZugBezeichnung", "C", 20, 0};
				}

	columns := {#Zugnummer, #vonBst, #bisBst, #Abfahrt, #Zugkennung}

	columnFormats := {}

	format := bNameArray{}
	format:Add(#Alignment, BALIGN_LEFT)
	format:Add(#Caption, "Zugkennung")
	format:Add(#Width, 90)
	AAdd(columnFormats, { #Zugkennung, format })

	format := bNameArray{}
	format:Add(#Alignment, BALIGN_LEFT)
	format:Add(#Caption, "von")
	format:Add(#Width, 40)
	AAdd(columnFormats, { #vonBst, format })

	format := bNameArray{}
	format:Add(#Alignment, BALIGN_LEFT)
	format:Add(#Caption, "bis")
	format:Add(#Width, 40)
	AAdd(columnFormats, { #bisBst, format })

	format := bNameArray{}
	format:Add(#Alignment, BALIGN_LEFT)
	format:Add(#Caption, "Abfahrt")
	format:Add(#Width, 35)
	AAdd(columnFormats, { #Abfahrt, format })

	format := bNameArray{}
	format:Add(#Alignment, BALIGN_LEFT)
	format:Add(#Caption, "Zugkennung")
	format:Add(#Width, 90)
	AAdd(columnFormats, { #Zugkennung, format })

	oldErrorBlock := ErrorBlock({|err|_Break(err)})
	BEGIN SEQUENCE

		stmt := "exec spGvVerz "
		stmt := stmt + "'" + DToS(self:oDCtagVonDatePicker:SelectedDate) +
"', "
		stmt := stmt + self:_bereichAus1 + ", "
		stmt := stmt + self:_bereichIn1

		db := sqlGVZugDB{stmt}

	  IF db:RecordSet:RecordCount > 0
		  self:oDCbBrowserVerz:SuspendNotification()
		  lDatenVorhanden := true


		  //bei der Überprüfung ob neue Daten vorhanden sind wird Browser
nicht neu geladen
		  IF self:_TimerAktiv
		    oRS := db:RecordSet:NextRecordset(nil)
		    self:_neueDatenAnz := oRs:FIELDGET(#neu)

		    self:oDCbBrowserVerz:ResetNotification()
		    self:Pointer := Pointer{ POINTERARROW }
		    db:Close()
		    RETURN
	           ENDIF

		oaServer := bArrayServer{db:DBStruct, db:RecordSet:getRows(),
BINACTIVE, BDATAFORMAT_DBASE}
		db:Close()

		self:oDCbBrowserVerz:Use(oaServer,, columns, columnFormats)

		// create font "Marlett"
		// -> the font is used in the bCompoundValue's
		oFont := Font{, -9, "Marlett"}

		// initialize all column captions
		aoColumn := self:oDCbBrowserVerz:ColumnList
		iSize := ALen(aoColumn)
		FOR iPos:=1 upto iSize
		   ocvCaption := bCompoundValue{}

		  // fieldname on the left side, sort direction on the right side
		  ocvCaption:AddValue(bCompoundValue{aoColumn[iPos]:Caption,
Point{0, 0}, Dimension{aoColumn[iPos]:Width - 15, -1}})
		  ocvCaption:AddValue(bCompoundValue{"", Point{aoColumn[iPos]:Width
- 20, -1}, Dimension{13, -1},,,, oFont})

	   	  aoColumn[iPos]:Caption := ocvCaption
	         NEXT
		IF !IsNil(self:Layout)
		  self:Layout:reInitializeBrowser(self:oDCbBrowserVerz)
		ENDIF

		self:oDCbBrowserVerz:ResetNotification()
		// keine Daten vorhanden
	  ELSE
		IF !self:_TimerAktiv
		  oaServer := bArrayServer{auStruct, {}, BINACTIVE,
BDATAFORMAT_DBASE}
		  self:oDCbBrowserVerz:Use(oaServer,, columns, columnFormats)
		ENDIF
	  ENDIF

	  IF lDatenVorhanden
	     bBrowserSelectRow(self:oDCbBrowserVerz, currentRecNo, true)
	  ENDIF

	  self:oDCbBrowserVerz:Refresh()
	  self:oDCbBrowserVerz:Redraw()

	RECOVER USING oError
	      ErrorBox{nil, AsString(oError:Description)}:Show()
	END SEQUENCE
	ErrorBlock(oldErrorBlock)


	self:oDCbBrowserVerz:Refresh()

	//Timer zurücksetzen
	self:cTimer('Reset')

	//Datum der letzten Aktualisierung speichern (wegen Timer)
	self:_cletzteAkt := DToS(Today())+ ' ' +Time()

	self:Pointer := Pointer{ POINTERARROW }

        RETURN nil

[toc] | [prev] | [next] | [standalone]


#2021

From"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au>
Date2011-09-16 00:36 +1000
Message-ID<z2ocq.2450$NR2.817@viwinnwfe01.internal.bigpond.com>
In reply to#2020
Lu

> format:Add(#Width, 40)
Do you know if this is interpreted as 40 pixels or 40 characters??
If you assign a FieldSpec{} of 40 you'll get character width (eg 8*40 
pixels).

I'm very sure that 20 characters won't fit in a column 90 pixels wide.
I think I used something like 88 for dates (eg 31/12/2010) which are 10 
characters.

CYA
Steve 

[toc] | [prev] | [next] | [standalone]


#2024

FromJoachim Bieler <support@votools.com>
Date2011-09-16 07:25 +0200
Message-ID<9dg4t6F4baU1@mid.individual.net>
In reply to#2013
Hi Lu,

the bBrowser does not automatically change the width of the columns if the window is minimized. If 
it does this, then it must have been activate from someone to do this. Perhaps an event or something 
else. Does the problem occur also with the sample applications which are contained in the bBrowser 
library? Which Windows version do you use (Windows XP, Vista, Windows 7, ...)?

Please send me a test application (aef file) with that I can reproduce the problem.

Regards,
Joachim Bieler



Am 15.09.2011 12:23, schrieb Lu:
> Hi VO experts!
>
> When I click on a minimized window on the taskbar the columns in the
> bBrowser moved together that it is impossible to read the content. The
> distance between the columns is only some millimeters. When I resize
> the window or when i push the refresh button the columns are shown
> correct. There are used 5 bbrowsers in this window. Each time I open
> the minimized window, the columns at 2 bbrowsers are moved together,
> the columns of the other 3 bbrowsers only shrink sometimes (they are
> in a Tab Control).
> They are filled with a bArrayServer.
>
> I think this problem occurs since we upgrade to VO2.8 SP3 and bBrowser
> 3.
> Has anybody the same problem?  How can I solve this?
>
> Thanks in advance for your help.
>
> Lu

[toc] | [prev] | [next] | [standalone]


#2026

FromLu <lu2k@hotmail.com>
Date2011-09-16 01:48 -0700
Message-ID<7200f94d-a3a7-43b6-91df-befad86f1232@s3g2000vbx.googlegroups.com>
In reply to#2024
Hi!

Thank you for your answers.

Stephen:
I think it is interpreted as pixel. You are right Stephen, the last
column (with 20 characters) do not fit in the column, but the user do
not often need it and they can change the column width if they want at
this bBrowser.

Joachim:
I tried some sample applications but the problem does not occur there.
I also changed the window that its possible to drag it outside the
application, but columns width don't change there. I would like to
send you a test application but it is a big window with many tab
controls and they all need a MS sqlserver for the procedures.

The application runs on Windows 7.

[toc] | [prev] | [next] | [standalone]


#2027

From"richard.townsendrose" <richard.townsendrose@gmail.com>
Date2011-09-16 01:49 -0700
Message-ID<dff54960-4621-4786-b13f-3c185335b502@i2g2000yqm.googlegroups.com>
In reply to#2024
Joachim

any news on bb4 and vo sp4 ?

richard

[toc] | [prev] | [next] | [standalone]


#2038

FromJoachim Bieler <support@votools.com>
Date2011-09-19 07:26 +0200
Message-ID<9do22pFhakU1@mid.individual.net>
In reply to#2027
Richard,

the bBrowser 4 makes progress. Slowly but it goes forward. If you like, then you can take part in 
the beta test. It is prerequisite that you buy a licence of the bBrowser 4 as soon as it is published.

Regards,
Joachim Bieler



Am 16.09.2011 10:49, schrieb richard.townsendrose:
> Joachim
>
> any news on bb4 and vo sp4 ?
>
> richard

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web