11 replies to this topic

[Fabiano Giannetti]

When I try to delete or insert record in a Auto-sequenced file defined as SQL files Pro-IV doesn't work properly as defined in manual : Pro-IV lost the record sequence.

For example :

REC 1 : KEY 001 VALUE A
REC 2 : KEY 002 VALUE B
REC 3 : KEY 003 VALUE C
REC 4 : KEY 004 VALUE D
REC 5 : KEY 005 VALUE E

If I delete REC 3 the result is :

REC 1 : KEY 002 VALUE B
REC 2 : KEY 003 VALUE A
REC 3 : KEY 004 VALUE D
REC 4 : KEY 005 VALUE E

I think that Pro-IV doesn't write KEY 001 and transfer the value of REC 1 to the record with KEY 003. Some help??

Our Pro-IV version is 4.6 r2.0.0

I read then Item Fixed of r2.1.8 but Nothing is reported.

[Ralph Gadsby]

Have you reported this as a bug to Pro IV support? If not, why not? I concur with Neil Mellis's view (see the posting on Developer Studio with Btrieve).

Ralph

[Joseph Serra]

Are you inferring the bug would be fixed if reported?

[Ralph Gadsby]

Are you inferring that reported bugs are not fixed?

[Joseph Serra]

Why did you answer my question with a question?

[Peter Davies]

Are you deleting the record in a paging screen ?

The auto-sequencing only occurs inside paging screens.

If you are doing the delete in an update, you'll have to re-sequence the records yourself.

Peter

[Fabiano Giannetti]

Of Course Peter, Of Course.....

[Peter Davies]

Fabiano

OK, you are in a paging screen ?

Are you using SEL-ONLY, SEL-RANGE or SEL-PARTIAL ?

As you probably know, auto-sequenced doesn't work with these commands.

[Shaun Rudland]

This might be a case of 'statin' the bleedin' obvious', but that also includes SQL selects.

Personal opinion time: Auto-sequenced files were fine way back when, but now that the 'manual' controlling of a sequence is so much easier they are something to be avoided if at all possible.

[Fabiano Giannetti]

Peter,

Nothing SEL-ONLY,SEL-RANGE,SEL-PARTIAL...

and now???

[Shaun Rudland]

Is it possible to temporarily replace the auto-sequenced external file with an auto-sequenced isam file which is an exact copy of the original ? That way, you should be able to determine whether the problem is something you missed in coding, or whether there is something inherently wrong with the revision of PRO-IV you are using with regard to external file types and auto-sequencing.

[Fabiano Giannetti]

I tried to do it and if the file is Pro-ISAM everything is OK.

Now I think there's a ProIV bug.

Thanks.