Hi,
I have :
assignValues.html
sendEmail.html
The program fails on the find clause. If I hardcode the tempreqnum to be tempreqnum-1 then it works fine.
I’ve checked the BytesBRD and the records are created.
So it seems the CREATE creates the record with reqnum e.g. 12, but then the FIND can only find up to the 11th record (Even if I use FIND LAST bytesbrd).
After running the app I get this in the log :
S-0003>(Apr 11, 2007 08:56:03:857) [34992] ** FIND FIRST/LAST failed for table BytesBRD. (565)
Or if run without the FIRST option :
S-0003>(Apr 11, 2007 08:58:17:015) [34992] ** No BytesBRD record is available. (91)
Please help! I need to be able to refference the last created record.
I have :
assignValues.html
Code:
[B][FONT=Arial][FONT=Arial]define new shared variable tempreqnum like bytesbrd.reqnum.[/FONT][/FONT][/B][FONT=Arial]
[B][FONT=Arial]create BytesBRD.[/FONT][/B]
[B][FONT=Arial]Assign ReqNum = tempreqnum. /*tempreqnum increments[/FONT][/B]
[B][FONT=Arial]Assign Benefits = get-value("Benefit").[/FONT][/B]
[B][FONT=Arial]Assign BRDReceived = "NO".[/FONT][/B]
[B][FONT=Arial][B].[/B][/FONT]
[FONT=Arial][B].[/B][/FONT]
[FONT=Arial]RUN value("sendEmail.html").[/FONT]
[/B][/FONT]
sendEmail.html
Code:
[B][FONT=Arial][FONT=Arial]define shared variable tempreqnum like bytesbrd.reqnum.[/FONT][/FONT][/B][FONT=Arial]
[B][FONT=Arial]find first bytesbrd where reqnum = tempreqnum NO-LOCK.[/FONT][/B]
[/FONT]
The program fails on the find clause. If I hardcode the tempreqnum to be tempreqnum-1 then it works fine.
I’ve checked the BytesBRD and the records are created.
So it seems the CREATE creates the record with reqnum e.g. 12, but then the FIND can only find up to the 11th record (Even if I use FIND LAST bytesbrd).
After running the app I get this in the log :
S-0003>(Apr 11, 2007 08:56:03:857) [34992] ** FIND FIRST/LAST failed for table BytesBRD. (565)
Or if run without the FIRST option :
S-0003>(Apr 11, 2007 08:58:17:015) [34992] ** No BytesBRD record is available. (91)
Please help! I need to be able to refference the last created record.