Your feedback is highly appreciated! Let's make Vertabelo even better.
Nie znaleziono podobnych wątków.

0
Z odpowiedzią
how to export the DB model into VISIO 2013?
Chaithanya Naik 10 lat temu
•
Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu •
1
I have created 2 DB models in vertabelo but now i need to export it to VISIO 2013..
is there a way to export this to VISIO 2013 format?
is there a way to export this to VISIO 2013 format?

+1
Planowane
Update columns in view fails to determin type for CASE expression
Tomasz Traczyk 10 lat temu
•
Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu •
1
In my model I have a view using the CASE expression for some column, like this:
SELECT
(...)
CASE WHEN <some condition> THEN b.name
ELSE c.name
END AS name
(...)
When I click the Update columns button, column name is constantly interpreted as int, while both b.name and c.name are varchar (in fact in my case they even refer to the same column of the same table).
I suppose it might be difficult in general to reason about the desired type of case expression, but as for me, silently assuming that it's int, without any warring is a bug.
I've fixed the type manually sometime ago, then today I've added some new columns to my view and then, not remembering about the issue, hit "Update columns", which silently broke my model. I'd rather get an error, that Vertabelo is unable to update columns.
SELECT
(...)
CASE WHEN <some condition> THEN b.name
ELSE c.name
END AS name
(...)
When I click the Update columns button, column name is constantly interpreted as int, while both b.name and c.name are varchar (in fact in my case they even refer to the same column of the same table).
I suppose it might be difficult in general to reason about the desired type of case expression, but as for me, silently assuming that it's int, without any warring is a bug.
I've fixed the type manually sometime ago, then today I've added some new columns to my view and then, not remembering about the issue, hit "Update columns", which silently broke my model. I'd rather get an error, that Vertabelo is unable to update columns.

0
W trakcie analizy
Adding a group to view my large schema
sam Prin 10 lat temu
•
Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu •
2
I'd like to add a group of email addresses to view my large database schema.
I don't want to have to pay individually for each member because they are based around the world and I do not have access to their email addresses. I would like to add them to my account. I have tried setting up a company account but the members are unable to view because there are too many tables.
Is this possible?
I don't want to have to pay individually for each member because they are based around the world and I do not have access to their email addresses. I would like to add them to my account. I have tried setting up a company account but the members are unable to view because there are too many tables.
Is this possible?

Odpowiedź
anonymous
10 lat temu
Well, I think it'd be much more useful to learn about database basics and good DB design rather than SQL. We even created a series of videos called "Vertabelo Database Academy" that you can find on YouTube:
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI
If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.
Hope this helps.
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI
If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.
Hope this helps.

+1
Naprawione
How do i move a model into my team account ?
I have bought a team subscription... but your system won't let me move my models ? How do I move them into team account ?

0
Naprawione
Typo in bonus-page
On http://www.vertabelo.com/bonus-points there's a typo at the end: "For new and valueble feature request..."

0
Z odpowiedzią
How to change the text size
Mengzhou Fang 10 lat temu
•
Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu •
1
When I export an PDF, my printout looks so tiny. I need to make the text size larger. But I can't

0
To nie jest błąd
SQL Server Model with column name of Order adds quotes
Kindler Chase 10 lat temu
•
Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu •
6
When adding a table for SQL Server and with a column name of Order, the generated SQL incorrectly adds quotes around the column name:
The generated SQL should be using brackets:
I haven't tried other key words; if you fix this, I'd suggest testing other key words as well.
Thanks!
-- tables-- Table: OrderTest CREATE TABLE OrderTest ( "Order" int NOT NULL, Value varchar(250) NOT NULL ) ;
The generated SQL should be using brackets:
-- tables-- Table: OrderTest CREATE TABLE OrderTest ( [Order] int NOT NULL, Value varchar(250) NOT NULL ) ;
I haven't tried other key words; if you fix this, I'd suggest testing other key words as well.
Thanks!

0
Naprawione
Allow .media and other new top level domains in email address validation
sam Prin 10 lat temu
•
Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu •
3
I was not able ot use my work email address sam@seed.media to sign up

0
Naprawione
Prepaid Code Purchase Destination
Kevin Huber 10 lat temu
•
Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu •
7
When I am on the pricing page and click the premium account pay per day link, it just takes me to one of my model's page. I want to pay money but can't!
Customer support service by UserEcho