calculation in mysql not working with client

Classic Servoy
1

Hi Guys,
I just ran into an interesting problem. I have a series of calculations being done in mysql, using the calculations tab in servoy. Works fine in developer, yet when I access the form in client, I can’t even see the records that exist in the database.

When I enter a value into a field (using the client) to start the calculation, I get a “no record exists, create one first”. When I go to create the record, it gives me a new record, but when I save it, I get a can’t save record error.

I thought, no problem it’s just a permissions thing so as a test, I gave the client the same user and password to the database that the developer has, with the same results. I even granted all permissions. same result.

This really has me stumped. There are no error messages in the log files, either in the server or in the client, nor in the mysql logs.

Any help would be really appreciated
Thanks
Graham

2

Hi Graham,

just a thought, check that the primary key on the table is set up correctly. Are you generating pks in mySQL or in Servoy?
Servoy needs to know how to uniquely identify a record and how the pks are generated, otherwise you will get all sorts of weird things happening…

3

Thanks for the quick reply.

I tried that, but got the same result.

Turns out that I am using a developer on Windows XP, running against the repository on a Linux box (Fedora Core 3), and when I export from the windows developer, it shows up in the Server on the Linux box, but when activated doesn’t work correctly.

If I start the developer directly on the Linux box, export the file (creating a new version) from there, everything works as it should.

Graham