Calcfields doesn't work using C/Front

jmlozares · 2006-04-26

Hi all!

I'm having trouble using c/front's calcfield method, error message is "Not Implemented". Does anybody has idea to solve this?

Best Regards!

mcapucci · 2006-04-26

Hi,
maybe there are some problem in the definition of flow field or in some table used for the flow field definition (i.e. keys). Try to recompile all object.
byebye

jmlozares · 2006-04-26

Thanks for the reply!

jmlozares · 2006-04-26

I'm accessing the Item table and tried to update the Inventory field, therefore Calcfields should be used. But, I don't know where I get wrong, everything is working except for this function.

dwest · 2006-04-26

jmlozares wrote:

I'm accessing the Item table and tried to update the Inventory field, therefore Calcfields should be used. But, I don't know where I get wrong, everything is working except for this function.

If I understand this correctly, you are trying to modify the value of the Inventory Field on the Item Card. This is not possible, The Inventory field is a calcfield, it shows the cummulative value of Quantity in the Item Ledger Entry table.

To be exact..............

Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter)))

easabangan · 2006-04-26

I am also experiencing this type of error in this function.

My code is this

ocxCF.CalcFields(Table, Record, FieldsToCalculate)

I think the error is on the third argu(FieldsToCalculate) that I am passing in the cfront.

Question : What must I pass to this argu? the field name or the Field No? What is the data type must I pass?

Thanks in Advance

jmlozares · 2006-04-26

thanks for replying!!

True, I want to update Inventory field, but knowing its a flowfield of course I won't be able to update the value of the field directly, therefore i have to use the CALCFIELDS function isn't it? What Im doing actually is access the Item table from another database through C/Front, but using calcfield doesn't work, it returns the error something like "..Note Implemented". what could be wrong?

jmlozares · 2006-04-27

using version 3.70, Table 27 (Item), field: Inventory.

HItem := cfront.OpenTable(27);
HRItem := cfront.AllocateRec(HItem);

IF cfront.FindRec(HItem, HRItem, '-') THEN BEGIN
   cfront.CALCFIELDS(HItem, HRItem, 'Inventory');
END;

kriki · 2006-05-04

BlackTiger wrote:

But this problem exists not only in Navision. Same problem with .NET, SQL Server and other technologies. Looks like it's just impossible to read documentation first.

Probably because analysts, bosses, customers are pushing us developers to produce and not lose time on reading/studying.

kriki · 2006-05-04

BlackTiger wrote:

Let's "boses" develop!

Better not, otherwise they will even push us harder to fix all the mess they created

Calcfields doesn't work using C/Front

Comments

Categories