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.
1
Your Views and Comments / Africa Clarion WhatsApp Group
« on: October 09, 2022, 08:44:12 AM »
At CIDC2020 in Cape Town recently, we formed a WhatsApp group for Clarion developers in Africa. It isn?t a tech support group (That?s what ClarionLive, ClarionHub and NetTalk Central are for) but it is a way for Clarion developers on the continent to keep in touch, arrange get-togethers, and so on.
So far there are 30 participants, 27 from South Africa.
Feel free to join on https://chat.whatsapp.com/HSdZnjxq18OEYLeXQgC0Yx
Please introduce yourself to the group with your name and what town (and country) you are from, plus anything else you wish to share.
If the link doesn?t work, please send me a message on +2783-310-4966 and I will add you.
Best wishes
Donn Edwards
So far there are 30 participants, 27 from South Africa.
Feel free to join on https://chat.whatsapp.com/HSdZnjxq18OEYLeXQgC0Yx
Please introduce yourself to the group with your name and what town (and country) you are from, plus anything else you wish to share.
If the link doesn?t work, please send me a message on +2783-310-4966 and I will add you.
Best wishes
Donn Edwards
2
The Rest - Ask For Help / Re: Google Calendar API
« on: July 29, 2022, 01:44:28 AM »
This is turning into a nightmare. I don't think I can access the Google API, not without PHP, Node.js, etc. I'm going to have to try something else. 
3
The Rest - Ask For Help / Google Calendar API
« on: July 27, 2022, 01:07:50 AM »
Can anyone share some code snippets or experience using the Google Calendar API? I need to retrieve appointment information from the calendars of various doctors.
Any help will be most appreciated
Donn
CPE 11.0.13630, NT12.44
Any help will be most appreciated
Donn
CPE 11.0.13630, NT12.44
4
E-Mail - Ask For Help / Re: POP3: Deleting yesterday's messages only (SOLVED)
« on: July 08, 2022, 03:25:16 AM »
It's amazing what happens when you re-read the manual, in this case
nettalk3.htm#The_NetEmailReceive_Methods
It's working now
nettalk3.htm#The_NetEmailReceive_Methods
It's working now
5
E-Mail - Ask For Help / POP3: Deleting yesterday's messages only (SOLVED)
« on: July 08, 2022, 01:29:30 AM »
Hi all
I am busy with an app that sends a test email every 5 minutes from 5am to 9pm from the SMTP server mail.mensclinic.co.za to POP3 server mail.petfindsa.co.za. Normally, the mail arrives in seconds, but once the SMTP server gets busy, there can be a delay, anything up to 2 hours. Some of these messages need to arrive within a few minutes because they are being sent to an email-to-sms gateway and the patient has to wait for the SMS to get a one-time pin.
When I send the message, I also write it to a table. A few minutes later, I connect to the POP3 server and start looping through the messages, as demonstrated in the "NetTalk->email->Demo" app and the "NetTalk->email->Email Receive With Dont Download Again" examples.
In the ThisEmailReceive.Done procedure I tried the following:
dtmSentDate DATE
This successfully deleted all the emails, not just the old ones. So I'm obviously not understanding something correctly. Any suggestions, code or advice would be greatly appreciated.
I am busy with an app that sends a test email every 5 minutes from 5am to 9pm from the SMTP server mail.mensclinic.co.za to POP3 server mail.petfindsa.co.za. Normally, the mail arrives in seconds, but once the SMTP server gets busy, there can be a delay, anything up to 2 hours. Some of these messages need to arrive within a few minutes because they are being sent to an email-to-sms gateway and the patient has to wait for the SMS to get a one-time pin.
When I send the message, I also write it to a table. A few minutes later, I connect to the POP3 server and start looping through the messages, as demonstrated in the "NetTalk->email->Demo" app and the "NetTalk->email->Email Receive With Dont Download Again" examples.
In the ThisEmailReceive.Done procedure I tried the following:
dtmSentDate DATE
Code: [Select]
if dtmSentDate < today() then
self.OptionsDelete = true
self.DecideToDelete
end This successfully deleted all the emails, not just the old ones. So I'm obviously not understanding something correctly. Any suggestions, code or advice would be greatly appreciated.
6
Web Server - Ask For Help / Re: Alignment of two browse forms side by side
« on: July 15, 2021, 09:03:54 AM »
I added the following property: align-items: flex-start;
to the following CSS
.nt-form-flex-row,.nt-form-grid-row{
align-items: flex-start;
}
to the following CSS
.nt-form-flex-row,.nt-form-grid-row{
align-items: flex-start;
}
7
Web Server - Ask For Help / Re: Alignment of two browse forms side by side
« on: July 02, 2021, 02:03:53 AM »
Thanks Jane
I have seen Bruce demonstrate experimenting with CSS using the Google Chrome inspect tool. And I have designed my own button for this particular app. I was just hoping there would be a setting somewhere in the multitude of NT options that would fix the problem without having to go through the CSS exercise.
If I haven't fixed it by next week I'll see if I can raise the question at the NT webinar.
Thanks for your support and encouragement
Donn
I have seen Bruce demonstrate experimenting with CSS using the Google Chrome inspect tool. And I have designed my own button for this particular app. I was just hoping there would be a setting somewhere in the multitude of NT options that would fix the problem without having to go through the CSS exercise.
If I haven't fixed it by next week I'll see if I can raise the question at the NT webinar.
Thanks for your support and encouragement
Donn
8
Web Server - Ask For Help / Alignment of two browse forms side by side
« on: July 01, 2021, 10:04:53 AM »
In my NTWS app I have a memory form that has two browse forms as procedures, next to one another.
When there are plenty of rows, the browse forms line up correctly with the top of each form at the same height.
But when one of the browses has only a few records, the tops of the form no longer line up, as shown in the screen shot. It's like a vertical centre alignment, instead of top alignment.
Note: these are not Child forms. They are two separate tables that I need to compare side by side to match up corresponding pairs. Do I need to start messing with CSS styles to fix this?
I think the styles are .nt-form-flex-row, .nt-form-grid-row but I don't want to mess with stuff I don't yet understand.
All suggestions welcome.
When there are plenty of rows, the browse forms line up correctly with the top of each form at the same height.
But when one of the browses has only a few records, the tops of the form no longer line up, as shown in the screen shot. It's like a vertical centre alignment, instead of top alignment.
Note: these are not Child forms. They are two separate tables that I need to compare side by side to match up corresponding pairs. Do I need to start messing with CSS styles to fix this?
I think the styles are .nt-form-flex-row, .nt-form-grid-row but I don't want to mess with stuff I don't yet understand.
All suggestions welcome.
9
Web Server - Ask For Help / Re: Field Lookup Function
« on: June 29, 2021, 09:26:38 AM »
Thanks Bruce! I'll give each method a try.
Edit: I discovered that loc:Heading was already in use. I guess that's why your example didn't use it. ;-)
.OpenFile() is a typo. Should read .Open()
Otherwise, code works perfectly.
Edit: I discovered that loc:Heading was already in use. I guess that's why your example didn't use it. ;-)
.OpenFile() is a typo. Should read .Open()
Otherwise, code works perfectly.
10
Web Server - Ask For Help / Field Lookup Function
« on: June 29, 2021, 06:13:40 AM »
I have a NTWS browse form (Invoices) that I want to filter by customer number. So I created a Memory form "Filter_Invoices" that has browseInvoice as a child form.
At the moment I can display the Customer number in the memory form's header, by doing the following:
Heading: 'Invoices for Customer #' & p_web.GSV('cus:CustomerId')
What I really want is
Heading: 'Invoices for ' & Lookup('CustomerName','Customer','CustomerId='p_web.GSV('cus:CustomerId'))
so that the heading is shown as "Invoices for Acme Widgets Inc" or whatever.
Visual Basic has a function called DLookup("Field","Table","Where clause") and the Where clause can be a whole big SQL statement. I'm looking for something a little more modest. Does such a function exist in Clarion/NetTalk, or will I have to write one?
All suggestions welcome.
At the moment I can display the Customer number in the memory form's header, by doing the following:
Heading: 'Invoices for Customer #' & p_web.GSV('cus:CustomerId')
What I really want is
Heading: 'Invoices for ' & Lookup('CustomerName','Customer','CustomerId='p_web.GSV('cus:CustomerId'))
so that the heading is shown as "Invoices for Acme Widgets Inc" or whatever.
Visual Basic has a function called DLookup("Field","Table","Where clause") and the Where clause can be a whole big SQL statement. I'm looking for something a little more modest. Does such a function exist in Clarion/NetTalk, or will I have to write one?
All suggestions welcome.
11
Web Server - Ask For Help / Re: TAB title is session variable - how to update?
« on: June 24, 2021, 04:49:19 AM »
Is it a button on the same form as the Tab title that is causing the session variable to update?
12
Web Server - Ask For Help / Re: NT12 footer centered
« on: June 23, 2021, 11:57:21 AM »
If you have to use a table, try putting <center> before <table> and </center> after </table>. It looks like the text is centred within the table, but the table isn't centred on the page.
I know <center> is really old HTML, but it still works when you are in a hurry.
I know <center> is really old HTML, but it still works when you are in a hurry.
13
Web Server - Ask For Help / Re: Confirmation dialog ?
« on: June 23, 2021, 11:46:26 AM »p_web.Script('ntAlert("Your message here","Alert...!");')
Thanks for the sample. I will experiment further, following Bruce's advice. I need to ask a "Yes/No" type of question, much like the Delete confirmation box. So far I have figured out another way of alerting the user to an error condition, but I'd prefer to ask the user first, rather than report a failure aftwards.
14
Web Server - Ask For Help / Confirmation dialog ?
« on: June 17, 2021, 12:04:36 PM »
I have a browse form where the user clicks on a button to perform a specific task. I would like to be able to check whether the task is one of 2 possible conditions, and then ask the user which condition they prefer, something like the delete confirmation box.
Clearly the MESSAGE() command is not the right thing, but I haven't found any examples of a confirmation dialog that is not part of the standard form buttons. Does such a thing exist? Alternatively, how can I display an error if something goes wrong with the code called by the button?
Clearly the MESSAGE() command is not the right thing, but I haven't found any examples of a confirmation dialog that is not part of the standard form buttons. Does such a thing exist? Alternatively, how can I display an error if something goes wrong with the code called by the button?
15
Web Server - Ask For Help / Re: LetsEncrypt Certificate Renewal
« on: June 17, 2021, 11:54:27 AM »
The certificates update every 30 days if you are running the NT Server app as an application. I ran the server app for 5 months with no need to manually update the certificates.
I changed the properties of the .exe to run only one copy, and then created a scheduled task than ran on login (that was set to automatic using netplwiz) as well as every 30 minutes. Just make sure that you set it to not run if an instance is already running. As long as the app doesn't generate any GPF messages, you should be fine, even when Windows Update requires a reboot.
I changed the properties of the .exe to run only one copy, and then created a scheduled task than ran on login (that was set to automatic using netplwiz) as well as every 30 minutes. Just make sure that you set it to not run if an instance is already running. As long as the app doesn't generate any GPF messages, you should be fine, even when Windows Update requires a reboot.