Error - Table not opened (OpenInsight Specific)
At 18 DEC 2000 11:10:40AM a becker wrote:
We have the following:
On our billing form, we access, via a popup, information from the estimate table. The popup table contains, in a symbolic field, the estimate, FY, revision and amount. It is this field that is displayed on the form. The amount is displayed as $ and ยข.
When an bill is received for an estimate, we strip the amount out of the symbolic field and use that for the "beginning balance". We convert the amount to internal format of MD2. Please note that the "beginning balance" is not an MV, but the result of extracting the amount out of a symbolic field that is contained in another table.
When we attempt to access anything in the edit table, we get the message "Table not opened".
Each billing is entered into an edit table. The amount we wish to subtract from the "starting balance" is the net amount of the bill. This net amount is a calculated field, the result of taking the bill's gross amount and multiplying by the discount rate (not an MV field).
Example of what we wish to do:
starting amount=$150,000.00
bill 1 net=$40,000.00 amount left $110,000.00
bill 2 net=$10,000.00 amount left $100,000.00
bill 3 net=$50,000.00 amount left $50,000.00
bill 4 net=$60,000.00 amount left
The starting amount is a variable that was taken from the popup of the estimate table. All the billing information is in an edit table of the billing form.
Any ideas as to what is causing the "Table not opened"?
At 18 DEC 2000 03:32PM WinWin/Revelation Support wrote:
Can you put a Debug in the code, see when you get the message? It sounds like you use a read or readv without opening the file, or you have a typo when you open the file so that it does not ge opened. Is the filename in upper case?
Hope this helps,
Bob