Improvements for compatibility with MS SQL Server, ODBC support and more.
Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management ...
I am new to Valentina Studio Pro. I have a connection to a MS SQLServer database. However, VS is not showing me the schema. I can query data, but not see the schema. Since this is important to my dev workflow how do I make it visible.
I can see ...
I have a seemingly simple SQL query:
select RecID, MailboxPath, WhereClause, PathSort(MailboxPathNatSort) from mailbox order by 4
For thousands of records the query is quite slow. The problem are PathSort and the order.
MailboxPathNatSort is...
I recently got a message that I needed to go to the store and receive a new serial. I did so, selected Valentina Studio Free, proceeded to checkout, clicked finish and got the serial. When I try to put it in I get a message that it is an invalid se...
After installing rpm in Fedora 39, Valentina studio doesn't start, if tried to be invoked from command line the following error happens:
/opt/VStudio/vstudio: error while loading shared libraries: libbz2.so.1.0: cannot open shared object file: No ...
At the moment, only DBeaver allows you to work with this excellent DB from the GUI.
It turned out to connect to DuckDB via ODBC in the environment VStudio 13.6.1(x64) Windows 11(x64)
Download the nightly build of duckdb/v0.9.3-dev1100(windows_amd...
Short story:
The latest version of vstudio seems to have a bug: It's crashing while trying to read the "App" documentation in a script tab of a project.
Steps to reproduce the crash:
Open a project
Create/Open a script
On the top lef...
I've been putting off updating to a new version of Valentina for almost 2 years because they weren't backward compatible with the one I was using. It's a big deal when you have many thousands of users. I'm finally about to release a version using 13....
Recognizes potential foreign keys based on field names using regular expression patterns.
Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines data...
Is there a way to configure a connection through ssh through another host? I can setup a direct connection to a db server through ssh but I need to connect to a different server first from where I'm allowed to ssh into the database host.
I'm looki...
PHP 8.3 support for Valentina PHP ADKs and Valentina Server, new SQL functions for ValentinaDB & more.
Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio ...
Hi,
I need to order a cursor so the result is the same as in a sorted listbox (which can be sorted many different ways).
The solution I found online was to use a CASE statement with ORDER BY. Such as
select * from table
order by (
case...
Hello!
I'm currently working on a SQLite database.
I just noticed, that I can't change the value of a boolean field in the editor!
Is there a reason for that or is this a bug?
(Working with Valentina Studio Pro)...
Also additional productivity improvements to Valentina Studio and ValentinaDB
Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database managem...
I upgraded to 13.7 from 13.5 and now I am getting an error when connecting via SSL to a remote Postgre database. The error is :sslmode value "require" invalid when SSL support is not compiled in. Any ideas?...
PostgreSQL compatibility, updates to Valentina.NET examples.
Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramm...
According to the docs I can drop an index by using:
DROP INDEX index_name ON table_name
But what are the names of the indexes? How can I drop the indexes for a complete table?...