WebSite X5Help Center

8 ODPOWIEDZI - 1 POMOCNY - 1 PRAWIDłOWA ODPOWIEDź
Incomedia
Claudio D.
Incomedia

Hello Barry,

Does the database table you are using contain a primary field?

Many thanks!

Czytaj więcej
Posted on the from Claudio D.
Barry Maloney
Barry Maloney
User
Autor

yes

Czytaj więcej
Posted on the from Barry Maloney
Yerson R.
Yerson R.
User

I had the same issue recently, perhaps ... you are using column names that contain "spaces" something like "TABLE 1" and should be "TABLE_1" or "TABLE1" (kindly claudio fix my issue)

Czytaj więcej
Posted on the from Yerson R.
Barry Maloney
Barry Maloney
User
Autor

Thank you Terson,

I don't have that issue... No spaces,

Barry

Czytaj więcej
Posted on the from Barry Maloney
Barry Maloney
Barry Maloney
User
Autor

sorry...Yerson, for my fat fingers.

Czytaj więcej
Posted on the from Barry Maloney
Yerson R.
Yerson R.
User

Hi Barry... look, I attach a sql test file, review it and compare it with what you have, maybe helps you.
this was the one that finally worked for me after several attempts. (With the help of Claudio)

here is my test table working.

http://www.vbox.pro/test/pagina-1.html

Czytaj więcej
Posted on the from Yerson R.
Barry Maloney
Barry Maloney
User
Autor

Thank you Yerson,

The only thing I changed was the location of the ID column. Once I moved it to the first position to suit your example it worked. I don’t know what would happen if one used a different type of primary key apart from one that uses auto numbering (1,2,3,4, 5...)
But this time it worked and I thank you

Barry

Czytaj więcej
Posted on the from Barry Maloney
Yerson R.
Yerson R.
User

cool Barry, i'm glad you have been able to solve your issue...

Czytaj więcej
Posted on the from Yerson R.