[SOLVED]Work Around Found: Form generation does Not work - anyone else?

Scriptcase 7 Bugs
#1

I’m running 6.00.0028 on a Windows 7 machine.
Database is SQL Server 2005.

I am evaluating ScriptCase. Functionally, it looks Extremely promising.

However, Forms generation doesn’t work at all for me.
When we try to generate we get the error:

Analyzing SQL Statement
Fatal error: Call to a member function FieldCount() on a non-object in C:Program FilesNetMakev6wwwrootscriptcasedevellibphpdatabase.inc.php on line 838

Grid and Search generate fine.
Form - does not.

Anyone else see this?

|
| Edit: I found a way to work around the problem:
|
| After:
| - Shortening all column names
| - Removing all table relationships
|
| I can now generate code for any table.
|
| I am hoping that the company will look into this because it is a serious limitation for SQL Server users.
|

#2

Re: Evaluating - and Form generation does Not work - anyone else?

Hello,

Are you unable to create any form application? Please make a manual update and if the issue continues, contact our support as a Trial user.

regards,
Bernhard Bernsmann

#3

Re: Evaluating - and Form generation does Not work - anyone else?

I can’t generate any Form with any table. Even a two column table.

Already manually updated. That didn’t help.

I suspect SQL Server support in this product isn’t heavily tested. Something tells me this wouldn’t
be happening if I was using mySQL - which we can’t use.

I opened a ticket for this at the beginning of the week. First, I couldn’t generate a Grid for one of my tables.
Through trial and error, I eventually figured out that SQL generation for the table was failing - because the name of one of the columns was too long. I hoped for a fix from tech support, which didn’t happen, and I decided to walk around the problem by shortening the name of the column.

That got me back in business, and I was able to generate a Grid or Search for any table.

Yesterday was the first time I tried a Form, and - I couldn’t generate for Any Table.

I’m dead in the water. Hoping someone at your company can help get this eval back on track.
Disappointed.

#4

Re: Evaluating - and Form generation does Not work - anyone else?

Had another response from tech support, to create a second instance of ScriptCase in a scriptcase2 folder.

Took the time and built all that up. Walked through the configuration screens for the new instance.
All went well.

Same problem. Can’t generate any Form.

The messages on screen clearly indicate that ScriptCase is choking on SQL it generated.
[size=18pt]Isn’t there any way to see what that SQL was? [/size]

#5

Re: Work Around Found: Form generation does Not work - anyone else?

Work around was found. See modified original post.