Discussions tagged DB_Valentina

Large table very slow to open

I've run into a puzzling problem that still exists in 12.7. I have two tables in my database that can have thousands of records. For the first, even with 50K+ it opens quickly. But for the other, with 18K records it takes 1-2 minutes to open when thi...

XOJO 2021 Release 2.1 Binary link using ADK/API

I have a hard time creating the correct code to establishing the Binarylink between record 1 for table A with records 2, 3 etc from table A. There are no XOJO examples. I am able to set the link between record X from Table A with Record Y from ...

Export a lot of jpg from Valentina db

Hello Is it possible to export a selected lot of pictures (saved in picture fields in Valentina db) with Studio? The Excel Export from all not helps because the images are very, very small in the table and as i see I cannot select the range. Fo...

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

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

Importing JSONB Data from CSV to PostGres?

I would like to import data to a jsonb field from a csv. I've tried things like: "stripes":true, "solids":true "stripes:true", "solids:true" {"stripes":true, "solids":true} ...etc., but I get an error when trying to import to a jsonb fiel...

How do I support the UUID type in my DB so that when I export its used as the correct type in postgresql?

I am trying to use the PostgreSQL uuid type in my database, and I notice that despite wide support for it and the actual intention for me to use it in my end database, its missing from the type list in the pulldown menu. I'm not sure what to do as at...

A sincere thank you - Multiple page orientation in VReports

I just had to take a minute and express my thanks to the developer team. A few weeks ago I asked if it would be possible to change page orientation on the fly in my reports and I was amazed they listened to my request and in no time at all the releas...

I have sade VSDK_64 version 5.7

Way are you not reading my mail I sade: I have downloaded VSDK_x64_5 and fixed the compiling problem. vcomponents folder is ended _x64 and in the xcode project is the Search Paths is vcomponents without _x64....

'TickCount' is deprecated: first deprecated in OS X 10.8

TickCount is deprecated 10.8. Of course you know that the Tickcount rolls over in approximately 2 years 3 months....

Binary Links

I am developing a DB using the Binary Link method. In VStudio its very easy to establish the links. But I need to insert data from my web app thru PHP to multiple tables using the Binary Link method and cannot figure it out. I searched the Valen...

Methods - Valentina Studio

I have created a table with 55 fields and 46 methods. Only the fields show on the table view of the data. The methods do not show. in the past versions of Valentina Studio both the fields and methods showed in the table view. I am running the lat...
  • Page :
  • 1