MultiStepForm With Where Clause in SQL. Need help understanding the Scriptcase Support Replies

Scriptcase 9 Bugs
#1

Hi Everybody. I have been trying to develop the new Multi Step Form Feature. One important aspect was the use of Where Clause in the SQL section of the FORM so that the form can be also used for update of data. But this where clause is not working and I have been contacting support (paid ) from scriptcase. I have got the responses below along with videos. I need some help in understanding . I am approaching for help here as I am past the deadline to my client.
NOTE I AM Attaching the VIDEOS sent by Scriptcase saying the form is working. First the used their sample form for the video.
Next I sent a form of my own and they again sent another video with my sample form, saying it is working.
I am attaching all the videos and my sample form below

  1. SAMPLE Form with table structure Create command
    tablesql.txt (1.3 KB) sc9_202112102011_export_EazeTax.zip (1.3 MB)

  2. Video from scriptcase using their sample form

  3. Video from scriptcase after they tried my sample form. They also gave the following response which I am not able to make much of.

Blockquote

Hello sir, i tested with your form, i did little changes like adding some buttons to the toolbar.
You can see on the video attached that it is working.

Blockquote

Following is my response to the above video from the support team

Blockquote

I am seeing some isssues in the video you have sent

  1. It is asking for input whenever you execute the form. This happens to me when the variable T1CI_Row_ID is a global variable and configured as input. This should not be the case. I have not used an global variable in the sample form I sent you

  2. You said that you have added buttons . Why are these buttons needed ? Are they necessary for the where clause to work ?

Dear Sir, I am paying for the support . As such I think you will have to tell me what is wrong or where I have to make changes in my application. Why dont you send me that form which you modified or any other sample form with SQL where clause working so that I will try to understand and development my application.

How do you expect me to understand from the Video ?

Blockquote

I am sharing these for an additional thought process and support
Thanks
Suresh

#2

Try getting rid of the WHERE statement.
The Unique key is set automatically, when you Run it it will ask you for an id, but normally you would be connecting from another application with that ID in the select button/link.

#3

Yes that is possible. But I am calling this from a top level menu structure.The where clause is required to filter records based on the USER logged in. Is it possible to set the link from the menu ?
And , reply from the support is that the WHERE is functional. So I am trying to find where I am going wrong ?

#4

After log in set you own [UserID] session.
Then just call that in the sql ( WHere user_keyid = [UserID] )
Be sure to set the Global Variable as IN.

#5

Hi @nwdbs that was the whole point. When I am trying to set the Where clause using the global variable or even a static value, it is not working.

#6

Hi Folks,
thanks for your replies. It was a frustrating week trying to get this work and took some support from the Scriptcase support team. Ok I “discovered” (If I may call that as discovery) a weird feature. When the where clause is specified, the tool bar should have the Last button option. Probably this triggers some code in scriptcase to retrieve the filtered record and show. I am attaching a screenshot for who ever needs to use the multi step form with Where filter.

WorkingWithThisSetting
WorkingWithThisSetting1920×1028 144 KB

Though I stumbled on this by comparing each event and setting from the sample form sent by scriptcase support, I want to be sure if this is the right approach. I tried removing the "Last " button option and then adding again. I also tried with other multi step forms. YES this option makes the where clause to work.
But am I right. Please share your opinion. Thanks