1. main@magicu-l.groups.io
  2. Messages
   Date   
Re: Duplicate index in Pervasive

yigal staroselsky
 

is it  psql or isam ?
if isam set the check table and check index options to true
is psql
add new table entry and import the  table definitions search difference 
Re: Duplicate index in Pervasive

Jakes du Preez <dupreez.jakes@...>
 

Do you have multiple indexes defined in your data view that are unique but with different index segments? Magic will implement the filter condition on the view depending on whichever index is used.

Jakes du Preez

On 28 Sep 2021, at 21:39, Danica Majernikova <danka32@...> wrote:


Hi Pavel,
have you converted original data to get the state you are talking about?
I had a similar problem with AS/400  a long time ago.




From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Pavel Mencl <pavel.mencl@...>
Sent: September 28, 2021 5:26 AM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: [magicu-l] 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

<dummyfile.0.part>
<dummyfile.1.part>
Re: Duplicate index in Pervasive

Pavel Mencl
 

Steve,
as ever you've hit the nail right on the head, there are negative values. This is a 20+ years old design where in the past below zero values were used as temporary, later we switched to a different approach and happily forgot about this. 
Thank you very much.
Pavel
Record Counter Prior to Stat(0,'D')

buster reinke
 

Hi all, I am having an issue with a batch task that used to work fine in UniPaaS 1.9, but it is not working in XPA as it should. Prior to deleting a record, I run a batch task to count any records that are linked to the one I am trying to delete. If any records exist, I want the user to first delete the linked records. However, this batch task is sometimes indicating that records exist, when there actually are not any. I did some checking and the batch task is actually counting linked records for the next record, as if I had already deleted the one I am parked on. Stat(0,'D') triggers the record counter, and I have it in the Record Suffix. Is it possible that the record delete function is being carried out prior to triggering the record counter batch file, and it is actually counting linked records for the next record? I tried putting it in Task Suffix, but it didn't trigger the batch task? 

Thanks,

Buster
Re: Duplicate index in Pervasive

Danica Majernikova
 

Hi Pavel,
have you converted original data to get the state you are talking about?
I had a similar problem with AS/400  a long time ago.




From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Pavel Mencl <pavel.mencl@...>
Sent: September 28, 2021 5:26 AM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: [magicu-l] 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: Duplicate index in Pervasive

Steven Blank
 

Pavel,

More information is needed, please.

What columns participate in this unique index? Do you have Check Definition enabled for this database? Do the index segments as described in your project's Data Sources Repository exactly match the index segments as described by BUTIL -STAT, in datatype, offset, and length?

If the unique index consists of DokRada + DokCislo + DokRad... columns, then I see no duplicates in the first image. Yes, these rows all have the same values for DokRada and DokCislo, but when you include the DokRad... column, then, if the DokRad... column is Stored As: Signed Integer, then the first two lines in the image below are likely NEGATIVE values, with a Picture that does not display the negative sign (-) and all rows are, in fact, unique.

Steven G. Blank
SGBlank Consulting



On 9/28/2021 2:26 AM, Pavel Mencl wrote:
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: Usercredentials limited

Steven Burrows
 

If for some reason LDAP or Active Directory are not an option, then you have to do it all yourself… painfully.

If someone is insisting on security measures in such detail, I would also expect (later) demands to detail your encryption methods and other security information that is unknown Magic Internals.

 

When customer gets heavy on security, using their existing security is always the easiest hurdle to jump

Steven Burrows

 

From: main@magicu-l.groups.io <main@magicu-l.groups.io> On Behalf Of De Netwerkadviseur BV via groups.io
Sent: 28 September 2021 14:29
To: main@magicu-l.groups.io
Subject: [magicu-l] Usercredentials limited

 

[Edited Message Follows]

Hi,

I need to limit password use:
- Mandatory change after xx days
- Mandatory lenght of >10
- Not formely used

Is this possible or do I have to build something my selve? I don't like to build myselves because of the "Not formely used". This means I have to archive the passwords: somthing I don't want to.

XPA4.7

Kind regards,
André

Usercredentials limited

De Netwerkadviseur BV
 
Edited

Hi,

I need to limit password use:
- Mandatory change after xx days
- Mandatory lenght of >10
- Not formely used

Is this possible or do I have to build something my selve? I don't like to build myselves because of the "Not formely used". This means I have to archive the passwords: somthing I don't want to.

XPA4.7

Kind regards,
André
Re: Duplicate index in Pervasive

Keith Canniff
 

If you do a Ctrl+g from the data repository do you see duplicates?  If not then it's your program that has the issue.

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of ahrendt@... <ahrendt@...>
Sent: Tuesday, September 28, 2021 8:17:37 AM
To: main@magicu-l.groups.io <main@magicu-l.groups.io>
Subject: Re: [magicu-l] Duplicate index in Pervasive
 
Negative values + picture without "N"?

Regards
Ulrich

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
1321 - 1340 of 195968