<span class="Apple-style-span" style="font-family: Courier; ">- <font color="#1509EE"><u>0003119</u></font>: <b>[SQL]</b> Can't create field with <span id="st" name="st" class="st" style="background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 136); background-position: initial initial; ">DECIMAL</span> type (ruslan) - resolved.</span><div>
<font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">How do you do this using studio? I (like most people) have simple ordinary everyday things in my database like dates, simple numeric integers, money (you know two decimal places) and CHAR (which I have figured out are called STRING in Valentina and VARCHAR (which I'm glad you have).</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">And while I'm asking why does Valentina have all those:</font></div><div><font class="Apple-style-span" face="Courier"><br>
</font></div><div><font class="Apple-style-span" face="Courier">LONG, SHORT, MEDIUM, UNSIGNED MEDIUM, UNSIGNED LONG, UNSIGNED LONG LONG, UNSIGNED SHORT, FLOAT, DOUBLE ? Geez, I can't believe there are people that understand the difference between all those kinds of integer fields and use them for various important ways in their database design? In an internet search I see it is from "C" programming and not from SQL.</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Can't it be a little simpler? Simpler is usually better!</font></div><div><font class="Apple-style-span" face="Courier"><br>
</font></div><div><font class="Apple-style-span" face="Courier">I like:</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">NUMERIC</font></div>
<div><font class="Apple-style-span" face="Courier">DECIMAL</font></div><div><font class="Apple-style-span" face="Courier">INTEGER</font></div><div><font class="Apple-style-span" face="Courier">SMALLINT</font></div><div><font class="Apple-style-span" face="Courier">BIGINT</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">I can understand those. Maybe most users of Valentina Studio are going to be people coming from SQL standards and not from C programming?</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">If you used the same SQL conventions as everyone else it would also be easier to import and export SQL dumps.</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Is the goal for Valentina Studio and the further marketing of your database going to be for SQL users?</font></div>
<div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Bill</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">PS - I guess I should have kept this question simple and not ranted but...</font></div>