Hi,
I am using Servoy 5.2.11 for a clients solution (developing on Mac Lion, have installed the Java r26 as mentioned in one of the other threads because of hanging with long script files)
I have been making some changes to a solution I created a while back that the client needed and I want them to test.
First problem is I needed to create a small table to hold some temporary data (a list of Patient IDs they had viewed during a session), so I created a table that had 4 columns
ID - PK - servoy seq
uuid_string - varchar(50)
id_patient - integer
dt_last_view - datetime
this seemed to be fine, but then every time I quit and went back in, it forgot that that ID was a servoy seq!
I would set it again, save changes, re-launch and it would forget again.
I tried everything I could think of (checked disk permissions/errors, renamed workspace/created new one/imported old one in, reloaded & synced with back-end), but nothing worked.
Strangely, when I opened the ‘.dbi’ file for the table, it did not have all of the columns there.
First time it only had the ID/PK column, with the correct auto-enter settings (from checking against another dbi)
then I changed 2nd column name to ‘temp_u_string’ and it added that column to rbi, but not other ones…
I then tried deleting and recreating whole table, this time rbi had NO columns in it, yet still listed them in Developer [from back-end??]
I gave up in the end and created another table with a different name, but same columns, which worked and then re-linked stuff to that.
Second problem, I also added a new column ‘flag_gp_referral’ [integer] to an existing table and put it onto a form set as RADIOS with a value-list
Y|1
N|0
so it’s a binary flag displaying as Y or N
When I tried to set a value in smart client it didn’t work
I had no other settings (other scrollbars off) on it. I have done this loads of times on other forms/solutions.
If I tried changing it just to a plain default text field, still wouldn’t work (enter a value, tab out, value disappears) [other RADIOS on same form work, copied one and changed it to that data provider, worked once, then stopped]
When I make changes to form & save, Servoy beeps, but no dialog or error appears anywhere, delete that field & save, no beep
Tried exporting solution and uploading to clients test server, didn’t work.
Set value to 1/Y in back-end, it showed in client, but as soon as I tried to change it to 0/N, value disappeared (and showed null in back-end)
Help???
Thanks
Rafi
