Subject Should SQL be in same directory as tables?
From Rouke Bakker <moc.liamg@rekkabr>
Date Tue, 29 Aug 2023 03:06:30 -0400
Newsgroups dbase.getting-started

I'm struggling to convert dbase5.7 to dbase 2019 so am starting from scratch.

I created an SQL containing one table. Double clicking the sql in the navigator shows the tablecorrectly.

When I create a new form in the form designer and drag that same sql onto the designer, I get the message: "Database Engine Error: Table does not exist: C:\admin\database\expenses\EXPENSES.DBF".

I agree with the message; the table sits in C:\admin\database\EXPENSES.DBF, but why does the form look in C:\admin\database\expenses\EXPENSES.DBF (where the SQL resides and from where I clicked new form) while I have specified the table in the sql designer as residing in C:\admin\database\EXPENSES.DBF?