In the last version available of 1.43, versioning is showing properly. Thanks for the update 
826 2014-08-29 13:25:06
Re: rel 1.43 (7 replies, posted in General)
827 2014-08-28 13:21:12
Re: rel 1.43 (7 replies, posted in General)
Another bug, in about window, the version number is not correct so we do not know which version is currently used!
1.43 has been installed but about says 1.42...
828 2014-08-28 13:04:42
Topic: Multiple reports on same page? (16 replies, posted in Reports)
Do you know a way to display multiple reports in the same report page?
For example, I would like to display on the same report page different sql queries reports, but when I generate a report the name is always "report" so I cannot really change the sources when designing the full report.
Please find attached an example of what I would like to do.
829 2014-08-28 09:29:26
Re: Sorting problem when creating a report (4 replies, posted in Reports)
@DriveSoft,
Many many thanks, it is working like a charm, you saved my day!!
@Flying2birds,
Yes, it is a very common problem, I have read a lot of articles on the Internet about it and I never found any simple relevant solution adapted to Sqlite. There are verycomplex queries adapted to Oracle & SqlServer which, in my opinion are, by far too complex compared to this simple trick!
I have even tried with Integer columns with no luck and I am not eager at all to fill in more than 250 rows manually which is why I use a database
Simplicity is my best friend 
830 2014-08-26 19:05:30
Topic: Sorting problem when creating a report (4 replies, posted in Reports)
Hi,
I am using version 1.42 and I have an issue when sorting SQL Queries result as shown on attached picture. Sorting is not accurate with numbers containing dots.
4.4.1 should be followed by 4.4.2, then 4.4.3 but in the software, sorting is done like this: 4.4.1, 4.4.10, 4.4.11, 4.4.2 which is not helping with the kind of report I am looking for.
Is it possible to gather multiple reports in one report?
For example, I want to report 2 or more SQL queries in the same report to get a broad overview.
831 2014-07-09 17:21:09
Re: Which character is sent when clearing a field? (3 replies, posted in SQL queries)
Never mind, I am really sorry, I found the error im my Sql query, I am too tired at the moment.... sorry!
832 2014-07-09 17:11:16
Re: Which character is sent when clearing a field? (3 replies, posted in SQL queries)
Sorry if I was not clear enough.
I have a table with imported data, some of the columns are null as data is missing.
if I run select * from table where Firstname is null or Firstname =' '
I get this result:
Firstname | Lastname | UserID | Department | Extn
| dataxyz | xxxx |xxxx | 1234
sometimes Column Firstname is null so I edit this column by inserting something let's say "Thierry".
Once this data saved, I can retrieve the information with Firstname = "Thierry"
Now, if I delete the data in Firstname ( delete "Thierry") but leave the other column, the row is still there but I cannot find it if I use the SQL query:
select * from table where Firstname is null or Firstname =' '
result is :
Firstname | Lastname | UserID | Department | Extn
instead of :
Firstname | Lastname | UserID | Department | Extn
| dataxyz | xxxx |xxxx | 1234
Why?
833 2014-07-05 20:48:53
Topic: Which character is sent when clearing a field? (3 replies, posted in SQL queries)
I am playing around with your fantastic application and I would like to understand which character the application send to the database to clear a field?
If I edit a field which was 'null' usind the function "Edit" in a formand save it, everything is Ok. Example: set Firstname to 'Test1'
If I delete this new information then Save (delete Firstname 'Test1'), I cannot retrieve this row using the following sql Query:
select * from <table> where <column> is null or <column> =' '
Which Query should I use?
834 2014-06-27 11:55:59
Re: hi i need tutorial about combobox how i create? (4 replies, posted in General)
There is unfortunately no Examples folder...
835 2014-06-26 20:23:37
Re: What to implement first? (187 replies, posted in General)
Great news for the import!!
I used the component Image, but I realized that the path to the image is not relative and the images are not copied automatically, so if you move the application to another computer, the images are not displayed anymore.
I finished my first application and man, you rock. This frontend maker is absolutely great. It is the best and the easiest to use I found so far! No programmation encyclopedies to learn by heart, not a single line of code to write to make a database application in minutes...you are a genius man!
I would like to better understand what the other components are and how to use them.
836 2014-06-26 06:55:21
Re: open existing database (6 replies, posted in General)
The point is that it is not an old database, it is a Sqlite 3 database
Edit 13:43 .... I managed to import data in the sqlite.db you are using, now I will try to work with that.
Edit 22:24 ..... Everything works super fine, thanks man!
837 2014-06-26 06:47:58
Re: What to implement first? (187 replies, posted in General)
Ok, I understood that we can use the free tool Sqlite Studio but I tried it and it is not that easy to manage.... I struggled to import data due to the difference in columns, you have an id column which I do not have.
My idea was to create my database outside Myvisualdatabase and use my external SQLite database but it does not work. So if I understand your way of working, I should create the database inside Myvisualdatabase and import the data exported from another Sqlite database. It just drives me crazy
Edit...13:40 I now understood how your database works and the database must be named sqlite.db to work with the software...
My meaning in my precedent message was to implement the possibility to import data inside myvisualdatabase during the creation process.
Another great stuff which could be implemented would be the possibility to personalize the form with a background, to put a logo or changing the application icon.
838 2014-06-25 19:44:55
Re: open existing database (6 replies, posted in General)
But how do you use this already existing database in a project. I have a Sqlite database with 488 rows but I do not know how to use it with myvisual database, when I query it there is no data coming up. If I query it with SqliteStudio or another tool, it is ok... Please more details on connecting to an existing database, you did a really good job with this application!
839 2014-06-25 19:41:17
Re: What to implement first? (187 replies, posted in General)
The possibilty to import an already existing Sqlite database or straight from csv would be great! I have a Sqlite database but I cannot figure out how to use it, I am not eager to recreate 488 rows manually!!