John Willems
In
MS SQL Server - Documentation Generator not working
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...
Regarding the use of DuckDB inside Valentina Studio
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...
Errors deploying x64 ODBC driver v13
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...
No error message when losing connection to SQLite server
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...
ODBC connection to Valentina Server 13 +SQLite db not working
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...
Valentina Release 13.10 Extends Valentina Reports, ADK & Reports Server
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...
Problem calculating date differences in different locales
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 ...
Data Transfer creates null-entries when source is empty
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...
Kernel error on simple update query
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...
John Willems
In
MS SQL Server issue, schema is not showing in VS
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 ...
Valentina Release 13.9.1 Extends Virtual Links, Improves Java, Xojo ADKs
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 ...
Improve speed of SQL query
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...
Rob Rutledge
In
New Serial not working
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...
no working on win11
HI
i am using xojo 2019r3 for compiler to win11 and the ADK is no working.
i am using Valentina Studio Pro 9.8
thanks...
Valentina studio doesn't work in Fedora 39
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 ...
Valentina Studio 13.9 crashes while selecting the App Class documentation entry
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...
Backward compatibility
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....
Valentina Release 13.9 adds powerful Virtual Links feature to Studio PRO
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...
Connection through ssh through a relay server
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...
There are no discussions available here currently
- 1719
- 0
- 1649
- Ido Tal
Online Members
