Thank you for your kind invitation and the Screenies of Valentia looks great (and it’s free of course) but it does not fit to me because I am mostly dealing with huge Enterprise mySQL, MSSQL and Orcale Databases using reporting and import/export tools on regular basis. But I saved a bookmark and will tell everybody whos searching like Hanspeter.
You use reporting from Navicat? You work only on Windows? Just I remember, it have no reports on MAC OS X. Only on Windows. In contrast Valentina Studio have reports on all 3 OS. Reports of Navicat cannot be used in Xojo applications, and others, but Valentina Reports can be embedded.
Besides, Valentina Reports are part of Valentina Server, which can be used in same time as DB Server + Report Server. Again, it works native on 3 OS.
MSSQL – we will try add it, but as I understand, this will be possible only on Windows side…
Oracle also possible but after MSSQL.
Does your SQLite (et al) Browser support Foreign Keys with SQLite? Since that is new to SQLite it might be something to mention. 90% of the free browsers found online are out of date and no longer maintained so a lot of people will be looking for a new browser once they realize Foreign Keys are now supported on SQLite.
Does your SQLite (et al) Browser support Foreign Keys with SQLite? Since that is new to SQLite it might be something to mention. 90% of the free browsers found online are out of date and no longer maintained so a lot of people will be looking for a new browser once they realize Foreign Keys are now supported on SQLite.[/quote]
Well SQLiteStudio http://sqlitestudio.pl/ support Foreign Keys and well maintained. And it is supported for all three platforms: Mac, Linux and Windows.
You can write a project that will read your (or any) SQLite db file.
It is not a waste of time since you will learn how to do … what you already have to do in your own db project.
Also, IMHO, writing right now an Import (TEXT --> DataBase file) and Export (DataBase file --> TEXT) Methods will help you far away from what you can think !
I wrote month ago a pdf to explain how to use the Real Studio all purpose DB editor. I do not checked xojo on this subject and I do not need to do that now. Once you will be able to Import / Export, you will be able to display the data (in a ListBox ?).
Also, one advantage of the Import / Export methods, is that you do not care anymore about the (sqlite or other) db file: you can generate it at will. If you enter manually data in the running project (or stand alone), you may have a trouble and loose data. Your camp chooses.