Обсуждения с облаком Valentina DB ADK

Lynn Fredricks Опубликовано в:

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

Sebastian Kapellas Опубликовано в:

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...
Jonathan Ashwell Опубликовано в:

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...
Christian Breu Опубликовано в:

Cursor location

Can you explain the pros and cons about the different cursor location settings? When to use serverside and when clientside?...
Christian Breu Опубликовано в:

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?...
Jonathan Ashwell Опубликовано в:

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...
Ruslan Zasukhin Опубликовано в:

[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...
Claudius Sailer Опубликовано в:

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...
Jose Panatti Опубликовано в:

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. ...
Ruslan Zasukhin Опубликовано в:

[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...
Ruslan Zasukhin Опубликовано в:

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...
Claudius Sailer Опубликовано в:

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...
Stephan Fellner Опубликовано в:

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...
Ruslan Zasukhin Опубликовано в:

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...
Aleksandar Spasojevic Опубликовано в:

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...
Sid Price Опубликовано в:

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...
Sid Price Опубликовано в:

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...
Jurriaan Schulman Опубликовано в:

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, ...
Thomas Goertler Опубликовано в:

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...
Jochen Peters Опубликовано в:

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...
  • Страница :
  • 1


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