Discussions tagged Valentina DB ADK

Using UPDATEALLRECORDS for Where condition in Valentina DB

Hello Everyone, I am trying to update a record in Valentina DB using the below. Tbl = mDatabase.Table( "UserList" ) Tbl.RecID = ULSelectedID.ToInteger Tbl.StringField(1).Value = ULSelectedID Tbl.StringField(2).Value = UserListConta...

Valentina 12.5b10 - introduces VStudio Mac ARM and QT6. LATEST - b24 uploaded.

Hi Everybody, http://valentina-db.com/download/beta/12.5b10/ You are welcome to try our 12.5b10 build. The main changes: 1) Valentina Studio switched to QT6 2) The Mac version of VStudio is now compiled with the ARM option. 3) Valentina...

Golang API for ValentinaDB

Hello! My name is Max. I am from Inchpoint GmbH (Hannover, Germany - https://www.inchweb.de/) We develop both Internet and desktop applications and have to use a lot of different technologies. For the Internet they are: pxp + Magento + MySQL + ...

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

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

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

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

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

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

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

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...
  • Page :
  • 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