Rocky Scofield Geschrieben in:

Single column lookup within report

Hello. I am using VStudio Pro 11.3.1 (64 bit). I have a report where I would like to use a SQL query to do a single column lookup from a table that is not in the original query defined for the report. I have an id column in my report query. Usi...
Mauricio Pulla Geschrieben in:

Avoid special characters in printing

Hello. In a program made in Xojo, I paste information from an excel sheet and save it in Postgres 9.6. When I add that information to the report, it prints special characters. How to avoid special characters in printing....

How to display an image from database for Valentina Report

How to display an image from database with filename example 12345.png stored as text in sqlite3 database and the actual image is stored in the working directory named "img/" as filepath. I need assistance. Thank you in advance....

Getting table size

Is there a possibility to get the table size for a database? I can get the number of records for each table with SQL select fld_name, fld_record_count from (show tables) where fld_kind = 0 But I don't see a way to get the size of all tables. ...
Rocky Scofield Geschrieben in:

DB field column not wrapping

I am using VStudio 11.3.1 (64bit). I have a report that needs to sometimes wrap the text string that is coming from a database field when the column width is not wide enough. I have modified the field parameters can_grow = true and wrap_text = tru...

Valentina Release 12.5.9 Improves Valentina Studio SQL Editor

Expanded recognition, suggestions based on reserved and key words. This update focuses on technologies first implemented in Valentina Studio 9.6 which enable highly productive search and auto-completion functionality. Valentina Studio FREE | Singl...

When computer is stoped/restarted, vserver doesn't close properly the database

When the server computer is stoped or restarted, it seems vserver doesn't close properly the database : the .journal database file is still there. The problem is that when I want open again my database (after the restart), VDatabase.IsJournaled = Fal...
Ben Antwi Geschrieben in:

How to call a variable's value in Valentina Report

Is it possible to pass value of a variable to Valentina Report? Example item_no = 10 which is not from database but it's just a variable in a python script. Will item_no be referenced as a text field in report editor of Valentina Studio?...

"Dynamic SQL error" again

Hi guys, I've got 3-4 reports with corrupt databases in the last week. All of them show a "Dynamic SQL error": 2022-09-15 16:12:30 ArchiveThread.Archive done 2022-09-15 16:12:30 ArchiveThread.ToTrash 2022-09-15 16:12:30 no move to t...

Generating dynamic python report using valentina Pro 12

Valentina is a great reporting tool but I'm still finding it difficult to search a record from sqlite database with python. Please I need help...

Valentina Release 12.5.8 Improves Studio SQL Editor

Includes modest improvements for PostgreSQL, Data Editor 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 management w...

Valentina Release 12.5.7 Supports MS SQL Server 2022

Includes fixes, improvements for Valentina Studio, ValentinaDB and Valentina Server. Valentina Studio FREE | Single | PRO Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database ...

Valentina Release 12.5.6 Improves Studio, ADKs, ValentinaDB

Includes modest improvements to Python ADK, MS SQL Support 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 diagrammin...

Working with SQL Server 2022 Preview? Valentina Studio is Ready

Microsoft SQL Server 2022 preview edition became available in May 2022, and so far our testing with Valentina Studio and Valentina Studio Pro is looking good. If you have any feedback on working with the preview, we'd like to hear from you. Studio...

Why does numeric collation mean tertiary strength?

Using some simple example database: // We will keep db in the 4 disk files mDataBase.Create( f, 4, 32 * 1024 ) mDataBase.CollationAttribute(EVColAttribute.kStrength) = EVColAttributeValue.kSecondary mDataBase.CollationAttribute(EVColAttribu...

Omegabundle for Xojo 2022 Developer Tools Bundle Now Available

Get the top developer tools and third party components for the Xojo cross-platform development platform at a huge savings Omegabundle for Xojo 2022 is a collection of the most useful tool sets, add-ons, digital books and components for use with Xo...

Valentina Release 12.5.5 Improves MySQL Database Management

Also adds MariaDB keywords, MS SQL Server improvements, Python support, BLOB optimization in ValentinaDB Valentina Studio FREE | Single | PRO Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pr...

Valentina Release 12.5.4 adds JS summaries to Reports, improves Data Editor

Improves backwards compatibility for Xojo apps on Linux, MySQL queries in Studio Valentina Studio FREE | Single | PRO Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database manage...

Executing stop and start scripts

Many moons ago I started with my own version of Valentina Server. These days I finally finished the installer. There is one remaining problem. I want to use slightly different start_me.sh and stop_me.sh scripts so that I can use them from the Xojo...
Scott Geschrieben in:

VStudio Date entry

This is mostly just me whining - I do alot of data entry directly thru VStudio. When entering a new record - a date field requires the YYYY-MM-DD entry format before the record is committed. Editing an existing record - the date format is n...


Hier sind keine Themen vorhanden
  1. Posts: 1606
  2. Resolved Posts: 0
  3. Unresolved Posts: 1540
  4. Neueste Mitglieder: Anani Koumadi
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