Knoda Combo Box oddity?

[gnash]

Here's what I am doing.  I have a music database with a column that lists composers names.  I have added a combo box to a form with this column as it's datasource.  The problem is to do with the listdatasource. What I want, is for the pull down list to display a list of all the composers previously entered into that database column.  Knoda doesn't let you have the listdatasource the same as the main datasource, so I created a separate query basically as follows...

select distinct composers
from musicdatabase
order by  composer;

and made this query the listdatasource.   This works up to a point.  The pulldown list uis populated correctly and I can select a composer.  I can also type in the combo box and it preselects the first match to what I type.


What DOESN'T work is when I have a new composer, never entered in that column before.  I type the new name into the combo box, but when I save the record, knoda saves the nearest choice from the list, NOT what I had typed.

Is this a bug, or am I doing something wrong? 




------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

[SGBotsford]

In general a select query pulls information from a database.  It
doesn't update information to a database (that's an update query.

Some front ends have added magic so that it will work both ways.

FWIW knoda is not well supported.  What you have is what you get.

I spent a week trying to find a rapid application environment in
Linux. that didn't require a month to learn.  I finally gave up, and
spent a day setting it up in MS Access.

On Mon, Mar 2, 2009 at 3:46 PM, bluestube@...
<bluestube@...> wrote:

> Here's what I am doing.  I have a music database with a column that lists
> composers names.  I have added a combo box to a form with this column as
> it's datasource.  The problem is to do with the listdatasource. What I want,
> is for the pull down list to display a list of all the composers previously
> entered into that database column.  Knoda doesn't let you have the
> listdatasource the same as the main datasource, so I created a separate
> query basically as follows...
>
> select distinct composers
> from musicdatabase
> order by  composer;
>
> and made this query the listdatasource.   This works up to a point.  The
> pulldown list uis populated correctly and I can select a composer.  I can
> also type in the combo box and it preselects the first match to what I type.
>
>
> What DOESN'T work is when I have a new composer, never entered in that
> column before.  I type the new name into the combo box, but when I save the
> record, knoda saves the nearest choice from the list, NOT what I had typed.
>
> Is this a bug, or am I doing something wrong?
>
>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> Hk-classes-discuss mailing list
> Hk-classes-discuss@...
> https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
>
>

--
Sherwood Botsford
Sherwood's Forests
Warburg, Alberta T0C 2T0
http://www.sherwoods-forests.com
780-848-2548

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

[Jesus Arocho]

A combo box is a based on a query.  I have to ask if entering a value that is
not part of the returned query set updates the combo box value.  I guess if
you wanted to type in any value and then use that value as part of an update
or insert, you would have to write code to get it accomplished.



------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

[Jesus Arocho]

On Monday 02 March 2009 19:22:00 Sherwood Botsford wrote:

> In general a select query pulls information from a database.  It
> doesn't update information to a database (that's an update query.
>
> Some front ends have added magic so that it will work both ways.
>
> FWIW knoda is not well supported.  What you have is what you get.
>
> I spent a week trying to find a rapid application environment in
> Linux. that didn't require a month to learn.  I finally gave up, and
> spent a day setting it up in MS Access.
>
> On Mon, Mar 2, 2009 at 3:46 PM, bluestube@...
>
> <bluestube@...> wrote:
> > Here's what I am doing.  I have a music database with a column that lists
> > composers names.  I have added a combo box to a form with this column as
> > it's datasource.  The problem is to do with the listdatasource. What I
> > want, is for the pull down list to display a list of all the composers
> > previously entered into that database column.  Knoda doesn't let you have
> > the listdatasource the same as the main datasource, so I created a
> > separate query basically as follows...
> >

Impressive, you learned MS Access in  a day!!!

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

[SGBotsford]

> Impressive, you learned MS Access in  a day!!!
>

Not quite.  I have a hobby running orienteering races.  I have 150
square kilometers of the neighborhood mapped, and I used access for
keeping track of the 1000+ controls I have scattered over that.

I'm no VB programmer, and access makes me tear my hair out, but all I
really wanted was a pair of linked tables, about 25 fields, a couple
entry forms and a mostly a couple descent reports.

I'm no access wizard.  But this is a very simple level of stuff.

(And yes, there was a fair amount of hair loss as I ran into access
limitations, and quirks and odd documentation.)



--
Sherwood Botsford
Sherwood's Forests
Warburg, Alberta T0C 2T0
http://www.sherwoods-forests.com
780-848-2548

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss