[SOLVED]Form generation results in all labels (no editable fields)

Scriptcase 7 Bugs
#1

I’m a beginner and I’m following along your video about how to make a form. I am using SC v6.0.005. I installed it just today, and it said it was out of date, so I updated it using the update dialogs provided, so I am definitely on the latest update of SC v6.0.005. I have successfully connected to Firebird 2.5x. I create a form according to the instructions in the video (I have not made any manual modifications to any fields), and instead of getting a form with editable fields, all my fields are labels (not editable) except for VARCHAR(3). When I edit one of the VARCHAR(3) fields and click “Save”, the application freezes, the data is not saved, no buttons or menus work except the Exit button.

Also, every time I start up SCv6, and log in, my project has a little number beside the title. Example: It used to say just the project name jet_gp then, after logging back in after some freezes, it said jet_gp (2) for a few times. A few more freezes and logouts/ins it now says jet_gp (3)
Could that number have anything to do with my freezing and field generation problem?

#2

Re: Form generation results in all labels (no editable fields)

This problem persists in SCv6.0.007. I created a new form, ran it, edited one of the edit box fields (most are still shown as labels) and I clicked Save. I have Firebug running and went into the log. Here is what it said:

document.F1.adnl_cntct_info_limpa is undefined

I followed the link from the error message to line 5672 of what looks like a generated form file, which contains:

var var_adnl_cntct_info_limpa = document.F1.adnl_cntct_info_limpa.checked ? “S” : “N”;

I’m using a Firebird BIGINT field, which may be causing problems. Can you investigate it please?

#3

Re: Form generation results in all labels (no editable fields)

I’ve been playing with field types, and it seems to make a difference. Is SCv6.0.007 able to handle Firebird BIGINT correctly? (seems not. They are defined as Text fields… they should be Integer) Something to do with field types is affecting if the fields that should be editable are shown as labels or edit boxes. I could make further progress if the FORM apps had a spot where I could edit the SQL directly… kind of like the GRID apps. At the moment, I cannot find any way to cut out the BIGINT fields from the form SQL. All I have access to is the WHERE clause and ORDER BY clause, not the SELECT clause. SCv6 assumes I always want all fields in my form generation. It does no good to hide the field… the hidden field(s) still causes the labels versus edit box problem

#4

Re: Form generation results in all labels (no editable fields)

GOTCHA! It has something to do with Firebird’s BIGINT field. I created a form based on a table without BIGINT and SCv6 worked just like in the video. It created a form with edit boxes (correctly) and when I edited a field value, I was able to commit. (Save).

Can you check/test SCv6 against Firebird BIGINT as well as BLOB SUB_TYPE TEXT, which SCv6 always interprets as “Image” when it should be “Multiple Lines Text”. Create a test Firebird DB with all field types, and test and you’ll see what I mean. I could have found this solution sooner if SCv6 would allow me to directly edit my form’s SQL statement, so I could manually cut out or CAST() the unwanted fields before they are even generated.

#5

Re: Form generation results in all labels (no editable fields)

Problem still persists in 6.0.015 (2012-Apr-24) Haven’t been able to get started using SCv6 for several months now. Hoping for a fix soon.