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
Web Server - Ask For Help / File Manager 3
« on: February 20, 2026, 03:41:40 AM »
[FM3] [default constraints] Error: 21000 - Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The cursor was not declared.
Would you like to End the Program?,WebServer,LandBankTest.exe,
I dont know which program or which statement its complaining about
??
The cursor was not declared.
Would you like to End the Program?,WebServer,LandBankTest.exe,
I dont know which program or which statement its complaining about
??2
Web Server - Ask For Help / Can you add scripts and css from other servers via href="https://....." ?
« on: January 19, 2026, 07:48:35 AM »
Can you add scripts and css from other servers via href="hhtps://....."
How do you specify it in webserver its asking for a file name in the webserver extention template ?
How do you specify it in webserver its asking for a file name in the webserver extention template ?
3
Web Server - Ask For Help / NET ERROR: Attempt to Redirect from HTTP to HTTPS - correct the URL [http://sesi
« on: June 27, 2025, 11:50:11 PM »
NET ERROR: Attempt to Redirect from HTTP to HTTPS - correct the URL [http://sesiro.cloudcover.insure/apiTotalPolicyRecalc] to [https://sesiro.cloudcover.insure/apiTotalPolicyRecalc]
I am getting the above error when I upgraded my nettalk from nettalk 11 to nettalk 14
I am doing a get to a url "sesiro.cloudcover.insure" ie. from my nettalk 14 app to my nettalk 14 app.
It worked in Nettalk 11 without a https:// prefix.
Is there a setting or new DLL I missed for Nettalk 14 ?
I am getting the above error when I upgraded my nettalk from nettalk 11 to nettalk 14
I am doing a get to a url "sesiro.cloudcover.insure" ie. from my nettalk 14 app to my nettalk 14 app.
It worked in Nettalk 11 without a https:// prefix.
Is there a setting or new DLL I missed for Nettalk 14 ?
4
Web Server - Ask For Help / WSDL Error 1 Duplicate queue name. ServiceErrorQueue
« on: June 23, 2025, 10:45:50 AM »
I get this when I click on WSDL Button.
5
Web Server - Ask For Help / I have a PopUp Form with an AutoStart Button can I autoClose after done ?
« on: November 16, 2024, 05:04:28 AM »
I have a netwebform
with a start button
set to auto start
the url is set to autoopen the link to a '_blank' another window when complete
I want to autoclose the popup window if all went well
with a start button
set to auto start
the url is set to autoopen the link to a '_blank' another window when complete
I want to autoclose the popup window if all went well
6
Web Server - Ask For Help / Can you make CheckBoxes with the Button on the Leftt and Text on the Right ?
« on: November 03, 2024, 12:44:50 AM »
Can you make CheckBoxes with the Button on the Leftt and Text on the Right ?
7
Web Server - Ask For Help / checkboxes and radio buttons
« on: October 18, 2024, 02:17:19 AM »
I have a form within a form
it is a memory form with generate form tag switched off
It has checkboxes and radio buttons
when the inside form refreshes it appears to loose the jquery "Boxes' and show as normal ticks and radio buttons until the form is refreshed again and they come back ?
any body have any tips ?
it is a memory form with generate form tag switched off
It has checkboxes and radio buttons
when the inside form refreshes it appears to loose the jquery "Boxes' and show as normal ticks and radio buttons until the form is refreshed again and they come back ?
any body have any tips ?
8
Web Server - Ask For Help / WebLog File
« on: February 22, 2023, 12:36:27 AM »
which embed point can I use to change the name of the weblog file
I also want a new file each day
it seems to be creating one every 30 minutes my idle time out parameter setting
I also want a new file each day
it seems to be creating one every 30 minutes my idle time out parameter setting
9
Web Server - Ask For Help / Export to Excel
« on: November 30, 2021, 05:04:31 AM »
The Export to Excel is a great feature.
Excel seems to decide for itself how to format the cell.
for example :
I have a string 20 field in column 2
they all happen to be numberic but stored on the database as 0001 0002 0003
in excel they are numbers like 1 2 3 4
how do I ensure the row remains a string field in excel ?
Excel seems to decide for itself how to format the cell.
for example :
I have a string 20 field in column 2
they all happen to be numberic but stored on the database as 0001 0002 0003
in excel they are numbers like 1 2 3 4
how do I ensure the row remains a string field in excel ?
10
Web Server - Ask For Help / All of a sudden get compiler errors like this ?
« on: August 06, 2021, 08:44:01 AM »
Unknown identifier: S_WEB - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,60
Field not found: DATAPATH - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,87
Field not found: DEFAULTS - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,78
Field not found: _SITESQUEUE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,66
Field not found: TRACE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,15
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,9
Field not found: CONTENTTYPE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,13
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:199,9
LOTS and LOTS of them.
I tried renumbering and regenerating all procedures ?
Please Help
Field not found: DATAPATH - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,87
Field not found: DEFAULTS - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,78
Field not found: _SITESQUEUE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,66
Field not found: TRACE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,15
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,9
Field not found: CONTENTTYPE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,13
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:199,9
LOTS and LOTS of them.
I tried renumbering and regenerating all procedures ?
Please Help
11
Web Server - Ask For Help / Base64 Encode and Decode
« on: May 02, 2021, 12:36:03 AM »
I have two Nettalk WebServers.
WebServer1 calls WebServer2 using a POST with a JSON PostData String.
WebServer2 returns a file (any File could be txt or PDF)
I have defined the return parameter as type StringTheory in the Webserver2 api.
In Webserver2 I create the file and load it into the stringtheory object.
I also do a Base64Encode.
In Webserver1 the calling program I load the returned value into a stringtheory object and do a Base64Decode.
Then I save it to disk.
If the returned file is txt this works fine.
But my pdf files are corrupt.(They cant be opened by adobe on the webserver1 machine. )
But they are created correctly and can open on the webserver2 machine.
There seems to be something going wrong in the encode and decode step that I dont understand.
WebServer1 calls WebServer2 using a POST with a JSON PostData String.
WebServer2 returns a file (any File could be txt or PDF)
I have defined the return parameter as type StringTheory in the Webserver2 api.
In Webserver2 I create the file and load it into the stringtheory object.
I also do a Base64Encode.
In Webserver1 the calling program I load the returned value into a stringtheory object and do a Base64Decode.
Then I save it to disk.
If the returned file is txt this works fine.
But my pdf files are corrupt.(They cant be opened by adobe on the webserver1 machine. )
But they are created correctly and can open on the webserver2 machine.
There seems to be something going wrong in the encode and decode step that I dont understand.
12
Web Server - Ask For Help / NetWebBrowse Sort Headers
« on: January 24, 2021, 03:21:34 AM »
I have a NetWebBrowse with sort headers
They all work Perfectly as expected,
However if you add a Column Condition to the Browse :
Obviously if the condition is not met the Column does not show
However if the Condition them becomes True ,
The Column Appears but the sort and filter functionality do not work
DebugView shows the sort order as the PrimaryKey , but it doesnt do that either.
Has anyone noticed this effect and if so how did you resolve it ?
They all work Perfectly as expected,
However if you add a Column Condition to the Browse :
Obviously if the condition is not met the Column does not show
However if the Condition them becomes True ,
The Column Appears but the sort and filter functionality do not work
DebugView shows the sort order as the PrimaryKey , but it doesnt do that either.
Has anyone noticed this effect and if so how did you resolve it ?
13
Web Server - Ask For Help / How do I automatically refresh a memory form every x minutes ?
« on: August 21, 2020, 08:04:57 AM »
How do I automatically refresh a memory form every x minutes ?
14
Web Server - Ask For Help / s_web._SitesQueue.Defaults.ExternalHttps = 1
« on: August 05, 2020, 04:50:46 AM »
Hi
I am setting this in embed point
! Start of "Override Default Server Settings"
! [Priority 5000]
s_web._SitesQueue.Defaults.ExternalHttps = glo:ExternalHttps
! End of "Override Default Server Settings"
It still doesnt work for testing api calls, they generate http:// requests
I am setting this in embed point
! Start of "Override Default Server Settings"
! [Priority 5000]
s_web._SitesQueue.Defaults.ExternalHttps = glo:ExternalHttps
! End of "Override Default Server Settings"
It still doesnt work for testing api calls, they generate http:// requests
15
Web Server - Ask For Help / Calling webservice methods json vs xml
« on: May 25, 2020, 04:42:58 AM »
when I do a xml post my api works
when I do a json post I get errors
the following inputs and outputs:
1 xml
Input
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<apiRegister xmlns="">
<ClientIn>
<USERID>**value**</USERID>
<PASSWORD>**value**</PASSWORD>
<CLIENTGUID>**value**</CLIENTGUID>
<MANUALCODE>**value**</MANUALCODE>
<TITLE>**value**</TITLE>
<INITIALS>**value**</INITIALS>
<FIRSTNAMES>**value**</FIRSTNAMES>
<SURNAME>**value**</SURNAME>
<IDNUMBER>**value**</IDNUMBER>
<IISVALIDSA>**value**</IISVALIDSA>
<CELLPHONE>**value**</CELLPHONE>
<EMAIL>**value**</EMAIL>
<HOMETEL>**value**</HOMETEL>
<WORKTEL>**value**</WORKTEL>
<FAXNO>**value**</FAXNO>
<POSTALADDRESS>**value**</POSTALADDRESS>
<RESIDENTIALADDRESS>**value**</RESIDENTIALADDRESS>
<LANGUAGE>**value**</LANGUAGE>
<DATEOFBIRTH>**value**</DATEOFBIRTH>
<SEX>**value**</SEX>
<CELLPHONEVERIFIED>**value**</CELLPHONEVERIFIED>
<EMAILVERIFIED>**value**</EMAILVERIFIED>
<OCCUPATION>**value**</OCCUPATION>
<PASSPORTNUMBER>**value**</PASSPORTNUMBER>
<BROKERGUID>**value**</BROKERGUID>
<CHANGEDBY>**value**</CHANGEDBY>
</ClientIn>
</apiRegister>
</soap:Body>
</soap:Envelope>
OutPut:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<apiRegister_response xmlns="">
<ServiceErrors>
<Error>
<ErrorNumber>2</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Title; **value**</ErrorDescription>
<ErrorRecommendation/>
</Error>
<Error>
<ErrorNumber>4</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid IdNumber: **value**</ErrorDescription>
<ErrorRecommendation>SA ID Number must be a 13 digit numeric number</ErrorRecommendation>
</Error>
<Error>
<ErrorNumber>8</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Language: **value**</ErrorDescription>
<ErrorRecommendation/>
</Error>
<Error>
<ErrorNumber>9</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Sex: **value**</ErrorDescription>
<ErrorRecommendation>Must be Male or Female</ErrorRecommendation>
</Error>
<Error>
<ErrorNumber>10</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Client with ID:**value** already Exists</ErrorDescription>
<ErrorRecommendation/>
</Error>
</ServiceErrors>
</apiRegister_response>
</soap:Body>
</soap:Envelope>
This is an expected result
However
when I input Json
{
"ClientIn" : {
"USERID" : value,
"PASSWORD" : value,
"CLIENTGUID" : value,
"MANUALCODE" : value,
"TITLE" : value,
"INITIALS" : value,
"FIRSTNAMES" : value,
"SURNAME" : value,
"IDNUMBER" : value,
"IISVALIDSA" : value,
"CELLPHONE" : value,
"EMAIL" : value,
"HOMETEL" : value,
"WORKTEL" : value,
"FAXNO" : value,
"POSTALADDRESS" : value,
"RESIDENTIALADDRESS" : value,
"LANGUAGE" : value,
"DATEOFBIRTH" : value,
"SEX" : value,
"CELLPHONEVERIFIED" : value,
"EMAILVERIFIED" : value,
"OCCUPATION" : value,
"PASSPORTNUMBER" : value,
"BROKERGUID" : value,
"CHANGEDBY" : value
}
}
I get:
{
"apiRegister_response" : {
"ServiceErrors" : [
{
"ERRORNUMBER" : 9007,
"ERRORPOSITION" : "apiRegister",
"ERRORRECORDID" : "Input:Record",
"ERRORDESCRIPTION" : "JSONClass.HandleChar: Unexpected literal (v) at position: 35 USERID\" : value,\n \"PASSWORD\" : value,\n \"CLIENTGUI",
"ERRORRECOMMENDATION" : "Review JSON data and correct it."
}
]
}
}
when I do a json post I get errors
the following inputs and outputs:
1 xml
Input
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<apiRegister xmlns="">
<ClientIn>
<USERID>**value**</USERID>
<PASSWORD>**value**</PASSWORD>
<CLIENTGUID>**value**</CLIENTGUID>
<MANUALCODE>**value**</MANUALCODE>
<TITLE>**value**</TITLE>
<INITIALS>**value**</INITIALS>
<FIRSTNAMES>**value**</FIRSTNAMES>
<SURNAME>**value**</SURNAME>
<IDNUMBER>**value**</IDNUMBER>
<IISVALIDSA>**value**</IISVALIDSA>
<CELLPHONE>**value**</CELLPHONE>
<EMAIL>**value**</EMAIL>
<HOMETEL>**value**</HOMETEL>
<WORKTEL>**value**</WORKTEL>
<FAXNO>**value**</FAXNO>
<POSTALADDRESS>**value**</POSTALADDRESS>
<RESIDENTIALADDRESS>**value**</RESIDENTIALADDRESS>
<LANGUAGE>**value**</LANGUAGE>
<DATEOFBIRTH>**value**</DATEOFBIRTH>
<SEX>**value**</SEX>
<CELLPHONEVERIFIED>**value**</CELLPHONEVERIFIED>
<EMAILVERIFIED>**value**</EMAILVERIFIED>
<OCCUPATION>**value**</OCCUPATION>
<PASSPORTNUMBER>**value**</PASSPORTNUMBER>
<BROKERGUID>**value**</BROKERGUID>
<CHANGEDBY>**value**</CHANGEDBY>
</ClientIn>
</apiRegister>
</soap:Body>
</soap:Envelope>
OutPut:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<apiRegister_response xmlns="">
<ServiceErrors>
<Error>
<ErrorNumber>2</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Title; **value**</ErrorDescription>
<ErrorRecommendation/>
</Error>
<Error>
<ErrorNumber>4</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid IdNumber: **value**</ErrorDescription>
<ErrorRecommendation>SA ID Number must be a 13 digit numeric number</ErrorRecommendation>
</Error>
<Error>
<ErrorNumber>8</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Language: **value**</ErrorDescription>
<ErrorRecommendation/>
</Error>
<Error>
<ErrorNumber>9</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Invalid Sex: **value**</ErrorDescription>
<ErrorRecommendation>Must be Male or Female</ErrorRecommendation>
</Error>
<Error>
<ErrorNumber>10</ErrorNumber>
<ErrorPosition>apiClient</ErrorPosition>
<ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
<ErrorDescription>Client with ID:**value** already Exists</ErrorDescription>
<ErrorRecommendation/>
</Error>
</ServiceErrors>
</apiRegister_response>
</soap:Body>
</soap:Envelope>
This is an expected result
However
when I input Json
{
"ClientIn" : {
"USERID" : value,
"PASSWORD" : value,
"CLIENTGUID" : value,
"MANUALCODE" : value,
"TITLE" : value,
"INITIALS" : value,
"FIRSTNAMES" : value,
"SURNAME" : value,
"IDNUMBER" : value,
"IISVALIDSA" : value,
"CELLPHONE" : value,
"EMAIL" : value,
"HOMETEL" : value,
"WORKTEL" : value,
"FAXNO" : value,
"POSTALADDRESS" : value,
"RESIDENTIALADDRESS" : value,
"LANGUAGE" : value,
"DATEOFBIRTH" : value,
"SEX" : value,
"CELLPHONEVERIFIED" : value,
"EMAILVERIFIED" : value,
"OCCUPATION" : value,
"PASSPORTNUMBER" : value,
"BROKERGUID" : value,
"CHANGEDBY" : value
}
}
I get:
{
"apiRegister_response" : {
"ServiceErrors" : [
{
"ERRORNUMBER" : 9007,
"ERRORPOSITION" : "apiRegister",
"ERRORRECORDID" : "Input:Record",
"ERRORDESCRIPTION" : "JSONClass.HandleChar: Unexpected literal (v) at position: 35 USERID\" : value,\n \"PASSWORD\" : value,\n \"CLIENTGUI",
"ERRORRECOMMENDATION" : "Review JSON data and correct it."
}
]
}
}