<HTML>
<HEAD>
<TITLE>Re: [TIP!] SQL. New operator -></TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>Frank Schima (8:32:53 PM): That -> operator is AWESOME<BR>
Frank Schima (8:33:02 PM): That will simplify many SQLs for me.<BR>
<BR>
Frank Schima (8:35:50 PM): I will be doing lots of changes to my project now.<BR>
Frank Schima (8:35:59 PM): I think i can convert to V2 exclusively now.<BR>
Frank Schima (8:36:39 PM): Are there other cool SQL99 things to know?<BR>
Frank Schima (8:36:45 PM): I am not too familiar with it.<BR>
rz (8:37:12 PM): no, this is only thing that I have too see and fall in love<BR>
Frank Schima (8:37:23 PM): OK<BR>
Frank Schima (8:37:26 PM): Yes it is great<BR>
<BR>
rz (8:37:37 PM): cool new features are link functions<BR>
rz (8:37:45 PM): you can read in Valentina SQL.pdf<BR>
Frank Schima (8:37:46 PM): I really need to play with those.<BR>
Frank Schima (8:37:48 PM): Yes<BR>
<BR>
rz (8:38:00 PM): they also simplify a lots SQL<BR>
rz (8:38:05 PM): VERY VERY A LOTS.<BR>
rz (8:38:16 PM): some kind of query that are not trivial<BR>
rz (8:38:30 PM): even expert was not able write correct SQL92 query in say 10 minutes<BR>
rz (8:38:53 PM): this link functions allow even dummy user write it in natural way in 5 seconds<BR>
<BR>
Frank Schima (8:38:59 PM): Wow<BR>
Frank Schima (8:39:05 PM): I really need to check this out.<BR>
Frank Schima (8:39:14 PM): and change my structure then.<BR>
Frank Schima (8:39:52 PM): Remove M:M tables.<BR>
Frank Schima (8:39:59 PM): Add links.<BR>
<BR>
rz (8:40:07 PM): aha, to BinaryLinks?<BR>
rz (8:40:13 PM): yes this is cool IMHO<BR>
rz (8:40:34 PM): although you can replace only M:M table that do not have additional fields<BR>
Frank Schima (8:40:42 PM): right<BR>
rz (8:40:51 PM): i..e you can replace only M:M tables that have 2 ptrs<BR>
Frank Schima (8:40:56 PM): exactly<BR>
<BR>
Frank Schima (8:41:18 PM): I see now.<BR>
Frank Schima (8:41:25 PM): Link functions are different than what i was thinking.<BR>
Frank Schima (8:41:36 PM): They look cool too.<BR>
Frank Schima (8:42:18 PM): you will change my life!!!<BR>
Frank Schima (8:42:19 PM): :)<BR>
rz (8:42:30 PM): I hope they will work :-)<BR>
<BR>
Frank Schima (8:43:36 PM): Yes this is too cool!!! I am reading<BR>
Frank Schima (8:43:50 PM): I was looking at a SQL just now that can use these.<BR>
Frank Schima (8:44:07 PM): They also remove joins!!!<BR>
Frank Schima (8:44:18 PM): i may never need an outer join again!!!<BR>
rz (8:45:09 PM): :-))<BR>
</SPAN></FONT>
</BODY>
</HTML>