[TIP!] SQL. New operator ->

[Ruslan Zasukhin]

Frank Schima (8:32:53 PM): That -> operator is AWESOME
Frank Schima (8:33:02 PM): That will simplify many SQLs for me.

Frank Schima (8:35:50 PM): I will be doing lots of changes to my project
now.
Frank Schima (8:35:59 PM): I think i can convert to V2 exclusively now.
Frank Schima (8:36:39 PM): Are there other cool SQL99 things to know?
Frank Schima (8:36:45 PM): I am not too familiar with it.
rz (8:37:12 PM): no, this is only thing that I have too see and fall in love
Frank Schima (8:37:23 PM): OK
Frank Schima (8:37:26 PM): Yes it is great

rz (8:37:37 PM): cool new features are link functions
rz (8:37:45 PM): you can read in Valentina SQL.pdf
Frank Schima (8:37:46 PM): I really need to play with those.
Frank Schima (8:37:48 PM): Yes

rz (8:38:00 PM): they also simplify a lots SQL
rz (8:38:05 PM): VERY VERY A LOTS.
rz (8:38:16 PM): some kind of query that are not trivial
rz (8:38:30 PM): even expert was not able write correct SQL92 query in say
10 minutes
rz (8:38:53 PM): this link functions allow even dummy user write it in
natural way in 5 seconds

Frank Schima (8:38:59 PM): Wow
Frank Schima (8:39:05 PM): I really need to check this out.
Frank Schima (8:39:14 PM): and change my structure then.
Frank Schima (8:39:52 PM): Remove M:M tables.
Frank Schima (8:39:59 PM): Add links.

rz (8:40:07 PM): aha, to BinaryLinks?
rz (8:40:13 PM): yes this is cool IMHO
rz (8:40:34 PM): although you can replace only M:M table that do not have
additional fields
Frank Schima (8:40:42 PM): right
rz (8:40:51 PM): i..e you can replace only M:M tables that have 2 ptrs
Frank Schima (8:40:56 PM): exactly

Frank Schima (8:41:18 PM): I see now.
Frank Schima (8:41:25 PM): Link functions are different than what i was
thinking.
Frank Schima (8:41:36 PM): They look cool too.
Frank Schima (8:42:18 PM): you will change my life!!!
Frank Schima (8:42:19 PM): :)
rz (8:42:30 PM): I hope they will work :-)

Frank Schima (8:43:36 PM): Yes this is too cool!!! I am reading
Frank Schima (8:43:50 PM): I was looking at a SQL just now that can use
these.
Frank Schima (8:44:07 PM): They also remove joins!!!
Frank Schima (8:44:18 PM): i may never need an outer join again!!!
rz (8:45:09 PM): :-))

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20050207/c4554a8d/attachment-0001.html