Kenneth Kemp Geschrieben in:

query modifications

I created a query using the Valentina Studio Pro graphical interface. In the SQL Editor I tweaked the Where statement of the generated SQL query. The query works, but I can't figure out how to save it either back to the original or to a new query. ...
marko Geschrieben in:

Valentina with FirebirdSQL

Has anyone used valentina studio to design firebirdSQL databases? I have an application that will used embedded local firebird engine as I need more than SQLite. Can I connect and push sql to create tables via the ODBC connection? Another option ...
Lynn Fredricks Geschrieben in:

Video: Adding a Table of Contents to a Valentina Report

You may have missed it but we uploaded a video to Youtube showing how to add a table of contents to the example Reports project for the Sakila database. Check it out here....

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...
Dale Geschrieben in:

Lost My License of VStudio Pro

I have a Visual Studio Pro v8 license. I downloaded and installed the latest version for evaluation purposes then I removed the newly installed several days after. My VStudio 8 license doesn't work now....
John Willems Geschrieben 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...

Xojo ADK Reporto to CSV

Hi I have some reports working perfects on Xojo, but i need to send reports data to CSV, can this be done or no. thanks...

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

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


Hier sind keine Themen vorhanden
  1. Posts: 1724
  2. Resolved Posts: 0
  3. Unresolved Posts: 1654
  4. Neueste Mitglieder: Michael O'Neill
Online Members

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories