Select and fetch next

[milu753001]

hey my syetem is ONE world XE ERP 8
database is oracle 8i

The data in the f4074 is only single row only .
VA rpt_F4074PriceAdjustmentType=ZCONAC
VA rpt_F4074PriceAdjustmentType = TK Price Adjustment Name
The price field has a value in it ,But this field in F4074 is not a key field (while in select statement passing for key field iam passing this vlue also)



IF BC Line type = 'CN"

F4074.Select
BC Document (Order No, Invoice, etc.) (F4211) = TK Document (Order No, Invoice, etc.)
BC Order Type (F4211) = TK Order Type
BC Order Company (Order Number) (F4211) = TK Order Company (Order Number)
BC Line number(F4211) = TK Line Number
VA rpt_F4074PriceAdjustmentType = TK Price Adjustment Name
F4074.Fetch Next
RV Price <- TK Amount - Price per Unit
else
RV Price = BC Amount _extende(F4211)

 

[vmcdaniel]

Where's the icon of a little yellow guy with steam coming out of his ears..is this is the best we can do?

Vernon

 

[vmcdaniel]

[ QUOTE ]
hey my syetem is ONE world XE ERP 8
database is oracle 8i


[/ QUOTE ]

 

[MPDev]

[ QUOTE ]
hey my syetem is ONE world XE ERP 8
database is oracle 8i

[/ QUOTE ]

Hi again, milu

Thanks for posting your system info.

A few other things to check:

You are using the AST field on your selection like this:

"VA rpt_F4074PriceAdjustmentType = TK Price Adjustment Name"

AST is a string, linked to the 40:TY UDC.

If you are setting the variable "VA rpt_F4074PriceAdjustmentType " value manualy, please check if there are leading blanks, or any blank spaces on the right, comparing to the UDC value.

For example, if your UDC 40:TY has " ABC " and you are using a string variable with "ABC", or "ABC " , or " ABC" on the select, it might no work.

Hope this helps.

Regards