Moving from SQLite to Valentina Server SQLite

I’m migrating my existing project in Xojo (2019 3.2) and my existing SQLite database (1 table, and 1 virtual table created with FTS5 to use full search) and some triggers to make stay in sync the 2 tables, in Valentina SQLiteServer. I’m now on my MB...
Roger カテゴリ:

report with the false pictures in his records

Hello I make a simple report in Studio and then select * from my table. On the report I use a data field and a picture field declared as field from this table. Now you can see in the hardcopy, the records are different but the picture is eve...

install_vcomponents_v4rb_v7 no longer works because of file name change

I downloaded and installed the latest ADK for Xojo, 10.4.18. I am still using install_vcomponents_v4rb_v7 for deployment but now I get this error: cp: /usr/local/lib/vcomponents_x64/libv8_64.dylib: No such file or directory I then went here: h...

Anybody have a WANTED FEATURE for Valentina Reports? (or fix?)

Hi All, Do you dream about adding a feature to Valentina Reports that would help improve your solutions? Some irritating bug got you down that you'd like us to prioritize? We are listening. How can we make Valentina Reports better?...
Roger カテゴリ:

Lost Font

Hello My project is a single project file, the font in the report is Frutiger, a TTF font legal buyed by Linotype. I print a pdf with Xojo, and report ADK the report an all are happy. All is perfect (see in the hardcopy). Now I copy this proje...

correct way to unlock a crursor

Hello I use serversidecursor in readwrite mode, then the record is locked in the table so far all works ok. But then I use other function (like a report) but the cursor is with all i tried not really unlocked. What is the best/correct way to u...

2 scenarios; the same error

Hello Scenario1: My own Vserver OEM created. It run as service and all shows perfect. Tried with different ports (rebooted), local, standard user and password. License is in the license folder. Connect with my programm. And I have the Error x820...

case sensitive select

Hello I try to select caseinsensitve. (Enter hello and find Hello) I used Call db.SqlExecute("SET PROPERTY IdentsCaseSensitive OF DATABASE TO True" And I see the change in the database properties. I tried to set False too. (restartet t...

Understand RecId

Hello When I have an existing db with 2 tables person - phones. In relation 1:n (a phone can have only 1 user in this example). In this db the conection is with primary keys, comun. So far so good. Now, if I try with Valentina and the idea from...

Example named Field_Picture

Hello In this (your) example all runs fine, only I have no pictures in the API_Field_Picture.vdb. I see in the debuger, I have the 3 pictures, all comands are done inclusive the flush. At end I have the db with the table and the field but all f...

Valentina Constants are unknow

I hope my last question in this week Constans like kServerSideCursor, kReadWrite are unknow. In the help I cannot see where I need to serach them. Xojo ADK 10.4.18 on Windows 64 Regards Roger...

Valentnina correct way for sql select with parameter

Hello I try a simple select with a parameter like a preparedStatemanet like this with the result in a vCursor. stmt = db.CreateSqlStatement( "Select ** FROM myTable WHERE RecID = :1" ) stmt.Bind_UInt32(0, aRecIDVariable) VSqlStatement is ...
Roger カテゴリ:

Setup files for embedded server searching

Hello I try to create a setup for the embeded server. Inno Setup is installed but now I have not the files (i see in your script) to include its. Where are this? For example ..\..\sources\Install\EULA_VSERVER.txt The setup not use parts from the O...

vSet, vTable, Fields

Hello I Try the API_way with Xojo. From your help "Many API methods of Valentina DB return such set, e.g. VField.FindValue() or VTable. Table.SelectAllRecords()." Now I have my sortet vSet but I can only grab the fields from the tabl...

Can't get labels to be the correct width

I'm still using the Valentina Studio demo (v10.4.18 on MacOS 10.15.6) to see if it's going to work for my needs before I purchase it. I'm trying to create simple labels from a SQLite Database. The database and query are working fine, but I can't g...

Hard to filter databases, tables and fields

First of all, I love Valentina Studio, I tried lots of software but no one like valentina, i'm very thankfull to Paradigma's work. But, I'm stucked at version 5.7.5 Yes, you get shocked because the current version is 10.0! I tried some new ve...
Kevin カテゴリ:

Views in Forms

Studio Pro 10.4.12 SQLite Windows 10 I created a View. During the process of creating a form based on the View, the View is present, I can select the View; however, none of the fields in the View appear in Available Fields to select. Thus, I c...

Valentina 10.4.18 Improves Forms Editor, Reports

Also provides improvements working with MySQL and MS SQL Server and more. Valentina Studio / Valentina Studio Pro Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database manageme...
Kevin カテゴリ:

Opening a Parent-Child Table Form from Another Form

I created a navigation form: a form that isn't tied to a database, filled with buttons that open other forms. One of these buttons opens a parent-child table form similar to the Lesson 2 form:

Select multiple rows in forms for batch operations?

Hello, We are exploring ways to perform batch operations on multiple selected rows in tables that we display in our forms. In the screenshot, a form displays a view containing a list of "observations". We want to be able to select one...

  1. Posts: 1376
  2. Resolved Posts: 0
  3. Unresolved Posts: 1314
  4. 最新の登録メンバ: Samuel Chenot
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