|
Re: Duplicate index in Pervasive
Negative values + picture without "N"?
Regards
Ulrich
|
|
|
Re: Duplicate index in Pervasive
Good idea but no, the numeric fields are both Signed Integers.
P.
|
|
|
Re: Duplicate index in Pervasive
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
toggle quoted messageShow quoted text
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
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
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
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
|
|
|
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
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é
|
|
|
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
Hi Tom,
I use PDFTK too. Very easy command line tool, no installation requested
Olivier
|
|
|
Re: xpa 4.7 - combining multiple pdf
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
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.
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
Have you looked at PDFTK or similar
command-line tools, for example
Sherm
toggle quoted messageShow quoted text
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
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.
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
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
toggle quoted messageShow quoted text
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
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.
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
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
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
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
Are you using 'CndRange' or 'If statements' in your ranges? CndRange can help with performance
Wes
|
|
|
|
|
|
|
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
toggle quoted messageShow quoted text
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
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
|
|
|
