Discussions tagged ADK_V4RB_XOJO
Make QR more fleible in Reports
I'd like print reports or label reports with QR codes on it. Instead of just having "a field" as contenct of the QR I would like to be able to define "an expression" that might include a field's information as well. Maybe an addit...
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
In
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
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
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
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
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...
Alex Lindsay
In
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
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
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
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 ...
Alex Lindsay
In
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
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
------- ...
- Page :
- 1