SC9 - an epic failure, for me at least.

Scriptcase 9 Discussion
#1

OK, as with every version upgrade since 5, migrating projects has again proved to be an epic failure.

The only difference this time was that SC gave the appearance that it succeeded.

ODBC/MS-Access, well, enough said. After days of stuffing around I had to give up to protect my blood pressure and general well being.

SO I had a go at a mysql 5.7 based project. This is a simple grid project that gets its data from a couple of VIEWS the user can search. It was running OK in SC7 and then SC8 after yet another re-write because migration failed.

  • Check the data connection - OK
  • Check the field lists - OK
  • Test the grid SQL in SC9’s database tools (SQL builder) - OK

Generate - OK

Run from the IDE- * FAIL!!

Error Error while accessing the database
SelectLimit(SELECT IndexNumber, RegisterCode, LastName, FirstName, Died, SectionID from view_registerdata , 12, 0)

Riiiight, do a quick test:

  • NEW PROJECT
  • Use a DB connection from above project
  • Test connection - OK
  • Use the VIEW view_registerdata
  • Check its working in SQL Builder
  • Create a simple grid application
  • GENERATE > RUN

FAIL - Same runtime error

Get rid of of the view_registerdata and build a simple SQL string with SQL Builder. Delete existing grid app. DO a new one. Use simple SQL. Generate. Run. FAIL. Same SelectLimit() error.

Do an even simpler test on a table in a mysql 5.7 data

WTF!!??

And this thing went through “beta” testing???

Anyway, I just don’t have the time or inclination to continue.

But good luck to the rest of you.

#2

I lost two weeks with this version 9. This is the major disadvantage using a RAD like this. I will have to wait until the version is stable. Go back to 8.1 is not in may plans.:mad::mad:

#3

The MS SQL part aside, we are struggling with this system nearly a week now.

Installation and convertion from SC 7.1 which looked to be okay and wasn’t too difficult, but now only half of the applications work. No error messages, Just a blank page/widget. Great stuff.
The reason seemed to be fixed by adding at least one function to the tool bar on every widget, but I it still isn’t working on another browser. I logged out from admin panel and had the same result again before fixing any app.
I have no idea what this behaviour might be. Is there some kind of rights management or limitation of the test version? why are some apps working and others not? why am I not able to save and publish any changes permanently?
Why are there localizations which are not complete? English is the way to go. English manual with portuguese screenshots? Really?

I cannot fix the IDE myself, because it’s all encrypted to earn money. Why should I pay for a broken system I cannot use or even test properly?

This is not evaluation, it’s frustration at its finest. Rant over. :wink:

SC might be a mighty tool, but for me as beginner it struggles with basics and GUI flaws.