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, [email protected] <[email protected]> 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
