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

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

case sensitive select

Hello I try to select caseinsensitve. (Enter hello and find Hello) I used Call db.SqlExecute("SET PROPERTY IdentsCaseSensitive OF DATABASE TO True" And I see the change in the database properties. I tried to set False too. (restartet t...
Beatrix Willius Опубликовано в:

Databases with dot in name

One of my users had the idea to make a server database with a dot in the name. That doesn't seem to be a good idea. Valentina Studio shows the database with a red icon. The example ValentinaServerUtility shows the name as "mail.vdb" and ...
Lynn Fredricks Опубликовано в:

Omegabundle for Xojo 2020 Developer Tools Bundle Final Extension through Labor Day Weekend

Get the top developer tools and third party components for the Xojo cross-platform development platform at a huge savings. Omegabundle for Xojo 2020 is a collection of the most useful tool sets, add-ons, digital books and components for use with X...
Alex Lindsay Опубликовано в:

Why is there a rollback needed if there was not a clean shutdown.

I open an embedded database in my app in Xojo Debugger and if it crashes or I stop the debugger (no clean shutdown) then it will crash on any subsequent VDatabase.Open in either the Debugger or the compiled app If I call VDatabase.CheckRollback() it ...
Lynn Fredricks Опубликовано в:

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