Date   

Re: Duplicate index in Pervasive

Ulrich Ahrendt
 

Negative values + picture without "N"?

Regards
Ulrich


Re: Duplicate index in Pervasive

Pavel Mencl
 

Good idea but no, the numeric fields are both Signed Integers.
P.


Re: Duplicate index in Pervasive

Rick Lieb
 

Hi Pavel,

I can't tell from the screen shot, but are there any floating point numbers in the index key?  Sometimes there can be variations far to the right of the decimal that don't show up on the screen, I think.

Regards,

Rick Lieb

Hi,
today I've encountered this weird thing,the fields are part of a Unique index but I can see duplicate values. Gets weirder though,when I range on Line=1, I see only one record (the second picture below). I mean, it only makes sense that there is only one such value but is it I see in the first view? When I export the data, there are duplicate values exactly as I see them. Are my eyes deceiving me? Any idea what is happening here?
It's Pervasive 10.30.
Thanks for any idea
Pavel


Duplicate index in Pervasive

Pavel Mencl
 

Hi,
today I've encountered this weird thing,the fields are part of a Unique index but I can see duplicate values. Gets weirder though,when I range on Line=1, I see only one record (the second picture below). I mean, it only makes sense that there is only one such value but is it I see in the first view? When I export the data, there are duplicate values exactly as I see them. Are my eyes deceiving me? Any idea what is happening here?
It's Pervasive 10.30.
Thanks for any idea
Pavel


Re: Transparent PNG in output form

Wes Hein
 

In my case, I set the color of the image to black with white background.  When the image control had a transparent background I got a black background

Wes


Re: xpa 4.7 - combining multiple pdf

Mike McMillin
 

Tom,
Like others we use PDFTK.  We create a Submittal Report that can have hundreds of individual Product Data Sheets, Material Safety Data Sheets and reports generated in Magic.  It has been working for over ten years in 3 version of Magic without any problems.

Mike McMillin


Re: Transparent PNG in output form

Adrian Wick
 

If anyone is interested ...

using xpa default pdf for creating outputs does the job ... but whenever i print on external printer ... the transparancy is gone.

Cheers
A


Invoke OS using HTML5

JK Heydt
 

Xpa application running under TSPlus on a mobile device:

Is there a way to invoke a URL to the mobile client OS using HTML5. I would like to invoke https://www.google.com/maps/search/?api=1&query=[address] and pull up an address on the mobile client end instead of the server. According to TSPlus documentation, OpenOnURL.exe not supported on mobile devices.

I am using the Invoke OS command in my client-server application. When the application is run on a windows machine as HTML5, a new browser tab is opened on the client. But when the same application is run on a mobile device under HTML5, a server browser window opens within the application instead of a new browser tab on the mobile device. 

Is there a way to invoke the URL on the mobile client by preceding it with a different protocol or application like "web https://www.google.com/maps/search/?api=1&query=[address] or web://www.google.com/maps/search/?api=1&query=[address]? 

Thanks


Re: xpa 4.7 - combining multiple pdf

De Netwerkadviseur BV
 

Hi Tom,

You can use PDFTK or QPDF for this.

If you want to do it within XPA, you can use for example Telerik PDF libraries.

Kind regards,
André


Re: TFS Check in

Florian Groothuis
 

I have the same problem since last week. VS2013 and VS2019 are installed and everything worked fine until last week.

Anyone any ideas? 


Re: xpa 4.7 - combining multiple pdf

Olivier Besson
 

Hi Tom,

I use PDFTK too. Very easy command line tool, no installation requested


Olivier


Re: xpa 4.7 - combining multiple pdf

Frederik Soete
 

Hi Tom,

You have understood my meaning. Concatenation does work for postscript files. This way you can even merge portrait and landscape orientations into one pdf, while displaying them as intended (i.e. landscape is not forced to portrait).

Both batch files pdf2ps.bat and ps2pdf.bat should be present in a ghostscript install.

Bye,

Frederik Soete


Op di 21 sep. 2021 21:18 schreef Tom Worthen <tworthen@...>:

Maybe I should have given more information. These are base64 fields that contain pdfs. I can use the BlobFromBase64 and this gives me a blob with the pdf in it. I have proved that by doing a blb2file with that result and I can open the file saved as a pdf. I have attempted to combine the fields and do a BlobFromBase64 on that and the result adobe will not open. I have attempted to use BlobFromBase64 and then use blb2file with the 2 blobs concatenated and adobe also refuses to open that result.

 

Frederik, if I understand what you are suggesting is to use ghostscripts different bat files to change the pdfs into postscript files, then concatenate those and then use their bat file to convert that result back to a pdf? If this what you are suggesting?

 

We have used ghostscript in the past to create pdf’s but I was unaware they had a tool to go the other direction.

 

Are those bat files included with the standard install of ghostscript?

 

Thanks,

Tom

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Frederik Soete
Sent: Tuesday, September 21, 2021 1:39 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] xpa 4.7 - combining multiple pdf

 

Ghostscript ok?

 

If you convert a series of pdf into a series of postscript (ghostscript's pdf2ps.bat), then concatenate the postscript into one single postscript (putting the contents of each file one after another), then convert the end result to pdf (ghostscript's ps2pdf.bat), you should get a pdf containing the original pages.

 

HTH,

 

Frederik Soete

Op di 21 sep. 2021 19:18 schreef Tom Worthen <tworthen@...>:

Is anyone aware of a method to combine multiple pdf’s into 1?

 

I have a situation where we are generating labels as pdf’s but we need to combine multiples into a single pdf.

 

I have attempted tried several different approaches and nothing has worked as of yet.

 

Any ideas would be appreciated.

 

Thanks,

Tom


Re: xpa 4.7 - combining multiple pdf

sherman levine
 

Have you looked at PDFTK or similar command-line tools, for example


Sherm

On 9/21/2021 3:17 PM, Tom Worthen wrote:

Maybe I should have given more information. These are base64 fields that contain pdfs. I can use the BlobFromBase64 and this gives me a blob with the pdf in it. I have proved that by doing a blb2file with that result and I can open the file saved as a pdf. I have attempted to combine the fields and do a BlobFromBase64 on that and the result adobe will not open. I have attempted to use BlobFromBase64 and then use blb2file with the 2 blobs concatenated and adobe also refuses to open that result.

 

Frederik, if I understand what you are suggesting is to use ghostscripts different bat files to change the pdfs into postscript files, then concatenate those and then use their bat file to convert that result back to a pdf? If this what you are suggesting?

 

We have used ghostscript in the past to create pdf’s but I was unaware they had a tool to go the other direction.

 

Are those bat files included with the standard install of ghostscript?

 

Thanks,

Tom

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Frederik Soete
Sent: Tuesday, September 21, 2021 1:39 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] xpa 4.7 - combining multiple pdf

 

Ghostscript ok?

 

If you convert a series of pdf into a series of postscript (ghostscript's pdf2ps.bat), then concatenate the postscript into one single postscript (putting the contents of each file one after another), then convert the end result to pdf (ghostscript's ps2pdf.bat), you should get a pdf containing the original pages.

 

HTH,

 

Frederik Soete

Op di 21 sep. 2021 19:18 schreef Tom Worthen <tworthen@...>:

Is anyone aware of a method to combine multiple pdf’s into 1?

 

I have a situation where we are generating labels as pdf’s but we need to combine multiples into a single pdf.

 

I have attempted tried several different approaches and nothing has worked as of yet.

 

Any ideas would be appreciated.

 

Thanks,

Tom



Re: xpa 4.7 - combining multiple pdf

Tom Worthen
 

Maybe I should have given more information. These are base64 fields that contain pdfs. I can use the BlobFromBase64 and this gives me a blob with the pdf in it. I have proved that by doing a blb2file with that result and I can open the file saved as a pdf. I have attempted to combine the fields and do a BlobFromBase64 on that and the result adobe will not open. I have attempted to use BlobFromBase64 and then use blb2file with the 2 blobs concatenated and adobe also refuses to open that result.

 

Frederik, if I understand what you are suggesting is to use ghostscripts different bat files to change the pdfs into postscript files, then concatenate those and then use their bat file to convert that result back to a pdf? If this what you are suggesting?

 

We have used ghostscript in the past to create pdf’s but I was unaware they had a tool to go the other direction.

 

Are those bat files included with the standard install of ghostscript?

 

Thanks,

Tom

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Frederik Soete
Sent: Tuesday, September 21, 2021 1:39 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] xpa 4.7 - combining multiple pdf

 

Ghostscript ok?

 

If you convert a series of pdf into a series of postscript (ghostscript's pdf2ps.bat), then concatenate the postscript into one single postscript (putting the contents of each file one after another), then convert the end result to pdf (ghostscript's ps2pdf.bat), you should get a pdf containing the original pages.

 

HTH,

 

Frederik Soete

Op di 21 sep. 2021 19:18 schreef Tom Worthen <tworthen@...>:

Is anyone aware of a method to combine multiple pdf’s into 1?

 

I have a situation where we are generating labels as pdf’s but we need to combine multiples into a single pdf.

 

I have attempted tried several different approaches and nothing has worked as of yet.

 

Any ideas would be appreciated.

 

Thanks,

Tom


Re: xpa 4.7 - combining multiple pdf

Wes Hein
 

My original reply didn't go through so if it does later ignore it!

Write a batch task that calls the print programs, create an I/O file with it's unique Name.  Add a parameter to each of the print jobs to receive that I/O name.  In the I/O properties of each print program, use this parameter in the 'I/O name to use:'.

This way all the print jobs can go to one PDF

Wes


Re: xpa 4.7 - combining multiple pdf

Frederik Soete
 

Ghostscript ok?

If you convert a series of pdf into a series of postscript (ghostscript's pdf2ps.bat), then concatenate the postscript into one single postscript (putting the contents of each file one after another), then convert the end result to pdf (ghostscript's ps2pdf.bat), you should get a pdf containing the original pages.

HTH,

Frederik Soete

Op di 21 sep. 2021 19:18 schreef Tom Worthen <tworthen@...>:

Is anyone aware of a method to combine multiple pdf’s into 1?

 

I have a situation where we are generating labels as pdf’s but we need to combine multiples into a single pdf.

 

I have attempted tried several different approaches and nothing has worked as of yet.

 

Any ideas would be appreciated.

 

Thanks,

Tom


xpa 4.7 - combining multiple pdf

Tom Worthen
 

Is anyone aware of a method to combine multiple pdf’s into 1?

 

I have a situation where we are generating labels as pdf’s but we need to combine multiples into a single pdf.

 

I have attempted tried several different approaches and nothing has worked as of yet.

 

Any ideas would be appreciated.

 

Thanks,

Tom


Re: Maximum file size Pervasive

Wes Hein
 

Are you using 'CndRange' or 'If statements' in your ranges?  CndRange can help with performance

Wes

Wes Hein

Principal Software Engineer

P: 503.751.2537  

E: wes.hein@...  

Springbrook Community

cirrus_platform

The company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient you are notified disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


Re: 3.2 error using mgent1 license

Todd Baremore
 

Tim,

https://stackoverflow.com/questions/22464792/registry-handles-leaked
Todd
On 9/18/2021 11:52 PM, Tim Downie wrote:

Hi
Im curious to see has any one ever seen these errors below, 2008 server magic 3.e.
Magic will now connect to the broker but it can't check out a license and IIS just returns broker error 119 ?


 DETAIL -
 12 user registry handles leaked from \Registry\User\S-1-5-21-2911807305-668782307-2401741904-1122:
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer


3.2 error using mgent1 license

Tim Downie
 

Hi
Im curious to see has any one ever seen these errors below, 2008 server magic 3.e.
Magic will now connect to the broker but it can't check out a license and IIS just returns broker error 119 ?


 DETAIL -
 12 user registry handles leaked from \Registry\User\S-1-5-21-2911807305-668782307-2401741904-1122:
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Control Panel\International
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2140 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts
Process 2132 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer
Process 2120 (\Device\HarddiskVolume3\magic3.2e\MgxpaRuntime.exe) has opened key \REGISTRY\USER\S-1-5-21-2911807305-668782307-2401741904-1122\Software\Microsoft\Windows\CurrentVersion\Explorer

1221 - 1240 of 195859