Hi,

I am reading the Tutorial and specially the part that talk about a Maintenance procedure.
I am using as table to maintain on of my tables.
But when I run the procedure I am getting the following error and I am not able to figure out
what is wrong.

Any Idea?

Regards.

(FOC03847) MntEX Compile failed for majid/ProductClub
(FOC03601) ERROR AT OR NEAR LINE 14 IN PROCEDURE majid/ProductClub.MAINTAIN
(FOC03730) :Non-NEXT access on non-keyed segment: is/are not supported in
Maintain.

Can you post the maintain code, as seen from the maintain editor and the MFD and ACX.

My initial guess is a MATCH statement, but that could be incorrect.

Hi Alan

Thanks for your reply.
Here is the code:

-------------------------------------
MAINTAIN FILE table_1

$$Declarations

Case Top
Infer table_1.TABLE_1.PRODUCT into Table_1Stk;
Winform Show Form1;
-* Replace the Winform Show command with the following code
-* when to display your form in a non-persistent state
-* Winform Show_and_exit Form1;
EndCase


Here is the acx:


SEGNAME=TABLE_1, CARDINALITY=4, TABLENAME=V2Reporting.dbo.Table_1,
CONNECTION=MSSQL, KEYS=0, $


Regards.

Case addProd
For all include table_1.TABLE_1.PRODUCT from Table_1Stk ;

EndCase

END

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

Maintain does not allow you to update non keyed tables. Either use MODIFY or change the table/access file.

Majid,

Maintain is a complete different kettle of fish when compared to "standard" WebFOCUS and is not a lanuguage that you should try and learn on your own. WHilst it is possible I would cerntainly not recommend it.

Get yourself on an IB training course to ensure that the basics and priciples are covered in your learning path so that you can embrace your future coding with confidence.

T

Hi Alan,

Yes it was because my table does not have a primary key.

Tony,

I would love join a trainning session. But I have no power for that.

Thanks to all of you