Discussions tagged SOLVED!

VStudio SQL Editor Parameters not functioning

I have downloaded VStudioPro 8.6 and tried to use the new useful Parameters feature in the SQL Editor window. But unfortunately I always get from MySql a syntax error just around the parameter (see screenshot). My query looks like: SELECT * FROM t...

Adding Page to Report

Hi, I am developing a report that displays a government form. The form is placed on the page as an image and the database fields are placed on the image in the appropriate places. It works fine. Here's the question: The last page of the form c...

Failed to load plugin v4rb_x64.dll

My customers get a 'Failed to load plugin v4rb_x64.dll' error when trying to open my app. I build that app with Xojo 2018r2.0, V4RB_8.2.0 and the error is (right now) on Windows 10. My Innosetup script use this command to install V4RB: Sourc...

Problem with MSSQL

hey i can connect using the code from xojo to MSSQL but no from Reports ADK From Xojo waySqlStr="Driver={SQL Server};Server=localhost;Database=adg;UID=sa;Pwd=1223"...

Xojo 2018r2 MacOSX crashes when compile V4RB examples

I purchased the Omega Bundle and have downloaded the components for both Mac and Windows. While working my way through the examples, I've been able to compile and run them fine on the Windows machine, but on the Mac it creates a hard crash as the d...

SQL Editor failed to execute CREATE PROCEDURE

Hi, I can't seem to execute the following create procedure in the SQL Editor. DELIMITER ;; CREATE PROCEDURE `GetAllPhoneBook`() BEGIN START TRANSACTION; SELECT * FROM phone_book; COMMIT; END;; DELIMITER ; I got the followi...

Load Dump is taking a long time to complete

Hi, I tried to load the dump generated earlier with VStudio and it took a long time to complete. It is because the dump generated by VStudio uses multiple INSERT to insert multiple data (i had 50K row to insert, this took a few minute). Is i...

Can I drop a primary key in SQL Editor?

Hi everyone, I am unable to drop / recreate a single PK using SQL Editor. Here's a simple test case: CREATE TABLE "public"."parent2" ( "parent_pk2" Integer NOT NULL, "field_ref1" Integer, "fie...

Failed to load plugin v4rb_x64_release.so (xojo + valentina server 7.4)

Hi I have a 64-bit application, developed in xojo 2018 for run in linux ubuntu 16. I have valentina server reports 7.4 on ubuntu server Install v4rb_x64_8_lin.deb in pc client. In the folder of support libraries for the application I have:...

Issue with SqlExecute when creating both functions and procedures

I am working in LiveCode and am using V4REV 8.3.3. I have been using the SQLDiff tool in Visual Studio to create SQL statements that will allow me to migrate my database from one version to the next. I have been reading the files into a variable a...

Report output does not follow the query result

I have a report which the query result different from the actual output. Check the screen shot. The query result show that in correct order: itemCode: 0001 -> 0013 But when the actual report output, the order is incorrect: 0013 -> 0001 ...

Error loading plugins

When I run Valentine Studio show several errors loading some of the plugins. It says "Cannot load library, can't find module". Ir happens with vs_plugin_db_sqlite_client.dll and two more....

Mysql SET statement

Hello, how do I set a variable session in sql Ex: SET SESSION group_concat_max_len = 1000000; When I associate in the datasource, it returns an error : 08:55:34 SELECT * ,extravios AS InternalReportField0 FROM ( SET SESSION group_concat_max_len...

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

100% CPU usage

Valentina Studio is frequently going into %100 CPU (i have 8 cores, I get 800% CPU, probably since it uses all threads it can take). I'm not sure what is the cause of that, I'm using it on MacBook pro with MacOS Sierra and MariaDB: mysql Ver 15....

Data forms in Valentina studio and views....

It might seem like an odd question to some but can you create forms in just released form editor (Valentina Studio v8) based off of the views and not tables? As of now it seems to me that you can't because views are not even presented as a viable se...

Cursor location

Can you explain the pros and cons about the different cursor location settings? When to use serverside and when clientside?...

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

AWS and running valentina server on amazon

Hi, I have tried to run VServer on a windows 2016 image on AWS (amazon). Running it internal works, but when trying to reach it from my local computer (mac) running VStudio, it get no luck... I have opened port 15432 in the sequrity at amazon,...
  • Page :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories