Cannot find table error. [sort of solved]
lazarus / 16-Databases

----------------------------------------------------------------------
Wurlitzer28 · 2015-05-27 13:49

Very first attempt at connecting to a new SQLite db from Lazarus.

As part of the learning process I thought I would just use someone
else's example code and change the db and table names to see if I
could make sense of the Lazarus->db connection process.

I used a sample program I found somewhere on this site and changed the
database name to my new DB and also changed the table name [but the
name was wrong] and of course I got an error:

"Project project1 raised exception class 'EDatabaseError' with
message: no such table: CombinedMasterMusic"

That was the name of the table in my original MS Access db but in the
newly created SQLite db it is 'MasterList' Ok that is exactly the
error I should have received. So far so good as Lazarus is operating
exactly as I expected it to do when I made this error.

So I went to the section of coded in 'unit1.lfm' and changed the table
name as such:
object SQLQuery1: TSQLQuery
    FieldDefs = <>
    Database = SQLite3Connection1
    Transaction = SQLTransaction1
    SQL.Strings = (
      'Select * from MasterList'
    )          

Now when I run the code, I don't get any errors after I hit Run but as
soon as I hit the button which should launch the code above I get
EXACTLY the same error with the same wrong table message. I searched
the entire project to see if I had used that same wrong table name
elsewhere, even though I thought I had only used it in the code above.
I cannot find any reference to 'CombinedMasterMusic'

Just in case, I closed Lazarus and restarted it but the same error
with the same wrong table name appeared.

EDIT: Re-booting the laptop fixed this. I trust this will not be a
required fix for weird database issues.

----------------------------------------------------------------------
Cyrax · 2015-05-27 13:52

Umm, under normal circumstances you shouldn't manually change .lfm
files at all. Use Lazarus Object Inspector to change component
properties.

----------------------------------------------------------------------
Leledumbo · 2015-05-27 14:07

You might want to cleanup the compiled units directory, assuming
they're not the same. Otherwise, I can't guess where else the problem
might be without touching the source.

----------------------------------------------------------------------
Wurlitzer28 · 2015-05-27 14:28

Quote from: Cyrax on May 27, 2015, 03:52:47 pmUmm, under normal
circumstances you shouldn't manually change .lfm files at all. Use
Lazarus Object Inspector to change component properties.

Thanks guys for the quick reply. The only reasons I changed the table
name in the .lfm files was pure newbie ignorance and I looked at every
object and could not fine where that reference to the wrong table name
existed. HOWEVER as i also did not see the correct table name using
the Object Inspector it would seem I did not look in all the right
places.

I will go back and check. I thought the full project search would show
the faulty table name but it did not.

Thanks again.