I'm a long time Valentina user for single client applications, but I've decided to play around with using the VServer to see where it might lead. Admittedly, I've not thoroughly read all the documentation but I've gotten some basic things working and now I'm getting an incorrect return on a simple SQL that I can't understand.
I'm using Valentina Studio 5.5.8 and the latest version of VServer on Mac.
I'm using the Valentina Studio to connect to a remote computer via my airport network. I can connect to the database and view all the tables and can also browse the records. The problem is when I do a simple SQL statement via the SQL editor.
This is the SQL statement:
SELECT * FROM artists WHERE lName LIKE 'Davis%'
When I do this via VS on a copy of the same database on my local computer, I get 35 records. When I execute this on the remote computer, I get 13 records.
Just for fun, I set up the VServer on my local computer and connect to another copy of this database. In this instance, I get the correct 35 records.
When I remove the "%" sign from the query, I get the correct 30 records returned from all 3 databases.
Why should I get different results? I know this is a bug in my usage, but I don't see any settings that would effect this. Is there differences in the SQL allowed over the network?