Обсуждения с облаком 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