Обсуждения с облаком ADK_V4RB_XOJO

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

Large table very slow to open

I've run into a puzzling problem that still exists in 12.7. I have two tables in my database that can have thousands of records. For the first, even with 50K+ it opens quickly. But for the other, with 18K records it takes 1-2 minutes to open when thi...
Gaurav Joshi Опубликовано в:

Assigning User Privileges to Valentina Server through Valentina Studio

Hello Everyone, We have recently started using the Valentina Server and the Valentina Studio. We wish to understand the following : 1. How to assign user privileges in Valentina Server through the Valentina Studio. I am able to find options to cre...
Gaurav Joshi Опубликовано в:

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

Runtime error in Monterey

Using Xojo plugin 11.4.3 in Monterey -> no problem. But when I try to run in Monterey I get a Valentina runtime error, and upgrading to the current Valentina release doesn't fix it. I've uploaded a screen snap of the error....
Steve Albin Опубликовано в:

Problem when checking VDateTime for NULL value

I've upgraded from V4RB 9.6.4 to the latest version via the Omegabundle. I am using MacOS Big Sur 11.6. I notice in the release notes that there is a change to support the Xojo DateTime field. I am finding that if I simply read a Vdatetime fie...
Ray Veenema Опубликовано в:

XOJO 2021 Release 2.1 Binary link using ADK/API

I have a hard time creating the correct code to establishing the Binarylink between record 1 for table A with records 2, 3 etc from table A. There are no XOJO examples. I am able to set the link between record X from Table A with Record Y from ...
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?...
Emilio Robles Опубликовано в:

Ask for report params from Xojo App

Hi. Is there a way to query the parameters of a project from xojo? I have not found a way to do it with the vProject and vReport objects. Maybe with javascript using vReport.runscript ()? I need to know the parameters that are defined (intera...
Stan Busk Опубликовано в:

Corrupt database and slow loading

A customer sent me a Valentina database that seems corrupt. It is very slow to load but I can finally do it with the software that created it. However, Valentina Studio says it is not a valid database. Where can I sent that database so it can be c...
Roger Опубликовано в:

Valentina Constants are unknow

I hope my last question in this week Constans like kServerSideCursor, kReadWrite are unknow. In the help I cannot see where I need to serach them. Xojo ADK 10.4.18 on Windows 64 Regards Roger...
Roger Опубликовано в:

Valentnina correct way for sql select with parameter

Hello I try a simple select with a parameter like a preparedStatemanet like this with the result in a vCursor. stmt = db.CreateSqlStatement( "Select ** FROM myTable WHERE RecID = :1" ) stmt.Bind_UInt32(0, aRecIDVariable) VSqlStatement is ...
Roger Опубликовано в:

vSet, vTable, Fields

Hello I Try the API_way with Xojo. From your help "Many API methods of Valentina DB return such set, e.g. VField.FindValue() or VTable. Table.SelectAllRecords()." Now I have my sortet vSet but I can only grab the fields from the tabl...
Beatrix Willius Опубликовано в:

Open VSQLiteDatabase

Continuing the discussion from https://www.valentina-db.com/de/discussions/7458-transactions-committing-to-vsqlite . I found my problem and - yes - I was totally stupid. Ahem, I had assumed that CreateDatabaseFileEx() simply opens a database if it...
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...
Ruslan Zasukhin Опубликовано в:

[Info] V4RB - Xojo - RBDB - new methods and exceptions

Hi Xojo Developers, Information for you, and maybe issue to discuss. About year ago Xojo introduced in new API 2.0 few new methods Database - ExecuteSql() and SelectSql() Statement - ExecuteSql() and SelectSql() According to docs of Xojo...
Dale Опубликовано в:

How To Change Schema at Runtime

Hello! I have the following MySQL Schemas: - Branch01 - Branch02 - Branch03 They have the same tables and corresponding structures. I have a report that calls a stored procedure that pulls the data for the report. I designed my report using ...
Beatrix Willius Опубликовано в:

VSQLite database created but not table

When I change the example everything works fine, but in my code only the database is created and not the table. What am I doing wrong? Private Sub ConnectToDatabaseRemote() remote_db = new VSqliteDataBase dim options as string //ge...
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 ...
Helge Tjelta Опубликовано в:

Binding SQL injection and using % in the WHERE

Hi, I'm finally moving over to binding, and so far so good. But how do I get the % to work... I have F1 LIKE '%"+textinput+"%' and F1 LIKE :1 and also F1 ILIKE :1 works... But how do I use % with values ? F1 LIKE '%':1 d...
Findomo Опубликовано в:

Xojo R2 unable to load other plugins with valentina plugin

Hello, my XOJO project uses valentina plugin and works fine with xojo 2019 R1 on a windows 10 system I tried to upgrade to xojo 2019 R2.1 (I also upgraded the valentina plugin and all other plugins (all mbs plugins) Unfortunately the project fails ...
  • Страница :
  • 1