I try to select caseinsensitve. (Enter hello and find Hello)
I used Call db.SqlExecute("SET PROPERTY IdentsCaseSensitive OF DATABASE TO True" And I see the change in the database properties. I tried to set False too. (restartet t...
I try a simple select with a parameter like a preparedStatemanet like this with the result in a vCursor.
stmt = db.CreateSqlStatement( "Select ** FROM myTable WHERE RecID = :1" )
VSqlStatement is ...
I Try the API_way with Xojo.
From your help "Many API methods of Valentina DB return such set, e.g. VField.FindValue() or VTable. Table.SelectAllRecords()."
Now I have my sortet vSet but I can only grab the fields from the tabl...
One of my users had the idea to make a server database with a dot in the name. That doesn't seem to be a good idea.
Valentina Studio shows the database with a red icon. The example ValentinaServerUtility shows the name as "mail.vdb" and ...
Continuing the discussion from https://www.valentina-db.com/de/discussions/7458-transactions-committing-to-vsqlite .
I found my problem and - yes - I was totally stupid. Ahem, I had assumed that CreateDatabaseFileEx() simply opens a database if it...
I have a web app stored in the cloud. If I issue mReport.PrintToLocalPrinter(), whose local will it print on, on the server or on the client? At first, I thought on the client so I made an option that if a user wants to print directly on his/h...
I have the following MySQL Schemas:
They have the same tables and corresponding structures. I have a report that calls a stored procedure that pulls the data for the report. I designed my report using ...
I get it, it's been trending from "linux" to all systems/devices for last 4-5 years. honestly don't know what's the hype about.
however, I hope I just missed it in the settings. Can some one point me to setting so I can have non dark mode ...
When I change the example everything works fine, but in my code only the database is created and not the table. What am I doing wrong?
Private Sub ConnectToDatabaseRemote()
remote_db = new VSqliteDataBase
dim options as string //ge...
Hi, I have tried to install "ADK for PHP" on MacOS by following the instructions on the website. All goes well until I try to start PHP on my Mac when I get the following error. What am I doing wrong? Thanks
PHP Warning: PHP Startup: Un...
I'm trying to use Valentina Studio as a new frontend for an existing MySQL database with about 100.000 records. The 10 minutes introduction video helped me a lot.
When trying to create a link in the database diagram I got an error message. I...
I have a report with a subreport. = Report 1.jpg
When I preview the report the first page works fine, but then elements of the report randomly doesn't print. Shown Report Page 1 and Report Page 2.
I'm trying to figure out what would cause this....
I'm trying to do a union but I can't get the order correct.
The table is simple: Mailboxpath, Username are the main fields. The table has a custom sort so that the records sort like
I'm showing the ...