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.
16
Web Server - Ask For Help / Re: Add a Save and Continue to edit button
« on: January 24, 2024, 03:13:40 AM »
Hmm. Ok Update time.
was due for that anyway
was due for that anyway

17
Web Server - Ask For Help / Re: Add a Save and Continue to edit button
« on: January 23, 2024, 09:32:02 PM »
Hi Bruce,
That approach isn't working.
There are a couple of required fields, the main one being be the equivalent of an invoice customer that is required before saving. Attempting that in Preinsert gives me a relational integrity message.
I'd be happy if I could somehow chain from an insert to a change, so instead of returning to the browse immediately go to a change form.
or something like that.
That approach isn't working.
There are a couple of required fields, the main one being be the equivalent of an invoice customer that is required before saving. Attempting that in Preinsert gives me a relational integrity message.
I'd be happy if I could somehow chain from an insert to a change, so instead of returning to the browse immediately go to a change form.
or something like that.
18
Web Server - Ask For Help / Add a Save and Continue to edit button
« on: January 19, 2024, 05:54:39 PM »
I want 2 button on a form.
1 being the normal save and return to browse,
2 being a save and continue to edit the form.
Reason: I like having relational integrity on. I have a number of tabs on the form with related lists. I only want to be able to show/add to the related tables if I have saved the parent (the row on the form). Obviously this really only applies when inserting a new record.
How might one achieve this?
1 being the normal save and return to browse,
2 being a save and continue to edit the form.
Reason: I like having relational integrity on. I have a number of tabs on the form with related lists. I only want to be able to show/add to the related tables if I have saved the parent (the row on the form). Obviously this really only applies when inserting a new record.
How might one achieve this?
19
Web Server - Ask For Help / Re: OT - Anyone working with NDJSON?
« on: December 26, 2023, 06:49:25 PM »
It?s also called JSON Lines
https://jsonlines.org/
I?ve come across it while mucking about with barcode data, but done little with it.
https://jsonlines.org/
I?ve come across it while mucking about with barcode data, but done little with it.
20
Web Server - Ask For Help / Re: json group in queue
« on: December 11, 2023, 02:58:08 PM »
If you load the entire json into that clarion structure I "think" you'd refer to it as element.plan.id
21
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« on: December 04, 2023, 03:27:06 AM »
I think I understand what you want. and no, a view cannot do that.
The View is doing exactly as it should in duplicating everything. A view does that, it flatterns the data and gives you everything.
If you're backend is TPS, you need to do some programming, maybe with a temporary table.
What you want in SQL terms is called a UNION, and you need to create that as an SQL VIEW on the backend.
The View is doing exactly as it should in duplicating everything. A view does that, it flatterns the data and gives you everything.
If you're backend is TPS, you need to do some programming, maybe with a temporary table.
What you want in SQL terms is called a UNION, and you need to create that as an SQL VIEW on the backend.
22
Web Server - Ask For Help / Re: Webserver + secwin 7 stopped using altered access rights
« on: July 17, 2023, 04:17:37 PM »
Unfortunatly Bruce, that doesn't stack up.
A supervisor level could log in and have all access.
The operator that logged in afterwards had nothing.
A disconnect should also have raised some messages somewhere.
It was really like no group overrides were being applied.
I'm sort of assuming some memory problem.
A supervisor level could log in and have all access.
The operator that logged in afterwards had nothing.
A disconnect should also have raised some messages somewhere.
It was really like no group overrides were being applied.
I'm sort of assuming some memory problem.
23
Web Server - Ask For Help / Webserver + secwin 7 stopped using altered access rights
« on: July 14, 2023, 09:14:39 PM »
A Nt webserver using secwin 7 and multi-tenant
Been up and running since late May.
This week so one was able to access anything.
The rights are applied to a group that is normally deny with appropriate procedures set to access.
Login was ok, but nothing at all was available. Looked like the overrides of the group were ignored.
No messages in the log.
This was fixed by restarting the service. Then back to normal.
Anyone have any ideas as to what went wrong?
Been up and running since late May.
This week so one was able to access anything.
The rights are applied to a group that is normally deny with appropriate procedures set to access.
Login was ok, but nothing at all was available. Looked like the overrides of the group were ignored.
No messages in the log.
This was fixed by restarting the service. Then back to normal.
Anyone have any ideas as to what went wrong?
24
Web Server - Ask For Help / Re: Next freezes browse
« on: June 11, 2023, 02:34:48 PM »
Activate Clarion driver trace and look at that. It could be an error occurring, NTWS is not good with errors from the file system.
25
Web Server - Ask For Help / Re: Failing on Loc:Err = RM.Open()?
« on: June 09, 2023, 10:48:47 PM »
A slight problem with NTWS is that if the file operation fails, you don't always know about it.
I've had a few problems with relational constraints in the DB, and a few other things, that just sort of fail silently.
While using MessageBox catches some, it doesn't catch any that don't notify.
I only found them by turning on the Clarion driver trace and looking at that.
I've had a few problems with relational constraints in the DB, and a few other things, that just sort of fail silently.
While using MessageBox catches some, it doesn't catch any that don't notify.
I only found them by turning on the Clarion driver trace and looking at that.
26
Web Server - Ask For Help / Re: NetLDAP bug in SetUser procedure
« on: May 11, 2023, 08:45:27 PM »
Done
27
Web Server - Ask For Help / Re: NetLDAP bug in SetUser procedure
« on: May 09, 2023, 04:50:29 PM »Quote
How much of the NetLdap code is you, Bruce, someone else?
Mostly Bruce. I added a number of methods, the get attributes one for instance, and I've fixed a few others. Because I was one of the first I found a few missing bits and "would be nice to have"s, so I added them. Most recently was the problem where samaccount and upn names differed.
Quote
But is it you or Bruce who vets this code?
Absolutely Bruce, it all gets filtered through him. But since my dirty fingerprints are on some it I know it better than most.
28
Web Server - Ask For Help / Re: NetLDAP bug in SetUser procedure
« on: May 08, 2023, 03:11:57 PM »Quote
Where are you finding that code, Sean?Sorry I didn't make it clear. That 's code from the login procedure of my nettalk app. I have a configuration item the client fills out for Config:Logon:Domain
So I do some pre-fiddling of the name before sending out for authorization.
Thanks for the additional info. I can totally see the problem. I think it could certainly be fixed in NetLdap, but not easily. the problem, as you say, is the multiple recursion that effectively rebuilds the upn. There is an implied rule that the domain on the upn is always an AD domain.
we'd have to save the first dn in a property perhaps to reuse?
I agree that the \ is a bug.
either way I'm happy to help if you need any
29
Web Server - Ask For Help / Re: NetLDAP bug in SetUser procedure
« on: May 07, 2023, 10:38:59 PM »
Long rants are better than short blow up with no info!
Yes, your assessment of my client is correct. As for plain jane login, I found this in my code:
Now that's very old and may not be needed as such anymore, but it works, so I'm not touching it!
Not sure about your upn of theEmailDomain that isn't in AD , That just seems very odd
Yes, your assessment of my client is correct. As for plain jane login, I found this in my code:
Quote
IF NOT INSTRING('\',parms.pAuthUser) AND NOT INSTRING('@',parms.pAuthUser)
parms.pAuthUser = CLIP(Config:Logon:Domain) & '\' & parms.pAuthUser
END
Now that's very old and may not be needed as such anymore, but it works, so I'm not touching it!
Not sure about your upn of theEmailDomain that isn't in AD , That just seems very odd
30
Web Server - Ask For Help / Re: NetLDAP bug in SetUser procedure
« on: May 07, 2023, 03:45:47 AM »
Thanks the the amazing detail Jane,
LOL Not to worry. I was one of the first users of the LDAP code. In fact I made a number of changes and additions. If you search a few of my comment made it in. So I'm an accomplice here, and I think I also championed upn as a default, it just seemed logical. Unfortunately our strategy didn't last the confrontation with the enemy (client)
Yep, I will confirm you're the lucky one. Took me a good few weeks to figure out what the problem was and and find a solution. so, again my code got added. Not sure how that \ made it through though.
I'll have to digest the rest tomorrow
Quote
I think this problem of defaulting to NetLDAP:UserPrincipalName is actually my doing. In discussing with Bruce years ago the various login names users can enter I think I suggested defaulting to creating a UPN. Shame on me... sigh...)
LOL Not to worry. I was one of the first users of the LDAP code. In fact I made a number of changes and additions. If you search a few of my comment made it in. So I'm an accomplice here, and I think I also championed upn as a default, it just seemed logical. Unfortunately our strategy didn't last the confrontation with the enemy (client)
Quote
In the 20+ years I've worked on AD networks I haven't been part of one where the UPN didn't match the AD domain name until now. (Lucky me.)
Yep, I will confirm you're the lucky one. Took me a good few weeks to figure out what the problem was and and find a solution. so, again my code got added. Not sure how that \ made it through though.
I'll have to digest the rest tomorrow