Binding SQL injection and using % in the WHERE

Hi, I'm finally moving over to binding, and so far so good. But how do I get the % to work... I have F1 LIKE '%"+textinput+"%' and F1 LIKE :1 and also F1 ILIKE :1 works... But how do I use % with values ? F1 LIKE '%':1 d...
Dale カテゴリ:

Xojo cannot deter Valentina plug-in

I got a new laptop and I installed valentina plug-in for Xojo (see screenshot 1) but Xojo cannot detect Valentina object (see screenshots 2 & 3) but in my old laptop, it is perfectly working....

Use .pgpass file as source of DB connections

Hi! Does Valentina Studio has any possibilities to list defined connections of PostgreSQL databases from .pgpass file? Basically it would be very valuable when I could keep configuration for all database connections in one place and just set the t...

Merry Christmas 2019 from Paradigma Software

The Valentina Team would like to wish our customers, clients, partners and their families a warm and very Merry Christmas! PS: Don't forget you can track Santa on December 24-25 as he flies around the world on NORAD Tracks Santa!...

Reporting for Xojo: Data Driven Reports in Apps, Client-Server & Web

Paradigma Software introduces a complete solution for deploying Xojo apps on macOS, Windows, Linux and Raspberry PI with comprehensive reporting features. Reporting for Xojo bundles together several professional solutions that extend Xojo with advanc...
Giedrius カテゴリ:

Why is Cardinality greyed out in the last few versions of Valentina Studio?

I the free version previously I could create links and choose Cardinality, but for the last few month I can only do that manually, because UI has greyed out Cardinality options and it is only One to One. Is this a new restriction or issue? Using ...

Valentina Release 9.7.4 fixes, improves Valentina Studio and Valentina DB Products

This release provides fixes to issues raised since the last release and also improves the SQL REPAIR command. Valentina Studio Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines databa...

How to connect to sqlite server on raspberry pi from desktop app using XOJO

Hi How to connect on a local network to sqlite server on raspberry pi from xojo...
John Gold カテゴリ:

Generate SQL wrong field order

Hey, when I use the "Generate SQL -> Create/Drop/Insert/..." feature in the Schema Editor, the order of the fields is incorrect. It is not in the order of the field position and cannot be sorted otherwise. So if the first field is &qu...
Abeer カテゴリ:

How long to get the serial

How long does it take to get the serial number after buying the Valentina Studio Pro?...

Valentina Release 9.7.3 Improves Management of MySQL, PostgreSQL Databases, Xojo Update

Improvements to Valentina Studio for macOS users, working with MySQL and PostgreSQL databases, Xojo updates. Valentina Studio / Valentina Studio Pro Valentina Studio is the free, all purpose database management and forms client tool. Valentina St...
Alberto カテゴリ:

Export content from Valentina 1.x dbs

Hi everyone, I've been recently asked to export a collection of newspaper articles stored within a series of old Valentina dbs - all created in 2000. I tried to open them using Valentina Studio 3.0 but with no luck... the utility function for convert...


Hello, I'm trying to setup a datasource using a parameter as table name without success. example SELECT * FROM $P(param7) where ID_PRESSUPOST = $P(param9) ORDER BY LINIA I don't know the reason why using parameter as table name fails,...

DELIMITER keyword throws Kernel error when using MySQL/MariaDB

Hi! I kinda used some basic SQL for some time, but now I'm studying it a bit more, and I'm using Valentina as my main learning tool. I've been having some problems whenever I use the DELIMITER keyword or import any *.sql file that includes that...

Failed to load plugin v4rb_x64.dll

My customers get a 'Failed to load plugin v4rb_x64.dll' error when trying to open my app. I build that app with Xojo 2018r2.0, V4RB_8.2.0 and the error is (right now) on Windows 10. My Innosetup script use this command to install V4RB: Sourc...

XOJO crash while debugging VDatabase object

Cause of an issue in an XOJO application I am trying to debug the code. In the XOJO debugger, I can click the link to see the info about VConnection and folder item (db file) but not the VDatabase – XOJO crashes. I can get a Table of this VDatabs...

Valentina Release 9.7.2 Updates Valentina Studio Pro, Valentina DB

This is an update release providing fixes and improvements to Valentina Studio, Valentina Studio Pro and all Valentina DB based products. Valentina Studio Valentina Studio is the free, all purpose database management and forms client tool. Valent...

Copying reports between vrp files

Hello, Is there any way to copy a report from another vrp file ? Thank you...

getting values from a field

Helo, I want to get the value from a column and set into a label in then header pre-place I put this sniped var value = report.cursor.columnValue( "NOM_COMERCIAL1" ); report.controls.test.label = value; should it work ? ...

How i duplicate a Reports

How i can duplicate one report so i can modify and save with other name...

  1. Posts: 1240
  2. Resolved Posts: 0
  3. Unresolved Posts: 1180
  4. 最新の登録メンバ: David
Online Members


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