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...

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 ...

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...

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...

Checking on VPHP for 8.3.x

Any timeline for VPHP for 8.3.x? Thx...

Valentina Release 13.8.1 adds Data Editor options to Studio and more

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 ...

Sort cursor by arbitrary order

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...

Cannot change value of boolean field in editor

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)...

Valentina Release 13.8 Adds Foreign Key Value Editor to Valentina Studio

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...

Error connecting remotely to PostgreSQL Database using SSL with version 13.7

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?...

Valentina Release 13.7.1 Improves Studio Editors, PostgreSQL Support

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...

What are the index names when dropping indexes?

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?...

Happy New Year 2024 from Paradigma Software

The Paradigma Software team wishes our colleagues, partners and friends a very Happy New Year 2024!...

Valentina Release 13.6 Adds Python Queries & Expressions to Reports, Improves MongoDB Support

Studio improved SQL & Schema Editors, SQLite support and more. Valentina Reports ADK & Valentina Reports Server Valentina Reports cross platform reports system is available in Valentina Reports Server, Valentina Reports ADK for embedding ...

Retrieving deleted data

Is there a way to retrieve deleted data? A user deleted all data from a database by mistake. Of course, he doesn't have a backup. The database is a big one with 36 GB....


There are no discussions available here currently
  1. Posts: 1709
  2. Resolved Posts: 0
  3. Unresolved Posts: 1639
  4. Latest Member: andika suprayogi
Online Members