ScriptCase v8.0.018 (11-17-2014 20:02)

Scriptcase 8 Changelog
#1

Specific correction

  • Fixed crash problem when accessing the menu application in firefox.
    (Will be necessary to clear the browser cache)
  • Fixed crash problem when accessing the HelpCase.
  • Fixed problem using calculator in form application.
  • Fixed problem in theme of code editor in library.
#2

Compilatation is taking forever.

With this new version compilation is taking a tremendous amount of time. Something is broke. Please check it out.

#3

my menu is broken, can’t access. any solution to fix it ?

menu-not-show.jpg

#4

Hmmmm…Improved performance for menu applications…

My menu items are all gone…

Dave

#5

how to downgrade from ScriptCase v8.0.018 to ScriptCase v8.0.017, because we lost menu setting ? PLEASE HELP

#6

Hello,

  • Fixed crash problem when accessing the menu application in firefox.
    (Will be necessary to clear the browser cache)
#7

I think the current problems are big enough!! :smiley:

Dave

#8

Ok, it was a cache issue regarding the menu. Unfortunately there are other obscure bugs and we reverted back to version 17 so I can’t tell. I see that you removed the download, but we already implemented it. I’ll wait a while before I do a next upgrade…

#9

Albert, clear the browser cache and your menu is ok …

Bug:
“Select TOP 10” in Grid / SQL delete the field definitions. Without “TOP 10” all is ok …

#10

Reinhard, we have all kind of obscure bugs which are not related to the cache …

#11

Unfortunately …

Bug:
In Grids i can not select datatype “SELECT” for integer fields (“SELECT” is not in the list …).

#12

[QUOTE=RHS;29566]Unfortunately …

Bug:
In Grids i can not select datatype “SELECT” for integer fields (“SELECT” is not in the list …).[/QUOTE]

You mean in a editable grid of forms? Because in a grid you don’t have select as you don’t have any input?

#13

Hello Mr. Reinhard,

Please, tell me more about this problem with SQL.
This problem has already occurred before or after the last update?

Concerning the use of TOP in SQL, ScriptCase already uses automatically TOP in SQL Server.
I advise you to enable debug mode in the settings of the application to get a better analysis of the problem.

#14

John, i have make a simple grid with “SELECT field1, field2, field3 FROM myview” etc. Thats ok. Then i change to “SELECT TOP 10 field1, field2, field3 FROM myview” and the field definitions go away …

Thats only a test for a grid and not so important. But, when I not can use TOP, how can I restrict the result to 10 records?

#15

Hello,

I was doing some tests to simulate your problem, but I noticed that the 8.0.010 update we’ve added support TOP function in SQL Server.

ScriptCase v8.0.010 (09-26-2014 01:03)

New functionalities

  • Added support to TOP function for MS SQL Server databases.

See the attached image.

If you have any problems, let us know what SQL you are using and the SQL Server driver.

top.png

#16

Hello John,

look at this examples:

A simple SELECT from a view:


SELECT TOP 5
    Adresse,
    sFaellig
FROM 
    dbo.ef_vwSCOffenePosten
WHERE sFaellig > 0
ORDER BY sFaellig DESC

Thats ok. Now i’am extend it with GROUP BY:


SELECT TOP 5
    Adresse,
    SUM(sFaellig) as sFaellig
FROM 
    dbo.ef_vwSCOffenePosten
WHERE sFaellig > 0
GROUP BY Adresse
ORDER BY sFaellig DESC

After run the application:

The grid fields are now undefined, but i change only the sql string …

sc_top_1.png

sc_top_2.png

#17

Hello John,

after other edits i mean that not TOP but SUM is the problem … (i change the field “sFaellig” to “SUM(sFaellig) AS sFaellig” and the error appears).

#18

Hello,

Please make sure your SQL is usually running on SQL Builder or any manager of SQL Server.

sum.png

#19

John, my SQL code is always running in the SQL Server Management Studio before i write a post here …

In your example try this: change “SUM(freight) AS Total” to “SUM(freight) AS freight” and compile this. Presumably the error (grid fields undefined) occurs …

#20

Hello,

As you can see for yourself, I’m trying to simulate the problem by replicating the same way you’re doing, and even then no problem occurs.

I want to ask you to verify some situations:

  1. Run the command in SQL Builder and check if any error occurs.
  2. Create a new application with the SQL used and check if it works.
  3. If we can not simulate your problem, I ask you to send me your application along with the CREATE the tables involved to e-mail j.lennon@netmake.com.br

This way I can try to simulate your problem locally.
Just one more question, what is the connection driver are you using?

I also ask that you try not to get upset, because we are all trying to help and solve the problems as quickly as possible.
Once the problem is found, I will request that it be fixed in the next update.

freight.png