I found a problem of with the Knodas Combbox widget.
In order to familiarize myself with Knoda, I just set up a database frontend
for my personal hobby: a management system for my private music collection.
In a table of Composers' names, some family names occur several times, i.e.
"Bach" 7 times, "Mozart" 2 times, "Scarlatti" 3 times. Of course the first
names of these various people are different.
To select these names from a combobox, only one data field can be shown there,
i.e. the family name. If I select one of these names with more than one record,
only the one on top of the list gets returned, always, no matter what I
actually select.
The mySQL database, which I use for storing data allows a select syntax as
follows:
SELECT CONCAT(FamName, ", ", FirstName) FROM Komponisten
The return would be string like "FamName, FirstName". This works fine with
mySQL, but not within Knoda.
I tried a workaround by creating a view. But here Knoda's complaint was
Unknown fieldname ", ".
Leaving the ", " out works, but the return looks like "FamNameFirstName",
without a , or a space between the two names.
I think this problem is serious. Consider a business that has a dozen or so
customers with the family name of "Smith". All the orders from all these
various Smithes would get shipped to only one and the same Smith, the one whose
name happened to be highes on the combobox list. I am sure that poor guy would
not be very amused.
My suggestion: Change the design of the combobox in such a way that the
specified select clause gets past through to the database, and let the database
deal with it, without any preprocessing within Knoda. Other applications do it
also in this way.
In the meantime,and until a passthrough can be implemented, has anybody any
idea on how to deal with this problem? Any useful suggestion is most welcome.
Egbert
---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
