BAQ 8.03 Blank Title 63694

Yahoo Archive
1
Correction: "DISTINCT" SQL statement - not "UNIQUE" (showing my age as UNIQUE was a statement supported by an old db I used in the 80's).


Robert Brown <robertb_versa@...> wrote: I'm still transitioning from SQL thinking to lame-o BAQ thing... Is there no BAQ equivalent to "UNIQUE" and "GROUP BY... HAVING" statements?

If there is, you wouldn't have to trick it to do what you want by (beneficially misusing) a LAST (or FIRST) statement.

????

Rob Brown

"laidig.systems" <laidig.systems@...> wrote:
I have created a BAQ where two tables are joined only on by the LAST
record, not EVERY record in the Phrase Builder. It seems to work
great except that when i run my query it gives me an error message
that "You cannot use first / last when you have a character field with
a format of more than 1000." The query works as long as i don't have
any Character or comment fields in my query. Does anyone know of
another way to get around this issue. The reason i only want to join
by the last record is i because i want to relate the Projects table to
the OrderHed table but the only link is by ProjectID through the
OrderDtl table. If i don't join by LAST it will list my project and
orderhed information multiple times because the orders have multiple
lines. Is there a better way to do this?

---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

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






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

[Non-text portions of this message have been removed]
2
I have created a BAQ where two tables are joined only on by the LAST
record, not EVERY record in the Phrase Builder. It seems to work
great except that when i run my query it gives me an error message
that "You cannot use first / last when you have a character field with
a format of more than 1000." The query works as long as i don't have
any Character or comment fields in my query. Does anyone know of
another way to get around this issue. The reason i only want to join
by the last record is i because i want to relate the Projects table to
the OrderHed table but the only link is by ProjectID through the
OrderDtl table. If i don't join by LAST it will list my project and
orderhed information multiple times because the orders have multiple
lines. Is there a better way to do this?
3
I'm still transitioning from SQL thinking to lame-o BAQ thing... Is there no BAQ equivalent to "UNIQUE" and "GROUP BY... HAVING" statements?

If there is, you wouldn't have to trick it to do what you want by (beneficially misusing) a LAST (or FIRST) statement.

????

Rob Brown

"laidig.systems" <laidig.systems@...> wrote:
I have created a BAQ where two tables are joined only on by the LAST
record, not EVERY record in the Phrase Builder. It seems to work
great except that when i run my query it gives me an error message
that "You cannot use first / last when you have a character field with
a format of more than 1000." The query works as long as i don't have
any Character or comment fields in my query. Does anyone know of
another way to get around this issue. The reason i only want to join
by the last record is i because i want to relate the Projects table to
the OrderHed table but the only link is by ProjectID through the
OrderDtl table. If i don't join by LAST it will list my project and
orderhed information multiple times because the orders have multiple
lines. Is there a better way to do this?






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

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