Bug in SC7 - running a form with all navigation buttons removed from toolbar

[onmountain]

Hi. This has happened to 2 different forms I have built in SC7.1

I am using an eval copy of SC7.1, version 7.01.0009

In these forms, they are editing a table with only one record, so I set the WHERE to be: ID=‘1’

I remove all unused buttons from the form toolbar, such as Insert, Delete and so on. So far all is good.

From the bottom of the toolbar I do not need any of the navigation buttons. When I remove them and run the app to test it, I get not a error, but an unexpected screen appears. I have attached a screen grab. It is the name of the app, it is asking for “id” (which is not one of my variables). And it has a button for index. If I click teh index button, the app runs. The “id” showingf os lowercase. The ID field in my form is upper case. I use no variable, local or global in the test forms.

It looks like the type of input you would expect in an app you are running from inside SC, when it is expecting a global variable. In this case, I am not using any global variables…

I put back the buttons and removed one by one and found that it is (of course) the “Last” button. If I remove that one I get the message when I run the app. If I put “Last” back, it just runs normally.

So the “Last” button removal is somehow affecting the code , making the system believe that a value for a variable “id” is needed before running the app.

I also can get rid of the error if I leave atleast one of the navigation buttons on the bottom toolbar. But if I put another type of button, like “Update” on the bottom toolbar without a navigation button(s) the bug happens.

I do the same thing in forms in SC6, and I have never seen this behavior before.

Workaround - Leave the “Last” button on the bottom toolbar and

Can SC staff please verify that they have logged this error for correction on a future release?
Thanks,
Jamie

[bartho]

Hello Jamie,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

[onmountain]

Thank you!
Have a great weekend,
Jamie

[bartho]

You too!!

Thanks!

[bartho]

Hello Jamie,

I was informed by our bugs team that this is actually the default behavior of form applications.

Have you tried a workaround to this? Perhaps leave the “last” button as you did, and hide it using sc_btn_display.

regards,
Bernhard Bernsmann

[onmountain]

Hi. That seems strange to me. This does not happen in Sc V6, where I have removed the bottom toolbar buttons with no problems many times. I almost never use the bottom navigation buttons. Now in V7 I get what looks like an INTERNAL variable causing a prompt. There must be a loop on forms that uses a var called id, and now with no buttons it has no initial value.

If it is the default to not allow us to remove all buttons, then why does the SC toolbars GUI have the option to do so? I have not tried to remove the button with the macro, but never had to in the past.

I just tested in SCv7.1 with the command sc_btn_display (‘last’, ‘off’);

It worked and removed the Last button. Thanks.

However, seems like you should look at your code to stop the ‘id’ prompt when all buttons are removed in the form settings - toolbars.

Thanks for getting right back
Jamie

[bartho]

Jamie,

I’m glad you were able to solve the issue.

I will contact our bugs team again regarding your last feedback.

regards,
Bernhard Bernsmann

[Danno2013]

Yes - I have had same issue in version 7 - SC support is extremely disappointing, shame because this is a strong application…I have had to outsource to PHP community to get support/fixes!

[nmjohnlasantos]

Hello,

Forgive me if I’m not completely understood the problem, but from what I understand, this is a standard behavior of Scriptcase.
What happens is that when we run a form, Scriptcase does a count of all records in the table (you can check debug mode enabled, the first line is SELECT count (*) from table) so we can create a pagination the from the first to the last record based on that score.
If you remove all the navigation buttons, the Scriptcase can not identify which record should be displayed, so it generates a test application for you to inform the ID.

Anyway, if my explanation is unclear or not related to the problem, explain step by step to your problem.

[nmjohnlasantos]

[QUOTE=onmountain;17978]

The “id” showingf os lowercase. The ID field in my form is upper case.[/QUOTE]

The database that you are using is case sensitive?
Try to disable the case sensitive option in your application settings SQL.

[aquiles]

this situation occurs in V6 too, and runs ok when you use these form in a link as dialog information form

by example, in a grid have only the customer name as link and when the user click on this link display a modal window with the dialog form contains more information about the customer (address, telephone, mail, city, country, etc)

this form do not have any buttons (top or bottom) only close button and is very useful

if you want a form for editing the customer, then have another form app with all the necesary buttons enabled

Aquiles