Bug with negate operator in REGEX searches?

I have a Text field (user1) in which two records have an entry. One has a colon in the text and one does not. If I search for the one with a colon with REGEX it works: select * from thereferences where user1 Regex '[:]' -> 1 hit But wh...

VStudio SQL Editor Parameters not functioning

I have downloaded VStudioPro 8.6 and tried to use the new useful Parameters feature in the SQL Editor window. But unfortunately I always get from MySql a syntax error just around the parameter (see screenshot). My query looks like: SELECT * FROM t...

Dynamic parameters in SQL (V Studio)

How do I specify values for dynamic parameters in the SQL Editor of Valentina Studio? I would like to test a SQL statement such as: SELECT field1 FROM table WHERE field2 = :1 I get error 0x7004. Using clause required for dynamic parameters....

VException 626688 "Unknown"

I've got a set of test data that I use all the time to add to a database. Consider me totally astonished when I got a VException when adding one record of this test data to Valentina server: 'make blank cursor theCursor.Field("MainSubject&qu...

Adding Page to Report

Hi, I am developing a report that displays a government form. The form is placed on the page as an image and the database fields are placed on the image in the appropriate places. It works fine. Here's the question: The last page of the form c...

SQL Editor CTRL + SHIFT + Z Redo shortcut not working some time

Hi, I noticed that when i create a new SQl Editor, the CTRL + SHIFT + Z Redo shortcut does not work sometime. It will only work a while after I select the Redo from the menu, and then stop working again after i switch to another SQL Editor tab an...

Valentina Release 8.6.6 Improves, Fixes Database & Reporting Solutions

Paradigma Software Valentina Release 8.6.6 is a fix update for 8.6.x products with improvements for Valentina Studio, Valentina Server and others. Valentina Studio / Studio Pro Valentina Studio is the free, all purpose database management and for...

importing CSV data that is updated frequently

I come from Access. Relied heavily on its graphical interface to do things. I am in the process of transferring my databases over to SQLite, using Valentina Studio Pro. One of my Access databases includes a link to a CSV file, that gets update...

Very Alarming News for MySQL 5.6 and MySQL 5.7.x for MacOS 10.12 Sierra Users

We keep up with our compatibility of products with MySQL on all platforms (Valentina Server, Valentina Reports, Valentina Studio), but I came across this, this morning, over on Macintouch: Short form... There is no macOS version of MySQL 5.6....

pb of default column type while a dump

Hi, i was a happy heidsql windwos user but i deicded to level up to linux, i found valentina as an alternative and i have to say that it's cool. but when i made a dump of a database, instead of default column type, valentina give me double 22,0 and t...

1) Function browser disappeared in SQL Editor window 2) SQL Editing Color Scheme not functioning

I have just upgraded my old Valentina Studio Pro 7.0.4 to the new version 8.6.3. All works fine but I noted two disappointing differences: 1) In the SQL Editor window the option "fx Functions..." (located in the top right corner before &qu...

Journal file not deleted

I've got a single customer whose journal file isn't deleted when quitting. Here is my code try theDatabase.Close theDatabase = nil catch err as VException if err.ErrorNumber = 394507 then 'just ignore end if ...

Getting user information

I want to partially duplicate the user information screen from Valentina Studio. With my app and with Valentina Studio I'm logged in as "sa" and as "trixi" (both admins): There is an example called "ValentinaServerUtil...

Using RequiresEncryptionKey

How do I use RequiresEncryptionKey? I have successfully encrypted a database with theDatabase.Encrypt(Password, EVDataKind.kRecordsOnly) When I try to open the database I always get false for RequiresEncryptionKey . To be sure I tried w...

Ask us anything about Valentina Developer Network licensing in the 6.x era

We made a lot of changes and simplifications to the licensing of Valentina Server under Valentina Developer Network, but we think you'll have questions about it, especially if you are a long time VDN customer. Please use this thread to ask questions ...

Currency format without decimals.

Hi. The currency format does not show decimals. ejmplo: 4.15 you see how 4.00 € Instead of seeing 15 shows 00 How can it be solved without putting a pattern on all the fields? Or can you create a standard pattern that replaces the one of cur...

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

Valentina Release 8.6.3 Improves ValentinaDB on Linux; Other Improvements

Paradigma Software Valentina Release 8.6.3 fixes several issues reported by the Valentina developer community. Valentina Studio / Studio Pro Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro...

Valentina Database & Data Management Tools at Better Pricing and Availability for Students, Instructors & Researchers

Paradigma Software Valentina tools help students, instructors and researchers transform their projects into college and career possibilities. Valentina Studio Pro and Valentina Server are now available for qualified academics at new, lower flat rate ...

Google+ is the Walking Dead

It shouldn't be news to you that Google+ is going to be killed, much like other Google social media venues (remember Google Buzz?). If you hate Facebook, we have an alternative now with a new group set up on MeWe. They promise quite a bit in regards ...


There are no discussions available here currently
  1. Posts: 922
  2. Resolved Posts: 0
  3. Unresolved Posts: 872
  4. Latest Member: Nurşah Kara
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories