Lynn Fredricks
Geschrieben in:
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 ...
Jonathan Ashwell
Geschrieben in:
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...
Stefan Kieninger
Geschrieben in:
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)...
Lynn Fredricks
Geschrieben in:
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...
Brandon Warlick
Geschrieben in:
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?...
Lynn Fredricks
Geschrieben in:
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...
Beatrix Willius
Geschrieben in:
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?...
Lynn Fredricks
Geschrieben in:
Happy New Year 2024 from Paradigma Software
The Paradigma Software team wishes our colleagues, partners and friends a very Happy New Year 2024!...
Lynn Fredricks
Geschrieben in:
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 ...
Beatrix Willius
Geschrieben in:
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....
Beatrix Willius
Geschrieben in:
Query too slow - bug or stupidity
Got a really weird problem with a query for Valentina Server 13.6.
Tables are mailbox for mailboxes, message for emails. The basic query gets information from the mailbox and the message table. Usually only one mailbox is shown with a where clause...
Lynn Fredricks
Geschrieben in:
Valentina Release 13.7 Improves SQLite Support, New JavaScript Feature for Reports
Other productivity improvements including better, human readable crash logs 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...
Karen Atkocius
Geschrieben in:
Bug in Valentina Studio?
Apparently one can not use Mantis unless on is using a paid version ... Oh well
In any case I was using the current version of Studio (13.6.1) on macOS 12.7.2 with PostgreSQL version 15 . When I tried to execute the the following statement from V...
Lynn Fredricks
Geschrieben in:
How to: Create a Master-Detail Report using Valentina Reports and MongoDB
Take a look at how to use the Valentina Reports SubReport control to create a master-detail report using MongoDB and Valentina Reports. You will learn how to query MongoDB databases using JSON and JavaScript queries to get data for the report and the...
Scott
Geschrieben in:
Can't Open/Edit Reports on Remote Servers
I can't say that it was the 13.6 upgrade, because I haven't edited any of my reports in a while. But, I tried to open existing reports on several remote servers (even a local LAN server) and it errors out. I cannot connect to the report side of VSer...
Beatrix Willius
Geschrieben in:
Changing Server property "SystemFolder"
In the manual there is a short description on how to move the server property "SystemFolder" to a new directory:
The path to a folder where will be stored databases managed by Valentina Server.
If you change it, you should copy/move e...
Beatrix Willius
Geschrieben in:
Valentina ADK 13.6 Codesign problems?
I should have tested Valentina 13.6 on Sonoma, too. What does the attached error message want to tell me?...
Lynn Fredricks
Geschrieben in:
Valentina Release 13.6.1 improves Valentina Studio, ValentinaDB
Enhancements and fixes for SSH, Project file management.
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 diagramming,...
Tyler
Geschrieben in:
Using DuckDB inside Valentina Studio
Can you add support for DuckDB files? DuckDB is to OLAP databases what SQLite3 is to OLTP databases.
I am just starting to use DuckDB in some Data Warehouse processing projects and I'd love to be able to open those DuckDB files directly in Val...
Vladimir Esipov
Geschrieben in:
About the cross-database query
The WIKI for the release of VDB 12 announced a new feature - a connection between two databases.
Can you explain in more detail - what do you mean?
MySQL/MariaDB allows you to execute a query like:
SELECT T1.fld1, T2.fld2
FROM DB1....
Hier sind keine Themen vorhanden
- 1719
- 0
- 1649
- Madumal Perera
Online Members
