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 / How do I set the reply to address when I use Nettalk to send emails ?
« on: April 21, 2016, 01:42:20 AM »
How do I set the reply to address when I use Nettalk to send emails ?
Can this be done ?
Can this be done ?
62
Web Server - Ask For Help / s1000 connection is busy with results for another command
« on: April 19, 2016, 02:37:21 PM »
Im not sure if this is the right forum.
But has anybody else using SQL Server with nettalk experienced these errors ?
A popup box appears and is written to the error log ?
But has anybody else using SQL Server with nettalk experienced these errors ?
A popup box appears and is written to the error log ?
63
Web Server - Ask For Help / sending an excel spreadsheet to the browser
« on: April 13, 2016, 01:39:45 AM »
I use office inside to create an excel spreadsheet.
it creates an '.xlsx' file.
I save it into the reports folder with a $$$ prefix.
The webserver sends a '.xls' file to the browser even though I created a '.xlsx'
I changed the filename so it doesnt have a $$$ prefix when I save it into the reports folder.
The file is saved correctly as eg. $$$xxxxxx.xlsx
but nettalk still sends an .xls file to the browser.
This creates a problem when opening the spreadsheet in excel it give a warning that the file type is incorrect with the contents.
however if I open the .xlsx file directly from the reports folder there is not problem.
it creates an '.xlsx' file.
I save it into the reports folder with a $$$ prefix.
The webserver sends a '.xls' file to the browser even though I created a '.xlsx'
I changed the filename so it doesnt have a $$$ prefix when I save it into the reports folder.
The file is saved correctly as eg. $$$xxxxxx.xlsx
but nettalk still sends an .xls file to the browser.
This creates a problem when opening the spreadsheet in excel it give a warning that the file type is incorrect with the contents.
however if I open the .xlsx file directly from the reports folder there is not problem.
64
Web Server - Ask For Help / NetwebForm Field with lookup button setting to readonly
« on: March 31, 2016, 08:03:17 PM »
On a NetwebForm
in a string type field with an autocomplete and a lookup button
you can set the field to readonly with a condition eg. gsv('aaa') <> 'aaa'
However if you put the same check in the hide lookup button template code a complie error occurs
in a string type field with an autocomplete and a lookup button
you can set the field to readonly with a condition eg. gsv('aaa') <> 'aaa'
However if you put the same check in the hide lookup button template code a complie error occurs
65
Web Server - Ask For Help / NetwebBrowse with export button with a local variable
« on: February 24, 2016, 02:26:31 AM »
I have a netwebbrowse
with a local field loc:totalvalue
it is calculated as tbl:untprice * tbl:quantity
in the browse it shows correctly
however on the export it exports a zero value
with a local field loc:totalvalue
it is calculated as tbl:untprice * tbl:quantity
in the browse it shows correctly
however on the export it exports a zero value
66
Web Server - Ask For Help / Going to a different Update Popup form from the same browse
« on: January 27, 2016, 06:19:54 AM »
I have seem I can popup different forms on update by checking a condition.
But how do I pass a different id to the other forms ? ie, not the default id of the browse ?
But how do I pass a different id to the other forms ? ie, not the default id of the browse ?
67
Web Server - Ask For Help / How do I stop some users continuing using the server app until further notice ?
« on: January 18, 2016, 11:10:20 PM »
I have a nettalk webserver app.
it has different types of users
eg. admin and general users
when certain processes have to be done, its important that no one can continue to update the database until processing is complete.
I have a global variable which an admin user can set to say siteclosed.
I check this in the login form and make sure no general user can signon while the variable is set.
But how do I intercept the next request from a general user that is allready signed on from not doing what they want.
I assume somewhere in the webhandler procedure
But where exactly and how do I notify them ?
it has different types of users
eg. admin and general users
when certain processes have to be done, its important that no one can continue to update the database until processing is complete.
I have a global variable which an admin user can set to say siteclosed.
I check this in the login form and make sure no general user can signon while the variable is set.
But how do I intercept the next request from a general user that is allready signed on from not doing what they want.
I assume somewhere in the webhandler procedure
But where exactly and how do I notify them ?
68
Web Server - Ask For Help / When can you use p_web.popup it doesn't seem to always work
« on: November 25, 2015, 09:20:43 AM »
Perhaps its because I don't understand exactly what happpens when this code executes ?
69
Web Server - Ask For Help / NetwebForm with multiple Tabs
« on: November 24, 2015, 01:22:31 PM »
I have a netwebform with multiple tabs
The first tab contains the actual form fields of a table
the 2nd and 3rd tab shows records from other tables related to the table info displayed in the 1st tab.
The user can select the popup form of the browsebox on the second tab
he can perform a function that inserts a record into the 3rd table
This works
However when i return from the popup and select the 3rd tab the record doesnt show in the browse box
How do I refresh the 3rd tab, perhaps on click of the tab heading so the new record shows without closing and reopening the 1st form.
I don't have the facility to refesh the browse box on the 2nd tables form
The first tab contains the actual form fields of a table
the 2nd and 3rd tab shows records from other tables related to the table info displayed in the 1st tab.
The user can select the popup form of the browsebox on the second tab
he can perform a function that inserts a record into the 3rd table
This works
However when i return from the popup and select the 3rd tab the record doesnt show in the browse box
How do I refresh the 3rd tab, perhaps on click of the tab heading so the new record shows without closing and reopening the 1st form.
I don't have the facility to refesh the browse box on the 2nd tables form
70
Web Server - Ask For Help / Netwebform saving info to database on a button other than save button
« on: November 17, 2015, 05:37:19 AM »
I have a netwebform
i also have a button on the form that calls another procedure
I want to update the fields to the database before i call the procedure ie. not pressing the save button
is this possible ? how do i do it ?
I tried p_web.updatefile ?
i also have a button on the form that calls another procedure
I want to update the fields to the database before i call the procedure ie. not pressing the save button
is this possible ? how do i do it ?
I tried p_web.updatefile ?
71
Web Server - Ask For Help / reseting a radio option field in a netwebform
« on: November 15, 2015, 07:48:10 AM »
If you reset a radio button on a netwebform from another field in the client side tab, and the radio button is set to use jquery type buttons, the reset happens but the jquery type button look and feel is lost ?
72
Web Server - Ask For Help / Sending emails with attachments from nettalk using the sendemail procedure
« on: November 15, 2015, 02:22:47 AM »
I am sending emails successfully from my webserver app using the standard sendemail procedure example that comes with nettalk.
I have a problem sending PDF's and Excel Documents as attachments..
The mail actually goes through and sends the documents but when thay arrive on the other side they are much smaller and cant be opened.
eg. when I try and open the attachement Adobe says the file is corrupt or it was send via email and wasn't decoded correctly.
I assume the msg was sent as an email and wasn't decoded correctly is a clue to y problem.
all I do is put the full file names in the attachlist eg. 'c:\1.pdf,c:\2,xlsx'
Who can tell me whats going on and how I fix this ?
I have a problem sending PDF's and Excel Documents as attachments..
The mail actually goes through and sends the documents but when thay arrive on the other side they are much smaller and cant be opened.
eg. when I try and open the attachement Adobe says the file is corrupt or it was send via email and wasn't decoded correctly.
I assume the msg was sent as an email and wasn't decoded correctly is a clue to y problem.
all I do is put the full file names in the attachlist eg. 'c:\1.pdf,c:\2,xlsx'
Who can tell me whats going on and how I fix this ?
73
Web Server - Ask For Help / Media type in a form
« on: November 05, 2015, 08:32:30 AM »
I have a media type in a netwebform on the second tab
on the first tab I create a pdf and refresh the media entry
all works perfectly well
If I go out and come in again everything is cool.
However
if I recreate the pdf on the first tab and move to the media tab the old pdf displays.
if I look in the web sub folder where the pdf was created the new pdf is there.
if I go out the form and return the old pdf is still displayed
I have checked the settings on the performance tab of the webserver and all is set to 0 not to hold anything in cache.
How do I ensure that the webserver retrieves the new file from the server and sends it to the browser.
even if I close the webserver program and rerun it the old pdf displays in the browser.
A second question.
How do I ensure that nobody can display the stored files i've stored on the webserver under the web sub directory by just entering the server address followed by the file name ?
on the first tab I create a pdf and refresh the media entry
all works perfectly well
If I go out and come in again everything is cool.
However
if I recreate the pdf on the first tab and move to the media tab the old pdf displays.
if I look in the web sub folder where the pdf was created the new pdf is there.
if I go out the form and return the old pdf is still displayed
I have checked the settings on the performance tab of the webserver and all is set to 0 not to hold anything in cache.
How do I ensure that the webserver retrieves the new file from the server and sends it to the browser.
even if I close the webserver program and rerun it the old pdf displays in the browser.
A second question.
How do I ensure that nobody can display the stored files i've stored on the webserver under the web sub directory by just entering the server address followed by the file name ?
74
Web Server - Ask For Help / Nettalk Application Wizard generation error
« on: August 28, 2015, 03:35:59 AM »
1.
If you import a mssql table into a clarion dictionary
if a field is nullable
softvelocity sets the initial value in the dictionary to NULL
when capesoft nettalk wizard generates the prodecure it generates code that sets the firld equal to NULL eg.
tab:suppId = NULL
this causes a compile error
2.
if a table has a relation to another table for a particular field and you set the field to must be in table in the dictionary
if you create an alias of that table
the capesoft nettalk generator causes a compile error when validating the the alias table field exists ,
to correct this you need to add the same relationship in the dictionary on the alias table.
If you import a mssql table into a clarion dictionary
if a field is nullable
softvelocity sets the initial value in the dictionary to NULL
when capesoft nettalk wizard generates the prodecure it generates code that sets the firld equal to NULL eg.
tab:suppId = NULL
this causes a compile error
2.
if a table has a relation to another table for a particular field and you set the field to must be in table in the dictionary
if you create an alias of that table
the capesoft nettalk generator causes a compile error when validating the the alias table field exists ,
to correct this you need to add the same relationship in the dictionary on the alias table.
75
Web Server - Ask For Help / Window Top Offset Pixels
« on: July 21, 2015, 04:27:20 AM »
In NetWebBrowse on the forms tab and NEtWebForm the Layout Tab
there is an option to set Popup Options for the Form.
One of them is Windows Top Offset (Pixels)
They both default to 15
It appears that whatever is in the NetWebForm is used.
Is there a way to globally overide this in one place , or do i have to edit each template and insert a new value or variable on each form template ?
there is an option to set Popup Options for the Form.
One of them is Windows Top Offset (Pixels)
They both default to 15
It appears that whatever is in the NetWebForm is used.
Is there a way to globally overide this in one place , or do i have to edit each template and insert a new value or variable on each form template ?