Discussions tagged Valentina DB ADK

Valentina Release 9.3 Improves SQL Editor, ADKs and Server Query Speed

Paradigma Software announces Valentina Release 9.3 with improvements across all reporting, database and forms products. Valentina Studio / Studio Pro Valentina Studio is the free, all purpose database management and forms client tool. Valentina S...

Problem with Valentina Plugin Xojo

Can you suggest me an installer that is combatible with xojo 2016.r3 and an installer that is combatible with xojo 2018.r11. The procedure i follow is the following: Download installer, run it, then take Valentina plugin from Document\Paradigma and...

Can't normalize unicode in Valentina 8 on macOS

This code worked in V4RB 7.x call db.SqlExecute("UPDATE thereferences SET title=Normalize(title) WHERE isNormalized(title)=false" but in Valentina 8 generates this exception line 1:32: unexpected token: Normalize What i...

Cursor location

Can you explain the pros and cons about the different cursor location settings? When to use serverside and when clientside?...

queryresult as array in XOJO

Is it possible/how to get the result of a query into an array without iteration over a vCursor in XOJO?...

Reindexing fails

I have a db with a table (thereferences) that has bad index (diagnose -> problems). When I reindex in VStudio the problem is fixed. But when I try to do this in my app diagnose still reports problems. I'm using this code -- what am I doing incorre...

[NEW][ValentinaDB] - LINK RECORD(LAST) syntax

Hi Valentina Devs, For those who use Valentina Links: we have to improve LINK RECORDS command. When you add records to T1 and T2, to link them you need RecIDs of that last added records. Up to now you could write this set of SQL commands to do...

RecID can not be indexed (V4RB 7.0.4)

I opened my database with valentina studio to make a short SQL-Select. Everything works fine and result locks good, but I can see following warning (see attached file). Then I opened my database with my app and run reindex database and diagnose dat...

Enums in Xojo

I`m trying to use enum types in Xojo from Valentina Database but I can't. I want to complete a popup menu with strings from an enum type. Created an object of type VTypeEnum but then I d'ont know how to retrieve the values and complete the popup. ...

[TIP][ValentinaDB] Natural Sort Order - Numeric Ordering

Hi ValentinaDB Developers, A few days ago a question appeared via support to make String field (containing numbers) sort records using those numbers. By default the examples { test-1, test-10, test-2, test-24, test-7, test-27, test-17 } will b...

TIP: VDatabase.Prepare( inSqlCmd ) as VSqlStatement

Hi Valentina DB Developers, I want to expose this feature of Valentina DB 7.0. Xojo developers could see it in other DBs, also SQLite developers know it. In 7.0 of Valentina DB we have got it also. From this point, this should be the mos...

can't set "not null" and "indexed" with ALTER TABLE command

I have an easy question but I can't solve the problem. I added a new filed in a table (using viSQL for Xojo, Valentina 6.6.9) ALTER TABLE EventName ADD EventArt VarChar(504) UPDATE EventName set EventArt ='Maze‘ works also fine. th...

Binary link on same table

Hi, wondering if it's possible to link the same table with binary link. The idea is a table with tasks and sometimes a task can be a subtask of a task in same table. Is a binary link an possible option for this relation? it's not urgent, just a t...

Graph Database with Valentina - ANSWER

Okay, this thread is ANSWER to another thread with question. I am starting it to give useful information. I think later we need some article about this. So Jurriaan have show me book "Neo4J in Action" where on the first page there discu...

ADK - V4RB_6 for Real BAsic

Hello, On this page i found that V4RB_6 can be used in Real Basic Valentina for Xojo/REALbasic Win Installation http://www.valentina-db.com/docs/dokuwiki/v6/doku.php?id=valentinaroducts:adk:v4rb:manual:installation:win I was looking for V4R...

Using String class

In my C++ application I am using the String class to pass to some Valentina methods. I am debugging the application using the VisualGDB plugin for Visual Studio 2015. The problem I have is that unlike the string class of the C++ Standard Library it d...

VConnection undefined?

I am including the VSDK.h header file in my test application however when I try to use VConnection class it is undefined. I searched VSDK files and did not find it. Has this class been deprecated or if not where is it defined? Thanks, Sid...

Graph Database with Valentina - QUESTION

Hello, I'm looking for a graph database to represent and store knowledge (like Cayley or Neo4j) which can be used with Xojo. Would it be possible to use Valentina for this kind of work, using records as nodes and binary links as edges? Cheers, ...

Delete linked records with cascade question

Hi, in our VServer database we've several tables that are linked mostly 1:M. Now when we delete a "master" record all connected records get also deleted. After the detail records are deleted it seems the "links" are still intac...

Self Join, how to aggregate data fron a table?

Hello, While I'm quite comfortable to use SQL up to medium level it's one field that gives me grey hair and poor sleep, self join. Below is the table and its structure with some data: SQLTable1.png The second screen shot is the result that I wan...
  • Page :
  • 1