Type Variant!!!

Hanen

Hello,

Variant type for field table doesn't exist in navision?
I have a stored procedure that contains some fields and a sum of amounts and I call it from navision and the result is an error message even if I store the sum in field of mytable datatype decimal.
How can I resolve that problem????
I'll be greatful for your help!!!

kriki

Try first to store the variant in a local variable of type decimal. Then put that variable into the field of the table.

ara3n

hello

Could you provide a little more information on how you are calling the stored proc?

garak

maybe he must use the CAST() command in his SP.
How looks your SP, how do you call it from NAV (ADO?) and how do you store the result of the SP?

Hanen

That's the code:

//************************************ Open sql connection *******************

ltxtConnectionString:='Provider=SQLNCLI;Server=xxxxx;Database=xxxxxxxxx;Trusted_Connection=yes;';
IF ISCLEAR(lADOConnection) THEN CREATE(lADOConnection);
lADOConnection.ConnectionString:=ltxtConnectionString;
lADOConnection.Open;

//************************************ Execute SP *************************

lvarActiveConnection := lADOConnection;
IF ISCLEAR(lADOCommand) THEN CREATE(lADOCommand);
lADOCommand.ActiveConnection := lvarActiveConnection;
lADOCommand.CommandText := 'repartition';
lADOCommand.CommandType := 4; 
lADOCommand.CommandTimeout := 0;    


lADOCommand.Execute; 

IF ISCLEAR(lADORecordset) THEN 
CREATE(lADORecordset);

lADORecordset.ActiveConnection := lvarActiveConnection; 
lADORecordset.Open(lADOCommand);    
 repartition007.DELETEALL;
WHILE NOT lADORecordset.EOF DO BEGIN  

repartition007.INIT;
repartition007.Code := lADORecordset.Fields.Item('code').Value;
repartition007.Designation:= lADORecordset.Fields.Item('designation').Value;
repartition007.Nombre := lADORecordset.Fields.Item('nombre').Value;
repartition007.Duree :=  lADORecordset.Fields.Item('duree').Value;
repartition007.Montant := lADORecordset.Fields.Item('montant').Value;
repartition007.PU := lADORecordset.Fields.Item('pu').Value;

repartition007.INSERT;

lADORecordset.MoveNext; 

END;

//******************************** Close sql connection **********************

lADOConnection.Close; 
CLEAR(lADOConnection);

garak

is one of these fields a decimal field?

So you can add in yous SP select statement something like that (mean the CAST() method:

Select cast (TheDecimalField as float)

A good example you can find here: viewtopic.php?f=5&t=23038


Regards

Hanen

I've tried with cast ( myfield as decimal) but id didn't work the result is too big