Insert Web Text Field data into Sqlite DB

Databases
23

Do you have an app that can open an SQLite database?
If not get one and open the database at the location as defined in your source code.
Than you can see if the table MasterAccount is defined/available.

A free SQLite app is DB Browser for SQLite

Paid options are:
Tadpole by Dave S (well known on this forum)
His website is currently under construction. Contact @Dave S for more info.

SQLiteManager

Various other free/paid options are available.

24

[quote=420350:@Craig Wyeth]Unfortunately not. I am still receiving the same error message.

no such table: MasterAccount[/quote]
can you please repost the actual code ?

26

is the ‘ID’ field primarykey and autoincrement ?
else you should specify a value for the field in your code.

27

Thank you all for your assistance.

I managed to resolve but it is an interesting one…

If I shorten the FolderItem path it then identifies the DB and the table

DBFile = SpecialFolder.Documents.Child(“Projects”).Child(“ALC.sqlite”) <========== NEW PATH
DBFile = SpecialFolder.Documents.Child(“Wyzelink”).Child(“Wyzelink Xojo Projects?”).Child(“ALC.sqlite”) <============== OLD PATH

Your assistance is very much appreciated.

28

Of course.
The problem was probably the fact that there were spaces in the pathname (Wyzelink Xojo Projects)
Adding opening and closing quotes to the pathname would have solved the problem too.

DBFile = chr(34) + SpecialFolder.Documents.Child("Wyzelink").Child("Wyzelink Xojo Projects?").Child("ALC.sqlite") + chr(34)
29

I learnt something new.

Thank you.

30

I’m curious though, why did Xojo give a “no such table” error which makes it look like the DB file is accessible but missing the table? Why not give a “File not found” or “No database found” error?

31

[quote=420390:@Craig Wyeth]I learnt something new.

Thank you.[/quote]
Welcome to Xojo and its community, Craig.

32

Thank you Ralph