Обсуждения с облаком ADK_V4RB_XOJO
Rocky Scofield
Опубликовано в:
v4rb error when launching 32bit Xojo app on Win Server 2012.
Hello. I have a Xojo app deployed on many Win10 laptops. This app uses the Xojo reports ADK (from July of 2021). On those laptops everything runs well. The app is compiled in 32bit mode compatibility reasons for a nother 3rd party software.
I am n...
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...
- Страница :
- 1