Hi, Can anyone help me with the update of an Array within a Form ? I save a Record in a table and then I have to create a Sql in the form . But the record I Just save does not apear in the arroy. Always only the last record. But if I go out the form and run again it Apears ! Is There any command or step that I am missing in order to refresh the Query result in the array ? If I place the SQL result in a Cursor and Browse it works perfect.
Thanks Oscar
I Changed the Status in the table Shipment from "I" to "C" then in the same form I run this Sql:
Select Padr( Shipment.shpnum , 4, Space(1) ) + " | " + DTOC(shipment.shpdate) + " | "+ shipment.shpdoc + " | "+ shipment.shptype;
From Shipment ;
WHERE Shipment.shpStatus = "C";
Into Array aAllItems ;
Order By Shpnum