Discussions tagged Fixed Header

BACKUP DATABASE [TO absolute_path]

What is properly syntax of "absolute_path" I tried: BACKUP DATABASE TO "\\server\share\" but I got error: File E:\databases\\\server\share\.vdb" does not exist....

deleted links are automatically restored

Hello, i'm new in Valentina Studio and make my first steps in this environment. I really like the UI. But i have a really strang issue. Everything is working fine except the deletion of Links. When I want to delete a Link I'm asked if I'm really s...

Related Table Child Record Entry Issue

In VStudio Data Editor, I open a parent table. Then I click on the Show Related Table icon next to the Layout dropdown and the related (child) table shows below. With the parent table selected above, I add a child record in the related table area...

VServer 9.8 Windows x64 Installation Error

I just tried to update my Windows x64 VServers and the installation could not complete because it could not find the file: vcruntime140_1.dll I have never seen this .dll file with a _1 in the name before. I renamed the existing vcruntime140.dl...

Generate SQL wrong field order

Hey, when I use the "Generate SQL -> Create/Drop/Insert/..." feature in the Schema Editor, the order of the fields is incorrect. It is not in the order of the field position and cannot be sorted otherwise. So if the first field is &qu...

NULL behavior changed in Studio 9.0.2

It appears that 9.0+ handles NULL differently than its counterpart version 8. Version 8 correctly was setting a NULL value in a field of it was set as 'NULLABLE' and no value provided. Version 9 no longer does it. This will create problems when qu...

pb of default column type while a dump

Hi, i was a happy heidsql windwos user but i deicded to level up to linux, i found valentina as an alternative and i have to say that it's cool. but when i made a dump of a database, instead of default column type, valentina give me double 22,0 and t...

Why is Cardinality greyed out in the last few versions of Valentina Studio?

I the free version previously I could create links and choose Cardinality, but for the last few month I can only do that manually, because UI has greyed out Cardinality options and it is only One to One. Is this a new restriction or issue? Using ...

SQL Editor "Show/Hide Side Panel" button only hide part of the side panel

Hi, When i try to hide the side panel using the "Show/Hide Side Panel" button in the SQl Editor, it only hide part of the sidebar (see attached photo)....

Forms - duplicated renamed form

Hi, This may be user error ... but in case, it isn't. I created a form that has a TableView with a query as its source. I liked the results and duplicated, using Duplicate, the form. I renamed the duplicated form. I edited the duplicated form:...

SQL Editor CTRL + SHIFT + Z Redo shortcut not working some time

Hi, I noticed that when i create a new SQl Editor, the CTRL + SHIFT + Z Redo shortcut does not work sometime. It will only work a while after I select the Redo from the menu, and then stop working again after i switch to another SQL Editor tab an...

Cannot restore foreign key with Drop Before Restore selected in Create Dump

Hi, I am getting the following error when restoring the dump created with Drop Before Restore option enabled. Error in query (1091): Can't DROP FOREIGN KEY `fk_address_book_postal_code_list`; check that it exists The database does exist befor...

DROP DATABASE option in Create Dump.

Hi, currently there is no option to include drop database sql into the dump, the existing Drop before restore option does not include dropping the database....

Created Dump default value issue

Hi, When i try to restore the dump created by VStudio, I got the following error: Error in query (1067): Invalid default value for 'country_code' Upon checking, i noticed that the default value contain the escape character(\'): `country_code`...

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

Rearrange item in select tab of Query Editor

Hi, is there a way to rearrange the item sequence in the select tab of the Query Editor? Currently it seem i can only swap the position of 2 item, i had to do a lot of swapping to get an item to the position i want....

Changing Query Editor background color

Hi, is there a way to change the Query Editor background color? Currently, the default dark grey is making the links line really hard to see unless i highlight it with a mouse....

Disabling single click open SQL Editor in Schema Editor - Diagram

Hi, Not sure if this is an intentional design or a bug. Is there a way to disable the default single click open SQL Editor function in the Schema Editor - Diagram? I keep getting send to the SQL Editor when i try to view the list of created diag...

Pie Chart?

Hi, I have a query that is returning data for a Boxes type chart but when I switch over to pie charts, the example disappears and nothing is generated with the report at all. Also where is the documentation that details how to customize the label...

Can't normalize unicode in Valentina 8 on macOS

This code worked in V4RB 7.x call db.SqlExecute("UPDATE thereferences SET title=Normalize(title) WHERE isNormalized(title)=false" but in Valentina 8 generates this exception line 1:32: unexpected token: Normalize What i...
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories