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

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

ValentinaInit() crash developing C++ Photoshop Plugin Mac

Hi, I made a upgrade from Valentina ADK C++ from version 9 to version 11 to compile my application as Mac universal (x86_64 and arm64). I just replaced the dylib's and update the serials in my application and I get a crash on call 'ValentinaInit'....
Jonathan Ashwell Опубликовано в:

Build script for V4RB

I’m using the old build script install_vcomponents_v4rb_v7 and am running into some problems. Is there a newer version I missed? And I see that install_vreports just declared but not used in the script?...
Jonathan Ashwell Опубликовано в:

Best way to escape text for RegEx search

I've been using Valentina.EscapeString() for Regex searches, but the searches fail if they have characters like (, ), or ? I see these characters aren't being escaped properly to \( \) \? I can add the \ myself and now the Regex searches work...
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...
  • Страница :
  • 1

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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories