date:20170915

Re: Listbox column width and pointers

2017-09-15 Thread Jeremy French via 4D_Tech

It's better to use an object name in place of a pointer. That's because a 
pointer could reference more than one object on the form. Object names are 
unique and so reference only a single object.

Here are a couple of things you might try.

Try #1
=

For calculating the column widths, replace pointers with object names:

So this calculation with pointers:

OBJECT GET BEST SIZE($Column_pa{$i}->;$Width_best1_l;$Height_best_l)
OBJECT GET BEST SIZE($Header_pa{$i}->;$Width_best2_l;$Height_best_l)

become a calculation with object names:

OBJECT GET BEST SIZE(*;$Column_ta{$i}->;$Width_best1_l;$Height_best_l)
OBJECT GET BEST SIZE(*;$Header_ta{$i}->;$Width_best2_l;$Height_best_l)

Try #2
=

Also, these 4-lines:

LISTBOX SET COLUMN WIDTH($Column_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH($Header_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Header_ta{$i};$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)

can become a single line:

LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)

Try #3
=

Set the listbox column widths **after** you make SLQ SELECT calls.

See "Displaying the result of an SQL query in a list box” at:
http://doc.4d.com/4Dv16R3/4D/16-R3/Managing-List-Box-Objects.300-3218275.en.html#429187
 


Note the line which reads, "Each new execution of a SELECT query with the list 
box leads to the resetting of the columns…"


> On Sep 15, 2017, at 6:37 PM, bernard--- via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi all,
> 
> I have a form with two listboxes.
> I wrote some code to manage automatic column width (OBJECT GET BEST SIZE, 
> LISTBOX SET COLUMN WIDTH).
> 
> I build listbox1 with records from Table1 (fill by SQL) ; code for automatic 
> width is executed for LB1.
> When I click on a row of LB1, I fill listbox2 with records from TableN 
> (always by SQL) ; code for automatic width is executed for LB2.
> 
> Why LB1 is redrawn with default width* ?
> 
> * I don't understand column width given by 4D : neither leader with, neither 
> data width...
> 
> I did a new test with automatic width for the two LB : same issue.
> 
> Here is the code (simplified) :
> LISTBOX GET 
> ARRAYS(Listbox1;$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)
> 
> For($i;1;Size of array($Column_pa))
> OBJECT GET BEST SIZE($Column_pa{$i}->;$Width_best1_l;$Height_best_l)
> OBJECT GET BEST SIZE($Header_pa{$i}->;$Width_best2_l;$Height_best_l)
> $Width_best_l:=MTH_Maximum($Width_best1_l;$Width_best2_l)+10
> LISTBOX SET COLUMN WIDTH($Column_pa{$i}->;$Width_best_l)
> LISTBOX SET COLUMN WIDTH($Header_pa{$i}->;$Width_best_l)
> LISTBOX SET COLUMN WIDTH(*;$Header_ta{$i};$Width_best_l)
> LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)
> End for
> 
> LISTBOX GET 
> ARRAYS(Listbox2;$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)
> 
> For($i;1;Size of array($Column_pa))
> OBJECT GET BEST SIZE($Column_pa{$i}->;$Width_best1_l;$Height_best_l)
> OBJECT GET BEST SIZE($Header_pa{$i}->;$Width_best2_l;$Height_best_l)
> $Width_best_l:=MTH_Maximum($Width_best1_l;$Width_best2_l)+10
> LISTBOX SET COLUMN WIDTH($Column_pa{$i}->;$Width_best_l)
> LISTBOX SET COLUMN WIDTH($Header_pa{$i}->;$Width_best_l)
> LISTBOX SET COLUMN WIDTH(*;$Header_ta{$i};$Width_best_l)
> LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)
> End for
> 
> I tried also : 
> 
> $Listbox_t:="Listbox1"
> LISTBOX GET 
> ARRAYS(*;"$Listbox_t";$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)
> 
> Same behavior.
> 
> I see that the second LB takes column width from first LB
> A track : pointer is form.3C.4357.
> I suppose 3C is object ID ; pointers on objects of LB1 and LB2 have same ID...
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Listbox column width and pointers

2017-09-15 Thread bernard--- via 4D_Tech

Hi all,

I have a form with two listboxes.
I wrote some code to manage automatic column width (OBJECT GET BEST SIZE, 
LISTBOX SET COLUMN WIDTH).

I build listbox1 with records from Table1 (fill by SQL) ; code for automatic 
width is executed for LB1.
When I click on a row of LB1, I fill listbox2 with records from TableN (always 
by SQL) ; code for automatic width is executed for LB2.

Why LB1 is redrawn with default width* ?

* I don't understand column width given by 4D : neither leader with, neither 
data width...

I did a new test with automatic width for the two LB : same issue.

Here is the code (simplified) :
LISTBOX GET 
ARRAYS(Listbox1;$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)

For($i;1;Size of array($Column_pa))
OBJECT GET BEST SIZE($Column_pa{$i}->;$Width_best1_l;$Height_best_l)
OBJECT GET BEST SIZE($Header_pa{$i}->;$Width_best2_l;$Height_best_l)
$Width_best_l:=MTH_Maximum($Width_best1_l;$Width_best2_l)+10
LISTBOX SET COLUMN WIDTH($Column_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH($Header_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Header_ta{$i};$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)
End for

LISTBOX GET 
ARRAYS(Listbox2;$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)

For($i;1;Size of array($Column_pa))
OBJECT GET BEST SIZE($Column_pa{$i}->;$Width_best1_l;$Height_best_l)
OBJECT GET BEST SIZE($Header_pa{$i}->;$Width_best2_l;$Height_best_l)
$Width_best_l:=MTH_Maximum($Width_best1_l;$Width_best2_l)+10
LISTBOX SET COLUMN WIDTH($Column_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH($Header_pa{$i}->;$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Header_ta{$i};$Width_best_l)
LISTBOX SET COLUMN WIDTH(*;$Column_ta{$i};$Width_best_l)
End for

I tried also : 

$Listbox_t:="Listbox1"
LISTBOX GET 
ARRAYS(*;"$Listbox_t";$Column_ta;$Header_ta;$Column_pa;$Header_pa;$Col_visible_ba;$Style_pa)

Same behavior.

I see that the second LB takes column width from first LB
A track : pointer is form.3C.4357.
I suppose 3C is object ID ; pointers on objects of LB1 and LB2 have same ID...
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Server Process "Frozen"-ish

2017-09-15 Thread Jeffrey Kain via 4D_Tech

This one in particular may take awhile. It took about 16 days for us to see the 
issue for the first time. Who knows when it will happen again? So more people 
watching for this issue should shorten the amount of time needed to get this 
identified.

--
Jeffrey Kain
jeffrey.k...@gmail.com

> On Sep 15, 2017, at 3:07 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Bugs in 4D don’t fix themselves by simply talking about them here. If you are 
> expecting 4D staff to read a post on the iNUG and then run into the next room 
> and say “we have a bug in 4D we need to look at”, I think you are expecting 
> too much. Opening a tech support case for the bug is the first step in 
> getting it worked on and fixed. 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Server Process "Frozen"-ish

2017-09-15 Thread Tim Nevels via 4D_Tech

On Sep 15, 2017, at 2:00 PM, Jeffrey Kain wrote:

> I opened a case on the taow today - just FYI.

I forgot to say that in my last post. I think this is the best way to handle 
this bug. If they have a half dozen cases opened all with the same problem, 
that should make them take notice.

So anybody else seeing this frozen Stored Procedure problem in v16, do what 
Jeff did and go open a support case for it.

Bugs in 4D don’t fix themselves by simply talking about them here. If you are 
expecting 4D staff to read a post on the iNUG and then run into the next room 
and say “we have a bug in 4D we need to look at”, I think you are expecting too 
much. Opening a tech support case for the bug is the first step in getting it 
worked on and fixed. 

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Scheduler App request

2017-09-15 Thread Wendell Turner via 4D_Tech

Hi Robert.

I have built 4D based scheduling systems for employee rostering firms, printing 
manufacturing firms, wholesale manufacturing firms. I might be able to help 
this organisation. I haven’t looked at Lightspeed but if it can take cvs inputs 
at the minimum, then I could work with it.

They can use my signature infor below to reach me, or at wend...@crodata.co.uk 
 (my (unfinished) website is www.crodata.co 
.uk).

Wendell Turner

p:= +44(0)7403 524010
e: wendel...@gmail.com
"There is a profound difference between doing things right and doing the right 
things."



> On 15 Sep 2017, at 17:02, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I saw the following from an Apple Reseller.  Does anyone have a solution? I 
> can forward the info to him.
> 
> We have 8-10 trucks on the road every day performing deliveries, 
> installations, service calls, etc. For 30 years we have used old fashion pen 
> and paper to create a schedule but our scheduling manager is getting 
> overwhelmed with the amount of work it is taking.We are looking for a 
> scheduling program, I think more advanced than iCal, that could potentially 
> work with Lightspeed. Any suggestions?
> 
> Keith - CDI
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Scheduler App request

2017-09-15 Thread Kenneth Geiger via 4D_Tech

LightSpeed is a POS System.

> On Sep 15, 2017, at 10:44 AM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> " We are looking for a scheduling program, I think more advanced than iCal, 
>> that could potentially work with Lightspeed "
> 
> Maybe I am overthinking this but, if the potential to work with Lightspeed is 
> part of the requirement, it may be helpful to know what Lightspeed is. What 
> is Lightspeed?
> 
> -Tim PENNER
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Scheduler App request

2017-09-15 Thread Timothy Penner via 4D_Tech

> " We are looking for a scheduling program, I think more advanced than iCal, 
> that could potentially work with Lightspeed "

Maybe I am overthinking this but, if the potential to work with Lightspeed is 
part of the requirement, it may be helpful to know what Lightspeed is. What is 
Lightspeed?

-Tim PENNER



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Scheduler App request

2017-09-15 Thread Keith Culotta via 4D_Tech

I saw the following from an Apple Reseller.  Does anyone have a solution? I can 
forward the info to him.

We have 8-10 trucks on the road every day performing deliveries, installations, 
service calls, etc. For 30 years we have used old fashion pen and paper to 
create a schedule but our scheduling manager is getting overwhelmed with the 
amount of work it is taking.We are looking for a scheduling program, I think 
more advanced than iCal, that could potentially work with Lightspeed. Any 
suggestions?

Keith - CDI
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Write Pro - WP EXPORT DOCUMENT to WORD?

2017-09-15 Thread Jim Labos - infobase via 4D_Tech

Trying out 4D Write Pro with v16 R4 beta for possible use in an upcoming
project.

It's the "Bookmark" feature that got me curious as without it we would not
be able to fulfill our requirement.
I will need to "construct" a 4D Write document from "Bookmarks". If this
works well then we need to export or save the 4D Write document in Word.

The current version of 4D Write can export as a Word file, however I do not
see any option for doing it in 4D Write Pro.

Anyone have any idea if this is coming soon or if the option exists, where I
can find it?

Thanks

Jim Labos - infobase



-
Jim Labos - infobase
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Listbox column width and pointers

Listbox column width and pointers

Re: Server Process "Frozen"-ish

Re: Server Process "Frozen"-ish

Re: Scheduler App request

Re: Scheduler App request

RE: Scheduler App request

Scheduler App request

4D Write Pro - WP EXPORT DOCUMENT to WORD?

9 matches

Site Navigation

Mail list logo

Footer information