Re^3: uninitialized value in Tk::DBI::Table

I just found out, that you even't can't use DBI::Table, if 2 (or more) identical rows in your database...

HELP!!!

element "18-02-2005 09:45:10" already exists at E:/Perl/site/lib/Tk.pm line 228.

at E:/Perl/site/lib/Tk/Derived.pm line 467

Comment on Re^3: uninitialized value in Tk::DBI::Table

Replies are listed 'Best First'.
Re^4: uninitialized value in Tk::DBI::Table by runrig (Abbot) on Feb 18, 2005 at 18:26 UTC
The way Tk::DBI::Table currently works, is that the first column selected is assumed to be a primary key, and so it must be unique. If you have no unique columns, then you're out of luck. I have an idea how the module should be patched, but no time to work on it. I've also emailed the author but have not heard back yet. And to answer your earlier question, no, I can't sort on the first column either.	[reply]

Replies are listed 'Best First'.

Re^4: uninitialized value in Tk::DBI::Table
by runrig (Abbot) on Feb 18, 2005 at 18:26 UTC

The way Tk::DBI::Table currently works, is that the first column selected is assumed to be a primary key, and so it must be unique. If you have no unique columns, then you're out of luck. I have an idea how the module should be patched, but no time to work on it. I've also emailed the author but have not heard back yet.

And to answer your earlier question, no, I can't sort on the first column either.

[reply]