Hello,
just started yesterday evaluating ValentinaDb with the target of connecting many users to a SQLite database by ODBC driver.
I'd like to point out that vodbc_x64_13_win.exe installs vodbc*.dll in the wrong folder (SysWOW64, should be used for...
In working with the Document Generator in current the version, it appears to not work (limited) with MS SQL server. It only generates limited info for the first table in the database. Effectively one page.
When in MySQL it appears to generate all...
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...
For my server solution I'm using an SQLite database with an FTS table to search in emails. Now and then SQLite loses connection before Valentina Server. Then there is no error message. The code is really simple:
try
dim thePreparedStateme...
Environment:
- installed a licensed instance of Valentina Server (Windows pc 192.1.1.202, unmodified standard parameters)
- put a SQLite db UTF16LE in the appropriate folder
- installed Valentina Studio on Client1 (Windows): VStudio connects to VS...
New table of contents generation, scripting, editing, methods, properties and more.
A major new feature to all Valentina products incorporating the Valentina Reports Engine is table of contents generation. This update includes HTML reports TOC wit...
I'm using this expression to calculate date intervals (e.g. to find all records entered within the last 2 weeks):
dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (14 * 24 * 60 * 60)
However, it works in some locales but not ...
Hi Everyone!
I wanted to use the Tool "Data Transfer" to copy/synchronize the data of a specific table to the same table of another database.
With all entries transferred: Empty cells are wrongly transferred as <null>!
These cell...
Following the discussion at https://valentina-db.com/en/discussions/9968-improve-speed-of-sql-query I made a new field and a trigger to get a faster performance.
The final piece is to update existing data to the new field. I can select "PathS...
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 ...
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 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 ...
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...