JSON functions question

I am new to JSON, so I'm not sure if this is a bug or an error on my part. I am using Valentina Studio 8.3.5. I am attempting to use a JSON string in a stored procedure. The following code does not produce the string that I expect to see. ...

DATETRUNC question

I need clarification on the DATETRUNC function. The example in the documentation shows: SET PROPERTY DateTimeFormat OF DATABASE TO 'kYMD'; SET PROPERTY DateSeparator OF DATABASE TO '-'; SELECT DATETRUNC( '1997-10-23 15:16:10', 'day' ) =&g...

Omegabundle for Xojo 2018 Developer Tools Bundle Announced; Save 89% on Top Tools

Get the top developer tools and third party components for the Xojo cross-platform development platform for a limited time for over 89% savings. Omegbundle for Xojo 2018 is a collection of 13 (122+ individual items!) of the most useful tool sets, ...

Using temporary tables in stored procedures/functions

Is it possible to use temporary tables in stored procedures/functions? When I try to execute the following, I receive Kernel error 0x70503. Table "house_rooms" not found. I have attached a sample database to which I'm attempting to add t...

Support for MySql versions older than 5.0.6

I'm currently using Valentina Studio 7.4 in an Ubuntu linux and I'm trying to connect to an older mysql server database (older than 5.0.6). I still don't know the server version but if I try to connect with this version of VStudio, I get the error th...

Pie Chart?

Hi, I have a query that is returning data for a Boxes type chart but when I switch over to pie charts, the example disappears and nothing is generated with the report at all. Also where is the documentation that details how to customize the label...

Table checks involving links

Is it possible to create a check constraint for a table that references a link? I have a 1:M binary link between two tables and would like a field in the child table to be unique within the parent record (it does not need to be unique within the tabl...

Can I drop a primary key in SQL Editor?

Hi everyone, I am unable to drop / recreate a single PK using SQL Editor. Here's a simple test case: CREATE TABLE "public"."parent2" ( "parent_pk2" Integer NOT NULL, "field_ref1" Integer, "fie...

Run Valentina Reports on Python

Hi Can Valentina Reports ADK works on Python. i am going to move from XOJO to Python. Any idea about this...

Valentina Release 8.3.5 Improves Performance in Valentina DB, Server, Studio and PostgreSQL Schema Snapshots

Paradigma Software Valentina 8.3.5 improves performance and adds fixes based on customer feedback. Valentina Studio / Studio Pro [Imp][ValentinaDB] - The default value property of the ARRAY field now can be modified using the array editor (in t...

Using a date field in the ORDER BY clause of an SQL statement

I am attempting to sort query results based on a date/time field; however, the results do not sort as expected. I have attached an SQL file with a dump of the table along with a screenshot with my query and its results (from the SQL Editor tool). ...

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

Access to SQLite - Date and DateTime

I am in the process of moving my Access databases to SQLite. My database capabilities are basic to maybe just above basic. I have been reading about SQLite. I will need to reformat my date data before I import the data into the SQLite table. I wi...

Happy Independence Day 2018, America!

The Paradigma Software team as well as our partner vendors on Omegabundle for Xojo 2018 which you a happy Independence Day for 2018. We hope you enjoy your day with your families and noshing on whatever makes you happy (in the case of our USA team...

Issue with SqlExecute when creating both functions and procedures

I am working in LiveCode and am using V4REV 8.3.3. I have been using the SQLDiff tool in Visual Studio to create SQL statements that will allow me to migrate my database from one version to the next. I have been reading the files into a variable a...

Failed to load plugin v4rb_x64_release.so (xojo + valentina server 7.4)

Hi I have a 64-bit application, developed in xojo 2018 for run in linux ubuntu 16. I have valentina server reports 7.4 on ubuntu server Install v4rb_x64_8_lin.deb in pc client. In the folder of support libraries for the application I have:...

Checking for existing record

Hi, how can I speed up the code below which I use to check if a record is already in the database? Instruments tells me that the app spends about 10% of processing time in this method. For historical reasons (a.k.a stupidity) the method is a bit o...

How to save the SQLDiff result as separate scrips by their object type?

Hi, is there any option to save the SQLDiff result as separate scripts by the type of objects? A short description of the background: it would be helpful for our continuous integration and deployment architecture. We use a deployment service, w...

Default value for array field

Is it possible to set the default value for an array field? If so, what is the syntax for the DEFAULT clause in the CREATE TABLE statement? Also, how would I enter the default value entered in Valentina Studio via the Object Editor. Do I need to u...

License keys: Where are they for?

I purchased the Omega Bundle 2018 and received a set of license keys. Can you please explain the different kinds of keys: Where are they for? V4RB... (3 times) VR4RB... (3 times) VSPRO (I think this is Valentina Studio) VSRV... Thank you in ...


There are no discussions available here currently
  1. Posts: 858
  2. Resolved Posts: 0
  3. Unresolved Posts: 814
  4. Latest Member: Thomas Klumpp
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