Re: Selecting Multivalues


dawn wrote:

I only saw a single association in your example. Do the suggestions on
how to handle the example given work or not? Are you saying that the
solutions provided work, but your actual case is different from the
example so that it doesn't work there? If so, could you provide a new
example?

You are right, my initial example led to suggestions that were too
specific. I need a solution that will allow more than one multivalued
association to exist in the file and in the query, and BY-EXP flattens
things out incorrectly if I have more than one association present.

Of course. Similarly, those working with C++ who are asked to write
JavaScript; or those writing VB who are asked to write Java. It should
come as no surprise that people like what they know and use and roll
their eyes at what they don't.

I am not sure about that. Many of my friends in the Java world would
much rather be using Smalltalk or Lisp or Ruby - which they see as
superior to Java in many ways. For the most part, I think they give
things a fair(ish) evaluation before rolling their eyes.

Have you ever seen a desired query against an SQL dbms have no simple
solution?

Well, the question is whether or not the language is complete - whether
you can express everything you want to say. SQL is not perfect, but it
does express all the queries I could want against a relational DB. My
gripe is that the Pick query language does not support well the
underlying model of multivalues.

then I have to concede to their arguments that
Pick's multi-values are holding me back rather than helping me.

That is a very surprising conclusion. Do the Java developers have an
excellent means of performing such a query against objects that hold
the same data you are discussing here? Is Java's ability to hold an
array value holding the developers back rather than helping them?

No, but that would lead to another argument about collection types,
which I don't want to get into here, other than to say that Pick cannot
distinguish between an empty dynamic array, and a dynamic array with
one attribute which itself happens to be empty. This frustrates me
greatly - and I have seen some very nasty hacks in BASIC application
code to get around this deficiency. Anyway, that is a different
argument from the one here.

.

Relevant Pages

  • Re: dynamic type checking - a pauline conversion?
    ... to actually write the code in Java. ... Is the query handled ... One of the problems with Java typing is small differences in interfaces ... array iteration, List iteration, and database query result iteration all ...
    (comp.object)
  • RE: Slow response time from Java compared to Query Analyzer
    ... Slow response time from Java compared to Query Analyzer ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Cant get JDBC to work from Java to MySQL
    ... ResultSet rs = stat.executeQuery("SELECT draw_date FROM ... (Java, Stack trace, and table description - stack trace from the code ... compiles and prints! ... SQL Exception:Unexpected exception encountered during query. ...
    (comp.lang.java.programmer)
  • Re: Query LDAP from Linux??
    ... > I have a developer that wants to be able to query AD ... > using a Java based Linux app, what to I need to tell him ... have to explicitly send a bind request with the DN of a domain account. ... This should be no problem with any Java LDAP API ...
    (microsoft.public.windows.server.active_directory)
  • array of Variant - any precautions?
    ... If I use dynamic array of variants: ... Do I need to take some extra steps to "clean up" the dynamic Variant arrays? ...
    (borland.public.delphi.language.objectpascal)