Master-Detail Relationship problems

[Anonymous]

Hello, I am trying to learn Suneido and I have very limited experience in OOL. I am having trouble with the example of the master_detail relationship in your documentation. I have copied and pasted each part into a lib and created the tables. I try to run the EnterInvoices block and get an error in the browse part. I get a “query: non-existant table: suneidolog” Below is the code as it is entered. I would appreciate any help. I am trying to write an invoicing program for work and really need to understand this part. I have also tried to use the code block in the cookbook section of the documentation and get the same errors. Thank you for any help.

Controller
{
Controls:
(Access
title: “Enter Invoices”
invoice
(Vert
(Horz invoice_number Skip customer)
(Skip)
(Browse
“invoicelines”,
columns: (product, qty, price, total_price)
linkField: invoice,
name: “invoice”)
)
)
}

Thank you
Benny Laviner

[gmauro]

Hi, have you checked that the ‘suneidolog’ table exists?

In the QueryView, enter:

suneidolog

then press F9 and see the result. If you have errors, then I think your ‘suneido.db’ file could be damaged or you have messed up with the system tables. Try to reinstall Suneido and see if it helps.

[amckinlay]

If the suneidolog table is missing you can create it by running (from the WorkSpace)

SuneidoLog.Ensure()

[Author]

Posts