Re: How to set the file name of a QR Report to disk file.

[John Baughman via 4D_Tech]

Thanks Doug. What I need is specifically related to using the command QR REPORT 
with a prebuilt .4qr file which exports a selection of records to a text file. 
I am not at all concerned with where the file is being saved, but what the file 
name will be. 

I do not see any way to force QR REPORT to bypass the Save As dialogue, or to 
set the suggested file name to anything other than My Report.txt.

Correct me if I am wrong, but I don’t think what you suggested will work with 
QR REPORT to set the file name or to otherwise use the .4qr file such that I 
can specify the file name.

John

> On Dec 27, 2017, at 3:38 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> John:
> 
> If it's a beefed up save file dialog, ABM Mac Extras Plugin might be of
> some help on OS X. I'd go with Win32API on Windows.
> 
> ABM 1.5.2 is in a system that's running in 12.6. I traded email with
> Matthias in 6/15 about using it in a newer version and he indicated that it
> works in 13. I've used it in preliminary testing in 14.6 and it works OK.
> 
> [time passes]
> 
> Here's something from the wayback machine:
> 
> "Am/On Fri, 23 Nov 2007 08:57:11 -0700 schrieb/wrote Ed Glassgow:
> 
>> I am trying to do something that seems that should be trivial but it
>> doesn't seem to be possible.  I am trying to set a default path for
>> saving a document that I am going prompt the user with something like
>> "$theDoc:=Create document("";"txt").  I would like the "Save As" dialog
>> to open showing the contents of a certain folder.
> 
> you can use our ABM_MacExtras Plugin for the Mac and Win32API for Windows.
> Let me know, if you're interested and I send you the last UB build.
> We will soon post it on our website.
> 
> All the best
> 
> Matthias
> 
> 
> Admilon Consulting GmbH 
> Am Wiesengrund 9a, 90584 Allersberg
> Geschaeftsfuehrer: Peter Frank, Matthias Schmidt
> Amtsgericht Nuernberg: HRB 21750
> Tel.: 09872-31 43 30
> --"
> 
> 
> 
> --
> Douglas von Roeder
> 949-336-2902 <(949)%20336-2902>
> 
> On Wed, Dec 27, 2017 at 4:43 PM, John Baughman via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> I am executing a report with…
>> 
>> QR REPORT([Timesheets];Get 4D folder(Database folder)+"Resources"+Folder
>> separator+"TimeSheetEmployeeExport.4qr”)
>> 
>> This works fine, but I want to dictate or at least offer a preset file
>> name to the end user in the save dialogue. Tried various approaches without
>> any success.
>> 
>> Thanks for any help.
>> 
>> John
>> 
>> 
>> John Baughman
>> Kailua, Hawaii
>> (808) 262-0328
>> john...@hawaii.rr.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
>> **
> **
> 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
> **

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.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: How to set the file name of a QR Report to disk file.

[Douglas von Roeder via 4D_Tech]

John:

If it's a beefed up save file dialog, ABM Mac Extras Plugin might be of
some help on OS X. I'd go with Win32API on Windows.

ABM 1.5.2 is in a system that's running in 12.6. I traded email with
Matthias in 6/15 about using it in a newer version and he indicated that it
works in 13. I've used it in preliminary testing in 14.6 and it works OK.

[time passes]

Here's something from the wayback machine:

"Am/On Fri, 23 Nov 2007 08:57:11 -0700 schrieb/wrote Ed Glassgow:

>I am trying to do something that seems that should be trivial but it
>doesn't seem to be possible.  I am trying to set a default path for
>saving a document that I am going prompt the user with something like
>"$theDoc:=Create document("";"txt").  I would like the "Save As" dialog
>to open showing the contents of a certain folder.

you can use our ABM_MacExtras Plugin for the Mac and Win32API for Windows.
Let me know, if you're interested and I send you the last UB build.
We will soon post it on our website.

All the best

Matthias


Admilon Consulting GmbH 
Am Wiesengrund 9a, 90584 Allersberg
Geschaeftsfuehrer: Peter Frank, Matthias Schmidt
Amtsgericht Nuernberg: HRB 21750
Tel.: 09872-31 43 30
--"



--
Douglas von Roeder
949-336-2902 <(949)%20336-2902>

On Wed, Dec 27, 2017 at 4:43 PM, John Baughman via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I am executing a report with…
>
> QR REPORT([Timesheets];Get 4D folder(Database folder)+"Resources"+Folder
> separator+"TimeSheetEmployeeExport.4qr”)
>
> This works fine, but I want to dictate or at least offer a preset file
> name to the end user in the save dialogue. Tried various approaches without
> any success.
>
> Thanks for any help.
>
> John
>
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **
**
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
**

How to set the file name of a QR Report to disk file.

[John Baughman via 4D_Tech]

I am executing a report with…

QR REPORT([Timesheets];Get 4D folder(Database folder)+"Resources"+Folder 
separator+"TimeSheetEmployeeExport.4qr”)

This works fine, but I want to dictate or at least offer a preset file name to 
the end user in the save dialogue. Tried various approaches without any 
success. 

Thanks for any help.

John


John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.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
**

Anyone Using the Synchronization Code Library from FlatTop Technology, Inc?

[Douglas von Roeder via 4D_Tech]

If anyone is using this code library, please contact me privately.

Thanks.
--
Douglas von Roeder
949-336-2902
**
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: Electronic Signature Pads

[Jim Crate via 4D_Tech]

On Dec 27, 2017, at 6:36 PM, Andrew R Diaz via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> I am looking to integrate a signature pad (like the ones from topaz 
> https://www.topazsystems.com/index.html 
> ) into my 4D application and was 
> wondering if anyone has done this before and if so which system was easiest 
> to integrate into 4D.

I integrated the ScripTouch signature pad from ScripTel (https://scriptel.com) 
into a 4D application. I didn’t bother with live signature preview in 4D, but 
instead just integrated with the java app they supply. For 4D integration I 
launched the java app with parameters detailing what kind of signature image to 
save using LAUNCH EXTERNAL PROCESS, and picked up the image afterward.  

The ScripTel also integrates with Adobe Reader for cryptographically signing 
PDF documents, if that’s necessary. I used 4D to create a PDF, launch Adobe 
Reader with that PDF, monitor the file for an appropriate number of changes 
(depending on how many signatures I needed), and email the signed PDF to the 
appropriate recipients.

The signature pads have turned out to be relatively fragile in a traveling 
salesman environment. They are also extremely sensitive to USB power. I never 
used the Topaz signature pads so I’m not sure how they or the software compare.

Jim Crate

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

Electronic Signature Pads

[Andrew R Diaz via 4D_Tech]

Hi,

I am looking to integrate a signature pad (like the ones from topaz 
https://www.topazsystems.com/index.html 
) into my 4D application and was 
wondering if anyone has done this before and if so which system was easiest to 
integrate into 4D.

TIA,

Andrew

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

character count in 4d Write

[Charles Miller via 4D_Tech]

Hi all,

Environment 4D 15.5 client server. On Mac client

I have been using

*WR SET SELECTION *($mainarea;*WR Count *($mainarea;wr nb characters);*WR
Count *($mainarea;wr nb characters))
I find the number returned is not really at the end, as whem I append
another 4D write area. gthe last 2 or 3 characters appear ater the append

When I change the command to

$MyNumber_L:=*WR Count *($mainarea;wr nb characters)*2

*WR SET SELECTION *($mainarea;$MyNumber_L;$MyNumber_L)

I get the desired result. How dopes 4D do the count? I know that there are
some illegal characters. (Bullets) but there are many more than the 3 or 4
characters skipped.

Hopefully this may save someone else time as it took a few hours to finally
track down.

Thanks and regards,

Chuck
-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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 HyperThreading

[Paul Lovejoy via 4D_Tech]

Hi Jeff,

We have 4D server 15.4 running on Apple hardware, 8 cores - 16 with 
hyperthreading. From what I can see in Activity Monitor, only half of the cores 
get used, which makes me suspect the virtual cores are not being used. This is 
v15 and 32 bit. Maybe v16 and/or 64 bit changes that.

Cheers,


Paul


> Le 27 déc. 2017 à 16:06, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Is there any conventional wisdom out there (or better yet some 4D Server 
> benchmark) regarding whether HyperThreaded cores help or hurt 4D Server 
> performance?
> 
> Thanks!
> Jeff
> **
> 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: List Box Header background color programatically.

[John Baughman via 4D_Tech]

> On Dec 27, 2017, at 2:11 AM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Having a set of # background rectangles of # colors in Resources folder, in 
> properties list, choose:

That is a good way to do it and you can change the background color by 
switching files with OBJECT SET FORMAT. I think, however, a rectangle object on 
the form with a highlight button is much easier to manage programmatically 
without needing to create a background file when each time I find the need for 
a different color that I don’t already have.

It would be nice if we could set the list box headers to 3D buttons and use 
this trick to change their background colors.

John

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.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: Database locked in merged application

[Chip Scheide via 4D_Tech]

IMHO,
I feel that this is a bad idea.
I have not worked with built applications, so there may not be a away 
to avoid this situation, BUT...
with the datafile inside the app package(Mac) you run the significant 
risk of deleting the datafile during an update.

I always keep the datafile outside the of the database 
structure/package.
Chip 
On Thu, 21 Dec 2017 16:50:34 -0600, Keith Culotta via 4D_Tech wrote:
> Re: So it looks like the data file which is wrapped up inside the 
> application can’t be used
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Server HyperThreading

[Jeffrey Kain via 4D_Tech]

Is there any conventional wisdom out there (or better yet some 4D Server 
benchmark) regarding whether HyperThreaded cores help or hurt 4D Server 
performance?

Thanks!
Jeff
**
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
**

Are All Your Tables Getting Logged?

[Dave Nasralla via 4D_Tech]

Hey All,

I ran into an issue today where I was surprised (understatement) to
see some tables did not show up in my log file. It turns out the
little check box "Include in Log File" on the table definitions was
unchecked. (24 tables out of 229)

For those of you who use custom primary keys, it's an easy mistake to
make. Now-a-days when you create a new table in 4D, 4D automatically
assigns a primary key and turns on logging. The problem is, to change
the primary key format, you need to first drop the existing key which
turns the logging off. Just because you re-add your custom primary
key, the logging is not automatically turned back on - you have to
manually check the box - easy to forget.

When you have 200+ tables in your structure, clicking on each table to
find out where you forgot to turn logging back on is not practical.
Below is code based on an earlier post on the NUG from a thread
between Cannon and Arnaud (thanks to both of you for that). Running it
simply gives you an alert with all the tables that have Journaling
(logging) turned off.

ARRAY BOOLEAN($logged_ab;0)  //>>>this one
ARRAY LONGINT($table_al;0)
ARRAY TEXT($name_at;0)
Begin SQL
SELECT LOGGED, TABLE_NAME, TABLE_ID
FROM _USER_TABLES
INTO :$logged_ab, :$name_at, :$table_al;
End SQL

C_TEXT($NotLogged_vt)
C_LONGINT($x;$Size_vl)
$Size_vl:=Size of array($name_at)
For ($x;1;$Size_vl)
If (Not($logged_ab{$x}))
$NotLogged_vt:=$NotLogged_vt+"\r"+$name_at{$x}
End if

End for

ALERT($NotLogged_vt)

-- 
David Nasralla
Clean Air Engineering
**
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: List Box Header background color programatically.

[Keisuke Miyako via 4D_Tech]

if you, like me, are intrigues by object notation and the new "Form" command,
I've posted an example UI on GitHub, a custom form for backup settings.

https://github.com/miyako/4d-utility-backup-dialog

there is almost no code written for the form,
yet it provides access to all configurable properties.

you can even access from the client (which the default UI does not).

> 2017/12/27 18:20、John Baughman via 4D_Tech <4d_tech@lists.4d.com> のメール：
> BTW, I am finding more and more uses for c_objects and am pleasantly 
> surprised at how well dot notation actually works wherever I try it.




**
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: List Box Header background color programatically.

[Arnaud de Montard via 4D_Tech]

> Le 26 déc. 2017 à 18:19, John Baughman via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> [...]
> I have always hated the inability to change the background color of a button. 
> For form buttons that need a colored background, I use a rounded rectangle or 
> image with a Highlight button on top.

Hi John, 
you don't need to superimpose a button to a picture to do that (I wonder if 
highlight button type is on sunset, BTW, I often hear from 4D people "don't"). 
Having a set of # background rectangles of # colors in Resources folder, in 
properties list, choose:
- object type = 3d button
- button style = custom
Then you have 2 properties named "Background", choose:
- Background source = file
- Background name/ID = [picture posix path]

Structure: 

Runtime: 

Doc (at bottom): 


-- 
Arnaud de Montard 



**
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: List Box Header background color programatically.

[Arnaud de Montard via 4D_Tech]

> Le 26 déc. 2017 à 18:19, John Baughman via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> [...]
> I have always hated the inability to change the background color of a button. 
> For form buttons that need a colored background, I use a rounded rectangle or 
> image with a Highlight button on top.

Hi John, 
you don't need to superimpose a button to a picture to do that (I wonder if 
highlight button type is on sunset, BTW, I often hear from 4D people "don't"). 
Having a set of # background rectangles of # colors in Resources folder, in 
properties list, choose:
- object type = 3d button
- button style = custom
Then you have 2 properties named "Background", choose:
- Background source = file
- Background name/ID = [picture posix path]

Structure: 

Runtime: 

Doc (at bottom): 


-- 
Arnaud de Montard 



**
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: List Box Header background color programatically.

[John Baughman via 4D_Tech]

> On Dec 26, 2017, at 6:24 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I did just discover I can set the help tip for each header object! ​

Very timely Kirk, thanks. I just found a need to implement help tips in a list 
box’s header and remembered your comment. A bit of a challenge as nothing I 
could find tells you that the mouse is over a header button let alone which 
header. Had to test if the mouse coordinates fell inside one of the header's 
coordinates. 

BTW, I am finding more and more uses for c_objects and am pleasantly surprised 
at how well dot notation actually works wherever I try it. As an example below 
is the method I created to display the help tip in a list box with 31 columns 
for days in a month. I was surprised that   
If(myMethod(myObject).booleanParameter)  actually worked.

John


// Method: Timesheets_HeaderHelpTip
C_OBJECT($oHoliday)
C_LONGINT($left;$top;$right;$bottom;$mouseX;$mouseY)

$mouseX:=$1
$mouseY:=$2

For ($i;1;31)
$Header:="Day"+String($i)+"Header"
OBJECT GET COORDINATES(*;$Header;$left;$top;$right;$bottom)

If ($mouseX>$left) & ($mouseX<$right) & ($mousey>$top) & 
($mousey<$bottom)
If (Date_IsHoliday (New 
object("action";"IsAHoliday";"date";vFirstDayOfMonthSelected+($i-1))).isaholiday)
$oHoliday:=Date_IsHoliday (New 
object("action";"IsAHoliday";"date";vFirstDayOfMonthSelected+($i-1)))

SET DATABASE PARAMETER(Tips duration;720)
OBJECT SET HELP 
TIP(albTimesheets;$oHoliday.holiday+"\r"+$oHoliday.holidaytype)

$i:=999

End if 

End if 

If ($i#999)
OBJECT SET HELP TIP(albTimesheets;"")

End if 

End for 


John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.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
**