DBF table with String as PK not showing its data

Classic Servoy
1

Hello,
I am working with DBF tables
Problem: I have a simple form which is not showing its data.
When i check the size of the foundset at the onshow method it is 0
If i change the table’s form for other table with number as PK, shows the data normaly.
We want to keep the string attribute as PK
Does anybody a similar issue?
Thanks for your help.
BTW: the table has data

2

Did you set the “row ident” property for that column?

3

yes i did.

4

What is the difference between the table that works and the table that doesn’t work?

Are the table and column names all lowercase? I recently saw similar problems with DBF tables that were in mixed case.

Which jdbc driver do you use?

5

The names of the colomns are:

id_form (Text, PK)
nom_form (Text)

All in lower case.
One table that work ok have the follows structure:

id_pais (Integer)
id_depto (Integer)
id_barrio (Integer, PK)
nom_barrio (Text)
The only difference i can see is the PK one text and the other integer

6

mo_ca_mo,

Are there any errors in the logs?

Rob

7

No error message is showed. The only fact is that the data is not loaded

8

And if you turn on tracing in the properties file (quit developer first, set tracing log4j config, start developer), what queries do you see or your form?

http://wiki.servoy.com/display/public/D … g+Settings

Rob