The order of row and columns in a database has no meaning. You can get
any order of rows and columns as needed.
If the visible field is the same as the bound one use the same field for
both columns:
SELECT "Field", "Field" FROM "Table"
--
For unsubscribe instructions e-mail to: users+h...@glob
Alexander Thurgood wrote:
Le 12/06/12 21:08, Dan a écrit :
Hi Dan,
To populate a list or combo box, I have been using single field
tables. Seems like it should be possible to use a single table for more
than one list or combo box. (The SQL statement for selecting a field for
I'm not sur
Le 12/06/12 21:08, Dan a écrit :
Hi Dan,
> To populate a list or combo box, I have been using single field
> tables. Seems like it should be possible to use a single table for more
> than one list or combo box. (The SQL statement for selecting a field for
I'm not sure I understand you corre
Dan wrote:
Dan wrote:
Andreas Säger wrote:
Am 12.06.2012 21:08, Dan wrote:
To populate a list or combo box, I have been using single field
tables.
Seems like it should be possible to use a single table for more
than one
list or combo box. (The SQL statement for selecting a field for a list
o
Andreas Säger wrote:
Am 12.06.2012 21:08, Dan wrote:
To populate a list or combo box, I have been using single field tables.
Seems like it should be possible to use a single table for more than one
list or combo box. (The SQL statement for selecting a field for a list
or combo box is: SELECT "fi
Le 13/06/12 13:50, Andreas Säger a écrit :
Hi Andreas,
>
> A two minutes test reveals that LibO 3.6(beta) can not use the first
> field (field #0) as bound field.
Thanks for testing, I guess those changes were in cwsdb34 which didn't
make it into LO (for various reasons) :-/
> I "always" sort
Am 13.06.2012 09:56, Alexander Thurgood wrote:
I seem to recall having seen somewhere on the OOo dev lists that it
should now be possible to directly select Bound field=0, and still have
your sorted distinct data on the other data field, or have I muddled
things up ? This was part of the develop
Le 12/06/12 21:37, Andreas Säger a écrit :
Hi Andreas,
> In a combo box you "always" want:
> SELECT DISTINCT "Field" FROM "Table" ORDER BY "Field"
>
> In a list box you "always" want:
> SELECT "Field or Concatenation", "Primary Key"
> FROM "Table"
> ORDER BY "Field or Concatenation"
> Bound fie
Am 12.06.2012 21:08, Dan wrote:
To populate a list or combo box, I have been using single field tables.
Seems like it should be possible to use a single table for more than one
list or combo box. (The SQL statement for selecting a field for a list
or combo box is: SELECT "field name" FROM "table
