topic Create incremental Ztable key in Application Development and Automation Discussions

Create incremental Ztable key

Former Member — Wed, 18 Jul 2007 10:33:47 GMT

Hello everyone,

I need to create a Ztable with a key (ZID) that must be a number (like NUMC15, for example), incremented as elements are added to the table. How do i know whats the number to follow. Imagine i allready have 356 elements. So next ZID = 357.

I searched the forum and found something about number ranges. I created one. But how can i link this to my table key ?

Thank you in advance.

Re: Create incremental Ztable key

Former Member — Wed, 18 Jul 2007 10:39:04 GMT

I guess there is no direct link.

But you have to read the table each time before adding the records to find the latest key value. Than propose the next key value. How ?

In the table maintainace enter your own code and make the key field display only in insert mode.

Note: When you generate the table maintainace code each time it will ovwerwrite your code

Re: Create incremental Ztable key

Former Member — Fri, 20 Jul 2007 09:42:46 GMT

Solved it on my own. I'm not using ranges. Just searching for select (max) of that field, and then increment +1. Thank you all.