I did a lot of manual querying to fill value lists recently in a solution with Firebird as the data provider. Now I’m trying to do the same thing with MySQL 3.x as the data provider and queries return “undefined.” Can’t figure it out – maybe this is a bug?
what does dataset.getExceptionMsg() tells you?
Jan Blok:
what does dataset.getExceptionMsg() tells you?
It returns null.
When inspecting the screen shot better I concluded that you likly have no rows in the dataset (and table), did you try getMaxColumnIndex()/getMaxRowIndex()?
size = 11 is the max rows returned. So it’s recognizing all the columns (query = select * from…) and all the rows. I tried the code on several different MySQL tables and get the same results. Same code works fine with Firebird.
Do Servoy forms itself work on those tables? Can we have a look at your solution?