Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
61
Web Server - Ask For Help / Re: SecwinWebLoginForm generated variable clash
« on: March 18, 2016, 01:38:58 PM »
Hi Bruce,
Files attached.
Thank you very much.
Best regards,
Marcos
Files attached.
Thank you very much.
Best regards,
Marcos
62
Web Server - Ask For Help / Re: OT: Windows 10 slows down my NT apps (from internet)
« on: March 10, 2016, 02:07:22 PM »
Hi Robert,
I had something similar running Clarion with TPS files on W8.1 Pro. It was very slow access to files. I had at that time a Virtual Machine with XP that ran Clarion apps faster than W8.1.
After some googling I found that if you set manually Virtual Memory Management in Advanced settings to a fix value this happens. When changed to let Windows manage the size of paging file for each disk, Clarion applications ran normally.
Cheers
Marcos
I had something similar running Clarion with TPS files on W8.1 Pro. It was very slow access to files. I had at that time a Virtual Machine with XP that ran Clarion apps faster than W8.1.
After some googling I found that if you set manually Virtual Memory Management in Advanced settings to a fix value this happens. When changed to let Windows manage the size of paging file for each disk, Clarion applications ran normally.
Cheers
Marcos
63
Web Server - Ask For Help / Re: SecwinWebLoginForm generated variable clash
« on: March 10, 2016, 01:48:26 PM »
Hi Bruce,
I'd picked Web56 example (menus) and followed Secwin 6.36 documentation "JumpStart: Adding Runtime Access control to a NetTalk Webserver application" Phase 1 until step 4 generating Access Controls and stopped.
If you open SecwinWebLoginForm procedure embed source you could check that the second variable declared here is "loc:user" as string(100). On line 103 you should find "Loc:user" as long.
When compilling at this point it warns that we have a "label duplicated: second used LOC:USER" on line 111.
Thank you Bruce.
Best regards.
Marcos
P.S.: I'm using Clarion 8ee 9661.
I'd picked Web56 example (menus) and followed Secwin 6.36 documentation "JumpStart: Adding Runtime Access control to a NetTalk Webserver application" Phase 1 until step 4 generating Access Controls and stopped.
If you open SecwinWebLoginForm procedure embed source you could check that the second variable declared here is "loc:user" as string(100). On line 103 you should find "Loc:user" as long.
When compilling at this point it warns that we have a "label duplicated: second used LOC:USER" on line 111.
Thank you Bruce.
Best regards.
Marcos
P.S.: I'm using Clarion 8ee 9661.
64
Web Server - Ask For Help / SecwinWebLoginForm generated variable clash
« on: March 07, 2016, 06:58:21 AM »
Hi,
In SecwinWebLognForm generated procedure it was created with:
loc:user as string(100)
loc:user as long
After compilation it says that is using second variable the long one
Best regards,
Marcos
In SecwinWebLognForm generated procedure it was created with:
loc:user as string(100)
loc:user as long
After compilation it says that is using second variable the long one
Best regards,
Marcos
65
Web Server - Ask For Help / Insert user Autoincrement Error
« on: March 02, 2016, 11:24:40 PM »
Hi!
I'm testing C8 WebServer NT9.06 application with Secwin 6.36 and MySQL including Security File in it and inserting me with two different e-mail accounts with the same name/surname. Ok, I'm forcing an error but application gets weird.
When trying to add second user: it pops a message at Server side with an Autoincrement Error in key ope:IDKey and blocking client side.
In Clarion Dictionary we have a table secwin_operators (Memory) with a key ope:KeyID that is set as unique and autoincrement.on a Int field ID, ok. There is another key ope:Key that is composed of SiteLimiter, Surname and FirstName as unique. It's ok too.
But in the MySQL side on a set of Secwin Security Files created we have a table secwint_operators5 with a key ope5_IDKey.composed of SiteLimiter, Surname and FirstName as INDEX. Shouldn't be an UNIQUE index?
So I try changing that key as UNIQUE that prevents from Autoincrement Error but with the following side effects:
- Insering operator same name and surname says that "This user could not be added", but in client side operator browser appears with Number = 0.
- Trying to change this user it's showed in form. Seems that this record is in memory table. Press Save "Invalid user Error adding user".
- Trying to delete gives an error "Invalid user: Error adding user".
- Memory table don't allows this because of key ds_ope:Key (SiteLimiter, Surname, FirstName), Unique, exclude empty should prevent this.
- After session timeout login with a valid user gives me error. Trying again ok.
At the end the user was added to a MySQL table and any attempt to login gives me Login Fail. I have to delete the second user directly in MySQL to get to normal.
Is there a way to prevent this without hand code?
Thank you.
I'm testing C8 WebServer NT9.06 application with Secwin 6.36 and MySQL including Security File in it and inserting me with two different e-mail accounts with the same name/surname. Ok, I'm forcing an error but application gets weird.
When trying to add second user: it pops a message at Server side with an Autoincrement Error in key ope:IDKey and blocking client side.
In Clarion Dictionary we have a table secwin_operators (Memory) with a key ope:KeyID that is set as unique and autoincrement.on a Int field ID, ok. There is another key ope:Key that is composed of SiteLimiter, Surname and FirstName as unique. It's ok too.
But in the MySQL side on a set of Secwin Security Files created we have a table secwint_operators5 with a key ope5_IDKey.composed of SiteLimiter, Surname and FirstName as INDEX. Shouldn't be an UNIQUE index?
So I try changing that key as UNIQUE that prevents from Autoincrement Error but with the following side effects:
- Insering operator same name and surname says that "This user could not be added", but in client side operator browser appears with Number = 0.
- Trying to change this user it's showed in form. Seems that this record is in memory table. Press Save "Invalid user Error adding user".
- Trying to delete gives an error "Invalid user: Error adding user".
- Memory table don't allows this because of key ds_ope:Key (SiteLimiter, Surname, FirstName), Unique, exclude empty should prevent this.
- After session timeout login with a valid user gives me error. Trying again ok.
At the end the user was added to a MySQL table and any attempt to login gives me Login Fail. I have to delete the second user directly in MySQL to get to normal.
Is there a way to prevent this without hand code?
Thank you.