Discussions tagged ADK_V4RB_XOJO

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

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

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 Extended

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

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

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

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

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

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

MySql Web App in XOJO

Hello , I have in the open event for the app my valentina license. I create a container and a button and this is the following instruction I did : try //Open Connection dim conn as VConnection = new VConnection("127.0.0.1","username...

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