AutoNumber() as Key

[datanibbler]

Hi,

I am currently working on an app which is going to be quite big as there is a lot of data.

I thus tried to make it somewhat less resource-heavy by using the AutoNumber() function to replace

an alphanumeric key by a numeric.

To check if the linking works, I kept the original key in both tables and renamed it so that wouldn't be linked.

I then used

>> AutoNumber([keyfield], 'Key') <<

in both the tables.

<=> From the look of it, it seems that quite some keyfields that actually exist in both tables are not linked anymore.

Is there anything I have overlooked?

Thanks a lot!

Best regards,

DataNibbler

[pokassov]

Hi

You have to do it in one document during reload

[datanibbler]

Hi Sergej,

what do you mean, in one document?

[luciancotea]

Try Autonumberhash128()

[pokassov]

In one app. If you make key using autonumber for first table in one app and for second table in another. To store data in to qvd file for example and then use both qvd in app, then autonumber will not work correctly.

[datanibbler]

Ah, now I understand.

Well, they are in one app all right.

I'm not quite sure about that as the linking was less than perfect before ...

I'll do a test now, writing down a dozen or so items which are linked using the alphanumeric key, then switch to the numeric and test those same items.

[datanibbler · Accepted solution]

Okay.

Thank you all for your help! It does work, after all. It's just that many values cannot be matched - and aren't supposed to. I didn't think about that the first time round. Now I started from the "smaller" side where all items should have a match.

I tested it on a dozen samples and in those cases where the link worked before, it works with AutoNumber(), too. So I'll keep that.

Best regards,

DataNibbler