Themen mit Tags ADK_V4RB_XOJO

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

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 Geschrieben in:

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 Geschrieben in:

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 Geschrieben in:

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

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

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

[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 Geschrieben in:

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

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

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 Geschrieben in:

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 Geschrieben in:

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 ...
Scott Geschrieben in:

Valentina and Xojo R2

I upgraded to the latest release of Xojo today (R2) and even with the latest VDB ADK for Xojo installed, I get an error: This class is missing the SelectSQL method from the interface PreparedSQLStatement (VRBPreparedStatement). This is occurs no mat...

Symbolic Links

I have a question. I'm trying to deploy to Xojo cloud an app that uses the adk. In the current server the Libs Directory has 4 symbolic links that point to like named files, like: libvclient_release_x86.so.751 has a symbolic link libvclient_releas...

Xojo project Byte Order Mark issue

Recently we discovered that the Xojo project may contain Byte Order Mark in the source code. When BOM is inside the query text, database engines (SQLite, Valentina DB) are unable to execute this query, showing errors, not so easy to understand (BOM ...

611/5000 Xojo 2019 r1 and Valentina 9.3.2 blank reports

Xojo 2019 r1 and Valentina 9.3.2 blank reports I did a migration of Valentina report 6 to 9.3.2, you can see the reports from Valentina Studio (they have problems with the fields when they have can_grow, I am waiting for an arrangement), but when ...

Cursor options when used with a local embedded Database

I have some questions about the Cursor options when used with a local embedded Database with Xojo V4RB on Mac OS. 1. What is the difference between cursors on the client compared to the cursors on the server for embedded Database? 2. I got an err...
Dale Geschrieben in:

How to iterate a label

Hi, I created a label to print qr code from a receiving list. This receiving list has quantity of items received. From there, I need to print the number of qr codes per item. For example, I have the following; Items Quantity ------- ...

App Store rejection because of R/W access to sql_errors.xml and kernel_errors.xml

I use Valentina 8.0.2 with Xojo. I have built an App and submitted to the App Store. It has been rejected because of what I believe is a Valentina issue? Here is the rejection text: ---------------------- Your application accesses the following...
  • Seite :
  • 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