Auto-increment Vantage 8.03

system · January 7, 2014, 11:01pm

This is the code that seems to be working. I have not done any ABL before so I have no idea what I am doing and this could be done better I am sure....

DEFINE QUERY GetAll FOR UD100 .

OPEN QUERY GetAll FOR EACH UD100 BY INT(UD100.Key1).

Get last GetAll.

FOR EACH TTUD100:

ASSIGN TTUD100.KEY1 = STRING(INTEGER(UD100.Key1) + 1 ).

END.

system · July 19, 2012, 10:56am

(Asking as a non-programmer) is there any way for me to get the primary key set to auto-increment in the UD15 table?
Cheryl

[Non-text portions of this message have been removed]

system · July 19, 2012, 11:23am

Sure, you need a BPM on Post Processing GetNewUD15

FIND LAST UD15 NO-LOCK NO-ERROR
IF AVAILABLE UD15
FOR EACH ttUD15:
ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
END.

Please note that I am doing this from memory without a syntax checker, but
the concept its there.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
<celliott@...>wrote:

> **
>
>
> (Asking as a non-programmer) is there any way for me to get the primary
> key set to auto-increment in the UD15 table?
> Cheryl
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

system · July 19, 2012, 4:31pm

Also, just for reference, depending on where you are editing from, Epicor
will automatically auto increment Key5 already.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Thu, Jul 19, 2012 at 11:22 AM, Jose Gomez <jose@...> wrote:

> Sure, you need a BPM on Post Processing GetNewUD15
>
> FIND LAST UD15 NO-LOCK NO-ERROR
> IF AVAILABLE UD15
> FOR EACH ttUD15:
> ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
> END.
>
>
> Please note that I am doing this from memory without a syntax checker, but
> the concept its there.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
> <celliott@...>wrote:
>
> > **
> >
> >
> > (Asking as a non-programmer) is there any way for me to get the primary
> > key set to auto-increment in the UD15 table?
> > Cheryl
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

system · July 19, 2012, 7:06pm

Wasn't aware of that John. Will it do this if you start with a 'clean' UD table and never add a value to Key5?

Thanks,

-Ted

________________________________
From: John Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 19, 2012 4:31 PM
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Also, just for reference, depending on where you are editing from, Epicor
will automatically auto increment Key5 already.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Thu, Jul 19, 2012 at 11:22 AM, Jose Gomez <jose@...> wrote:

> Sure, you need a BPM on Post Processing GetNewUD15
>
> FIND LAST UD15 NO-LOCK NO-ERROR
> IF AVAILABLE UD15
> FOR EACH ttUD15:
> ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
> END.
>
>
> Please note that I am doing this from memory without a syntax checker, but
> the concept its there.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>Â <
> http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>Â <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
> <celliott@...>wrote:
>
> > **
> >
> >
> > (Asking as a non-programmer) is there any way for me to get the primary
> > key set to auto-increment in the UD15 table?
> > Cheryl
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

system · July 20, 2012, 7:46am

Yes as long as you are using UD0X entry
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Ted Koch <tkoch77@...>
Sender: vantage@yahoogroups.com
Date: Thu, 19 Jul 2012 16:06:48
To: vantage@yahoogroups.com<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Wasn't aware of that John. Will it do this if you start with a 'clean' UD table and never add a value to Key5?

Thanks,

-Ted

________________________________
From: John Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 19, 2012 4:31 PM
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Also, just for reference, depending on where you are editing from, Epicor
will automatically auto increment Key5 already.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Thu, Jul 19, 2012 at 11:22 AM, Jose Gomez <jose@...> wrote:

> Sure, you need a BPM on Post Processing GetNewUD15
>
> FIND LAST UD15 NO-LOCK NO-ERROR
> IF AVAILABLE UD15
> FOR EACH ttUD15:
> ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
> END.
>
>
> Please note that I am doing this from memory without a syntax checker, but
> the concept its there.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>ï¿½ <
> http://www.facebook.com/josegomez>
>ï¿½ <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>ï¿½ <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>ï¿½ <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
> <celliott@...>wrote:
>
> > **
> >
> >
> > (Asking as a non-programmer) is there any way for me to get the primary
> > key set to auto-increment in the UD15 table?
> > Cheryl
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:ï¿½ You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:ï¿½ You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%ef%bf%bd
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · July 20, 2012, 9:35am

I use ud tables and never saw something like that on my key5
Am I missing something?

We are on 9.04.507a
Ephraim Feldman

-----Original Message-----
From: jose@...
Sender: vantage@yahoogroups.com
Date: Fri, 20 Jul 2012 11:45:49
To: Vantage<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Yes as long as you are using UD0X entry
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Ted Koch <tkoch77@...>
Sender: vantage@yahoogroups.com
Date: Thu, 19 Jul 2012 16:06:48
To: vantage@yahoogroups.com<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Wasn't aware of that John. Will it do this if you start with a 'clean' UD table and never add a value to Key5?

Thanks,

-Ted

________________________________
From: John Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 19, 2012 4:31 PM
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Also, just for reference, depending on where you are editing from, Epicor
will automatically auto increment Key5 already.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Thu, Jul 19, 2012 at 11:22 AM, Jose Gomez <jose@...> wrote:

> Sure, you need a BPM on Post Processing GetNewUD15
>
> FIND LAST UD15 NO-LOCK NO-ERROR
> IF AVAILABLE UD15
> FOR EACH ttUD15:
> ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
> END.
>
>
> Please note that I am doing this from memory without a syntax checker, but
> the concept its there.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>Â <
> http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>Â <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
> <celliott@...>wrote:
>
> > **
> >
> >
> > (Asking as a non-programmer) is there any way for me to get the primary
> > key set to auto-increment in the UD15 table?
> > Cheryl
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · July 20, 2012, 11:01am

The BOs don't do it, but Epicor does it in the higher logic when you work
with the UDXX Entyr forms or if you use the 'add UD table as child' wizard.
If you're working with them from anywhere else, you'll need to do it
yourself.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Fri, Jul 20, 2012 at 9:35 AM, <effgroups@...> wrote:

> I use ud tables and never saw something like that on my key5
> Am I missing something?
>
> We are on 9.04.507a
> Ephraim Feldman
>
> -----Original Message-----
> From: jose@...
> Sender: vantage@yahoogroups.com
> Date: Fri, 20 Jul 2012 11:45:49
> To: Vantage<vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Auto-increment Vantage 8.03
>
> Yes as long as you are using UD0X entry
>
> Sent from my Verizon Wireless BlackBerry
>
>
>
> -----Original Message-----
>
> From: Ted Koch <tkoch77@...>
>
> Sender: vantage@yahoogroups.com
>
> Date: Thu, 19 Jul 2012 16:06:48
>
> To: vantage@yahoogroups.com<vantage@yahoogroups.com>
>
> Reply-To: vantage@yahoogroups.com
>
> Subject: Re: [Vantage] Auto-increment Vantage 8.03
>
>
>
> Wasn't aware of that John. Will it do this if you start with a 'clean' UD
> table and never add a value to Key5?
>
>
>
> Thanks,
>
>
>
> -Ted
>
>
>
>
>
>
>
> ________________________________
>
> From: John Driggers <waffqle@...>
>
> To: vantage@yahoogroups.com
>
> Sent: Thursday, July 19, 2012 4:31 PM
>
> Subject: Re: [Vantage] Auto-increment Vantage 8.03
>
>
>
> Also, just for reference, depending on where you are editing from, Epicor
>
> will automatically auto increment Key5 already.
>
>
>
>
>
> *John Driggers*
>
> **
>
> *Chief Data Wrangler*
>
> *
>
> *
>
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
>
> *
>
> *:: 904.404.9233
>
> :: waffqle@...
>
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
>
>
> *
>
>
>
> *
>
>
>
>
>
>
>
> On Thu, Jul 19, 2012 at 11:22 AM, Jose Gomez <jose@...> wrote:
>
>
>
> > Sure, you need a BPM on Post Processing GetNewUD15
>
> >
>
> > FIND LAST UD15 NO-LOCK NO-ERROR
>
> > IF AVAILABLE UD15
>
> > FOR EACH ttUD15:
>
> > ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
>
> > END.
>
> >
>
> >
>
> > Please note that I am doing this from memory without a syntax checker,
> but
>
> > the concept its there.
>
> >
>
> > *Jose C Gomez*
>
> > *Software Engineer*
>
> > *
>
> > *
>
> > *
>
> > *T: 904.469.1524 mobile
>
> > E: jose@...
>
> > http://www.josecgomez.com
>
> > <http://www.linkedin.com/in/josecgomez> <
>
> > http://www.facebook.com/josegomez>
>
> > <http://www.google.com/profiles/jose.gomez> <
>
> > http://www.twitter.com/joc85>
>
> > <http://www.josecgomez.com/professional-resume/>
>
> > <http://www.josecgomez.com/feed/>
>
> > <http://www.usdoingstuff.com>
>
> >
>
> > *Quis custodiet ipsos custodes?*
>
> >
>
> >
>
> >
>
> > On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
>
> > <celliott@...>wrote:
>
> >
>
> > > **
>
> > >
>
> > >
>
> > > (Asking as a non-programmer) is there any way for me to get the primary
>
> > > key set to auto-increment in the UD15 table?
>
> > > Cheryl
>
> > >
>
> > > [Non-text portions of this message have been removed]
>
> > >
>
> > >
>
> > >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
> >
>
> >
>
> > ------------------------------------
>
> >
>
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>
> > have already linked your email address to a yahoo id to enable access. )
>
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
>
> > Crystal Reports and other 'goodies', please goto:
>
> > http://groups.yahoo.com/group/vantage/files/.
>
> > (2) To search through old msg's goto:
>
> > http://groups.yahoo.com/group/vantage/messages
>
> > (3) To view links to Vendors that provide Vantage services goto:
>
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> >
>
> >
>
> >
>
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> ------------------------------------
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
>
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]

system · October 2, 2012, 2:04pm

For posterity, here's one that works with UD03. I added a post-process BPM on GetANewUD03 (note the "A", doesn't work with GetNewUD03) with no conditions that "synchronously executes ABL code" listed here:

FIND LAST UD03 NO-LOCK NO-ERROR.

IF AVAILABLE UD03 THEN DO:

FOR EACH TTUD03:
ASSIGN TTUD03.KEY1 = STRING(INTEGER(UD03.KEY1) + 1).
END.

END.

Jose thanks for the starter!

Ken

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, July 19, 2012 9:22 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Auto-increment Vantage 8.03

Sure, you need a BPM on Post Processing GetNewUD15

FIND LAST UD15 NO-LOCK NO-ERROR
IF AVAILABLE UD15
FOR EACH ttUD15:
ttUD15.Key1=NUMERIC(ttUD15.Key1)+1
END.

Please note that I am doing this from memory without a syntax checker, but the concept its there.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Thu, Jul 19, 2012 at 10:56 AM, Cheryl Elliott
<celliott@...>wrote:

> **
>
>
> (Asking as a non-programmer) is there any way for me to get the
> primary key set to auto-increment in the UD15 table?
> Cheryl
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · January 6, 2014, 1:53am

I think I have found a small issue with this method but I cant find a solution yet... I have implemented this on UD100 but I have found that when ever I create a new record the key is always set to 100. On further investigation I found that I have just over 100 records and when I do a search that last record is always record 99 as the search is sorting alphabetically...so 99 + 1 =100.

Any pointers would be helpful.

Cheers

Brett

system · January 6, 2014, 7:15am

Try adding "BY INT(Keyx) " to the end of your search clause where 'Keyx' is you numeric field stored as a string.....