Varchar primary key

[Julo]

Hi did fabrik 3.0a2 support Varchar primary key?
I have to create a list from a table whose primary key is a varchar.
Any idea?
Cheers,
Julo

 

[rw1]

do you mean as opposed to having the 'id' column, which is int(11), as the primary key?

i'm not sure myself but i'd be interested to know also.

 

[jfquestiaux]

I seem to recall that was causing issues in some situation, like with joins for instance.
But I think for a "simple" list, it should be OK.

In the meantime, you should update to the latest Fabrik3 : your alpha version is quite old!

 

[Julo]

jfquestiaux/rw1, Thanks.

I've updated Fabrik but the problem remains the same.
In fact I can put a VARCHAR as primary key, but when I do an insert from my list, the field defined as primary become an integer.
example:
If I have a table that has fields (country, region, state) with the primary key country (VARCHAR).
If I add the record (France, Centre, Loiret) from the list, I get (0, center, Loiret) after saving.

 

[rob]

looks like there were a couple of issues which were stopping that from working, try updating from github as I have added some fixes.
You will probably have to edit and save you list to update the pk settings.

 

[Julo]

I made the changes, but there's a new problem.
When I create a new list, the link to table area does not load the tables contained in my database.

 

[rali]

Hi, try to put a limit on the VARCHAR declaration like VARCHAR(150). let us know of the results

 

[rob]

@julo do you get a javascript error?
have you checked that the connection details are correct?