I think this strengthens the argument to having it optional (I like the dialect 4 idea).

Could you not fetch metadata about the tables you queried so that you could figure out what prefix to use?

Regards,
Lee Brown
-----Original Message-----
From: Roger Vellacott [mailto:rvellacott@...]
Sent: Tuesday, August 28, 2001 07:25
To: 'ib-support@yahoogroups.com'
Subject: [ib-support] Re: Ambiguous SQL :: Your Views Please


I allow my users to click on column titles to sort the tables by any field,
and I dynamically rewrite the query with a different ORDER BY <Clicked Field
Name>.. When there are joins It is not so easy to work out what the
prefix should be, so I rather rely on the ambiguity being allowed. This
functionality is written into ancestor forms, which can be inherited and
populated with any table, and I do not want to have to hard-code every
field-name and its prefix. Throwing an error will give me some problems,
unless someone can tell me how (using Delphi, IBO and VCL) I can get the
correct alias-prefix for the field which has been clicked.


Roger Vellacott
Passfield Data Systems Ltd


Yahoo! Groups Sponsor

Start here...

Height:
345678 ft 01234567891011in

Weight:
lbs. kg.








To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]