|
| [WD19] Data file not appear right value |
| Iniciado por guest, 02,oct. 2015 11:31 - 5 respuestas |
| |
| | | |
|
| |
| Publicado el 02,octubre 2015 - 11:31 |
Hi All,
I have two type of Window called WIN_Purchase and WIN_Stock.
And i use this coding like this :
FOR EACH ROW OF TABLE_COGS_1stRC
TableAddLine(Table_InvoiceLineRC,COL_sItemRef,...)
FOR EACH ROW OF Table_InvoiceLineRC
HReadSeekFirst(StockRLine,sItemRef,TABLE_InvoiceLineRC.COL_sItemRef)
IF HFound(StockRLine) THEN
IF StockRLine.nBalStockR > 0.000001 THEN
TableAddLine(TABLE_COGSRC,StockRLine.cCost,...)
END
END
END
END
For WIN_Purchase is no problem. But for WIN_Stock always give not consistent value.
So the TABLE_COGSRC is empty event in data file of the StockRLine.nBalStockR have a value.
StockRLine.nBalStockR is a Numeric/Decimal = 0.000000
I was write back the coding, create back the query, delete and rebuild the data file, recreate all button, recreate the table, and recreate the procedure but it still show wrong value.
Is it a bug for the WIN_Stock? Should i recreate the WIN_Stock from scratch? 
Thanks a lot.
Regards,
Mujahid |
| |
| |
| | | |
|
| | |
| |
| Publicado el 02,octubre 2015 - 11:41 |
Hi
What QUERY? You are not showing us any code related to a query
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 02,octubre 2015 - 13:03 |
Hi Mr Fabrice,
Thanks for your response. 
The above coding and the query also give same not consistent value.
If the query or the coding run on other windows, then it is no problem.
I also do repair on analysis and project.
I know this problem because complaint from the user. :confused:
Thank you.
Regards,
Mujahid |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,octubre 2015 - 04:13 |
Hi All,
IT IS SOLVED.
Im using direct coding like this.
FOR EACH ROW OF TABLE_COGS_1stRC
TableAddLine(Table_InvoiceLineRC,COL_sItemRef,...)
FOR EACH ROW OF Table_InvoiceLineRC
HReadSeekFirst(StockRLine,sItemRef,TABLE_InvoiceLineRC.COL_sItemRef)
WHILE HFound()
IF StockRLine.nBalStockR > 0.000001 THEN
TableAddLine(TABLE_COGSRC,StockRLine.cCost,...)
END
HReadNext()
END
END
END
BUT If im using QUERY then the result is not consistent.
QUERY EXAMPLE 1 :
IF HExecuteQuery(QRY_ItemBal_StockReceived,hQueryDefault,TABLE_InvoiceLineRC.COL_sItemRef) = True THEN
HReadFirst(QRY_ItemBal_StockReceived)
WHILE NOT HOut()
TableAddLine(TABLE_COGSRC,..)
HReadNext(QRY_ItemBal_StockReceived)
END
HFreeQuery(QRY_ItemBal_StockReceived)
ELSE
Error("Query initialization error"+CR+HErrorInfo())
RETURN
END
QUERY EXAMPLE 2 :
IF HExecuteQuery(QRY_ItemBal_StockReceived,hQueryDefault,TABLE_InvoiceLineRC.COL_sItemRef) = True THEN
FOR ALL QRY_ItemBal_StockReceived
TableAddLine(TABLE_COGSRC,...)
END
HFreeQuery(QRY_ItemBal_StockReceived)
ELSE
Error("Query initialization error"+CR+HErrorInfo())
RETURN
END
This query also interupting the rest coding process so the result will view multiple wrong value.
BUT im still confuse. Why in other windows, the query doesnt have that issue?
Any idea?
Thanks a lot.
Regards,
Mujahid |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,octubre 2015 - 11:33 |
Hi Mujahid,
Perhaps the table has a data source defined, check if the table is defined to be filled by programming.
Regards,
Piet |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,octubre 2015 - 04:28 |
Hi Piet,
Yes all table is filled by programming and i also was recreate all the table. But still same issue.
Thanks a lot.
Regards,
Mujahid |
| |
| |
| | | |
|
| | | | |
| | |
|