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.
16
Web Server - Ask For Help / Filter between dates
« on: April 27, 2015, 04:19:14 AM »
I need some help please.
I have a browse with two filters: a "start date" and "end date"
Don't seem to get the syntax correct.
'COB:Date_Purchased >= p_web.GSV('Sales_start_date') and COB:Date_Purchased >= p_web.GSV('Sales_end_date')'
Can someone please help me.
Regards
I have a browse with two filters: a "start date" and "end date"
Don't seem to get the syntax correct.
'COB:Date_Purchased >= p_web.GSV('Sales_start_date') and COB:Date_Purchased >= p_web.GSV('Sales_end_date')'
Can someone please help me.
Regards
17
Web Server - Ask For Help / Copy $$$temp reports away to diffrent path.
« on: January 22, 2015, 02:07:12 AM »
Hi Everyone
I’m generating pdf reports on a nettalk webserver and it works fantastic.
My client has requested for reasons unknown to myself that each report generated must be duplicated and saved somewhere else on the disk with a Unique file name.
I tried to “catch” the report when it generates in the web\reports folder and copy it somewhere else.
My Problem
Where in the embed code can I add the code to copy the generated reports from “web\reports\$$$Reportname.pdf” to “web\archive\datevalue+reportname.pdf”
I have tried to use the LOC:url session value to get the path to copy, but don’t seem to work.
Thanks
Louis
I’m generating pdf reports on a nettalk webserver and it works fantastic.
My client has requested for reasons unknown to myself that each report generated must be duplicated and saved somewhere else on the disk with a Unique file name.
I tried to “catch” the report when it generates in the web\reports folder and copy it somewhere else.
My Problem
Where in the embed code can I add the code to copy the generated reports from “web\reports\$$$Reportname.pdf” to “web\archive\datevalue+reportname.pdf”
I have tried to use the LOC:url session value to get the path to copy, but don’t seem to work.
Thanks
Louis
18
Web Server - Ask For Help / Progress
« on: July 06, 2014, 09:10:14 AM »
Hi Everyone
I'm busy adding a progress process.
Checking out the example 72 I'm running into this compile error ...
No matching prototype available - ..\Capesoft\NetTalk\Web Server\Progress (72)\web72011.clw:24,20.
Regards
Louis
I'm busy adding a progress process.
Checking out the example 72 I'm running into this compile error ...
No matching prototype available - ..\Capesoft\NetTalk\Web Server\Progress (72)\web72011.clw:24,20.
Regards
Louis
19
Web Server - Ask For Help / RightReports Session Value
« on: June 11, 2014, 10:41:24 AM »
Hi everyone
I have the following problem.
Using NT 8.16 with RightReports 1.95. Clarion 8
I have a simple certificate that prints and creates a pdf.
I only have one singe input - Member Number and the reports generates accordingly .
In the "Windows report design side" the reports works fine every time.
When running the report on the "WEB side". The report generates fine the first time.
If I requested another report , different member it generates the 1st reports and keeps on doing this.
It remembers the session value from the 1st generated report.
Not sure when this broke. It worked fine with NT 7.37 RightReports 1.92
Next question. Can I generate the RightReports in a window like the Clarion reports and not full screen?
Regards
Louis
I have the following problem.
Using NT 8.16 with RightReports 1.95. Clarion 8
I have a simple certificate that prints and creates a pdf.
I only have one singe input - Member Number and the reports generates accordingly .
In the "Windows report design side" the reports works fine every time.
When running the report on the "WEB side". The report generates fine the first time.
If I requested another report , different member it generates the 1st reports and keeps on doing this.
It remembers the session value from the 1st generated report.
Not sure when this broke. It worked fine with NT 7.37 RightReports 1.92
Next question. Can I generate the RightReports in a window like the Clarion reports and not full screen?
Regards
Louis
20
Web Server - Ask For Help / Validate for duplicate values
« on: June 08, 2014, 11:57:31 AM »
I have the following scenario.
I have many required fields on my form, but the most important field is the social security number.
My problem is. The user fills in all the fields, just to find that the Number is already in the database after enter key or save button is pressed.
Is there a way to validate for duplicate value before the record is saved to the disk/ database?
If not
Is there a way to prioritize which fields are “validated” first against the dictionary?
Many thanks
Louis
Clarion 8
NT 8.15
I have many required fields on my form, but the most important field is the social security number.
My problem is. The user fills in all the fields, just to find that the Number is already in the database after enter key or save button is pressed.
Is there a way to validate for duplicate value before the record is saved to the disk/ database?
If not
Is there a way to prioritize which fields are “validated” first against the dictionary?
Many thanks
Louis
Clarion 8
NT 8.15
21
Web Server - Ask For Help / How do i generate a pdf report and mail it.
« on: January 13, 2014, 05:53:11 AM »
Hi all
Please assist, need some guidance.
I want to send a mail with a pdf attachment that gets generated by a normal report function, using, (Report to PDF) Template. This all need to happen within a nettalk web application.
I was hoping that ntkpxc24.app [C:\...Accessory\Capesoft\NetTalk\Email\Email Send PDF Report] will help me in this process, but I'm getting the following error when running the sample app. (See attachment)
It sends the mail eventually with a pdf attachment that can’t be opened.
Regards
Louis
[attachment deleted by admin]
Please assist, need some guidance.
I want to send a mail with a pdf attachment that gets generated by a normal report function, using, (Report to PDF) Template. This all need to happen within a nettalk web application.
I was hoping that ntkpxc24.app [C:\...Accessory\Capesoft\NetTalk\Email\Email Send PDF Report] will help me in this process, but I'm getting the following error when running the sample app. (See attachment)
It sends the mail eventually with a pdf attachment that can’t be opened.
Regards
Louis
[attachment deleted by admin]
22
Web Server - Ask For Help / Multisite - dll apps not compiling with winevent 3.85
« on: January 06, 2014, 07:31:09 AM »
Hi All
I have a MultiSite running without problems,
Using
C8,
NT 7.31
winevent 3.83
FM 5.15
GFP 2.31
StringTheory 1.93
with some other templates from CapeSoft
After upgrading winevent to 3.85 I get the following error when compiling.
C:\Dev\MultiSite\Mywebapp\map\release\Mywebapp.MAP(1,1) : Error : Unresolved External $WE::CANTCLOSENOW in Mywebapp002.obj
[....]
C:\Dev\MultiSite\Mywebapp\map\release\Mywebapp.MAP(2,1) : Error : Unresolved External $WE::MUSTCLOSE in Mywebapp002.obj
I cleared the obj folder, made sure my Project settings are correct compile method is DLL ect. After reverting back to winevent 3,83, I don't get this compile error. Anything I'm doing wrong ?
Thanks
Louis
I have a MultiSite running without problems,
Using
C8,
NT 7.31
winevent 3.83
FM 5.15
GFP 2.31
StringTheory 1.93
with some other templates from CapeSoft
After upgrading winevent to 3.85 I get the following error when compiling.
C:\Dev\MultiSite\Mywebapp\map\release\Mywebapp.MAP(1,1) : Error : Unresolved External $WE::CANTCLOSENOW in Mywebapp002.obj
[....]
C:\Dev\MultiSite\Mywebapp\map\release\Mywebapp.MAP(2,1) : Error : Unresolved External $WE::MUSTCLOSE in Mywebapp002.obj
I cleared the obj folder, made sure my Project settings are correct compile method is DLL ect. After reverting back to winevent 3,83, I don't get this compile error. Anything I'm doing wrong ?
Thanks
Louis
23
Web Server - Ask For Help / Refresh Child Browse after populating
« on: December 27, 2013, 08:32:42 AM »
Hi All
I have a small order system.
I have a pr-defined order list that I need to generate. See attachment 1
If I click on the Generate button it writes the records into the database, but do not re-fresh the browse listed below. If you go out of the browse and open the order again, the browse is populated.
I am resetting the child browse after clicking on the button. No joy
Please help me. How do I refresh the browse?
Many Thanks
Louis
[attachment deleted by admin]
I have a small order system.
I have a pr-defined order list that I need to generate. See attachment 1
If I click on the Generate button it writes the records into the database, but do not re-fresh the browse listed below. If you go out of the browse and open the order again, the browse is populated.
I am resetting the child browse after clicking on the button. No joy
Please help me. How do I refresh the browse?
Many Thanks
Louis
[attachment deleted by admin]
24
Web Server - Ask For Help / Rename search button and change the requered fild
« on: August 06, 2013, 08:08:40 AM »
Hi Everyone.
Small problem I have or lack of knowhow.
I'm developing a website in a different language.
I managed to change all the buttons to the correct language except the search button at the top of the browse. Where change I do this?
My second question is:
In the comment field. For example.
When I add a field that is required. The “required” comment display next to the field (as it should)
Is there a global area where I can change this? Or do I need to do it field by field in the form.
Regards
Louis
Small problem I have or lack of knowhow.
I'm developing a website in a different language.
I managed to change all the buttons to the correct language except the search button at the top of the browse. Where change I do this?
My second question is:
In the comment field. For example.
When I add a field that is required. The “required” comment display next to the field (as it should)
Is there a global area where I can change this? Or do I need to do it field by field in the form.
Regards
Louis
25
Web Server - Ask For Help / Parent Child display problem NT7.14
« on: July 04, 2013, 11:34:57 PM »
Hi everyone
I have a 2 browses parent -> child
On NetTalk 7.10 everything was ok (See attachment)
After upgrading to 7.14 the browser don’t look as expected. (See attachment)
Please help.
Regards
Louis
[attachment deleted by admin]
I have a 2 browses parent -> child
On NetTalk 7.10 everything was ok (See attachment)
After upgrading to 7.14 the browser don’t look as expected. (See attachment)
Please help.
Regards
Louis
[attachment deleted by admin]
26
Web Server - Ask For Help / Custom theme - Tabs not working
« on: November 21, 2012, 08:58:29 AM »
HI All
My problem:” If I use custom themes my TABS do not work. However if I use the themes shipped with NT 6.51 ..\\..web\themes\redmond they work fine.
I downloaded “Black Tie” from jquery , Copied it into the ..\web\themes folder, removed the version number ect. The theme applies to the website without problems. But the TABS do not work.
Any idea what the problem can be ?.
Im Using Clarion 8.0.9661, with NT 6.51.
Thanks
Louis
My problem:” If I use custom themes my TABS do not work. However if I use the themes shipped with NT 6.51 ..\\..web\themes\redmond they work fine.
I downloaded “Black Tie” from jquery , Copied it into the ..\web\themes folder, removed the version number ect. The theme applies to the website without problems. But the TABS do not work.
Any idea what the problem can be ?.
Im Using Clarion 8.0.9661, with NT 6.51.
Thanks
Louis
27
Web Server - Ask For Help / MultiSite with FM3 and SQL
« on: April 27, 2012, 03:07:37 PM »
HI everyone
Please help !
My scenario
http://Site1.mydomain.com connecting to SQL Database1 using FM3 with SQL Connector
http://Site2.mydomain.com connecting to SQL Database2 using FM3 with SQL Connector
If I compile them as exe with each running on different ports its working fine.
BUT
To run them both on port 80 connecting both to SQL seems to be a bit of a challenge for me.
I got the example MultiSite6 (59) working fine with tps files.
My questions
Should I be using the SQL connector of FM3 GUI interface ?
How does the compiled DLL’s reference the different FM3.ini file. It seems to default to the folder where the host,exe lives?
Where should the embed points be for the tables?
If I need to use connector string. How should they look like ?
Thanks
Louis
Please help !
My scenario
http://Site1.mydomain.com connecting to SQL Database1 using FM3 with SQL Connector
http://Site2.mydomain.com connecting to SQL Database2 using FM3 with SQL Connector
If I compile them as exe with each running on different ports its working fine.
BUT
To run them both on port 80 connecting both to SQL seems to be a bit of a challenge for me.
I got the example MultiSite6 (59) working fine with tps files.
My questions
Should I be using the SQL connector of FM3 GUI interface ?
How does the compiled DLL’s reference the different FM3.ini file. It seems to default to the folder where the host,exe lives?
Where should the embed points be for the tables?
If I need to use connector string. How should they look like ?
Thanks
Louis
28
Web Server - Ask For Help / JQUERY calendar translation
« on: January 16, 2012, 07:00:05 AM »
Hi all
My worst nightmare came true. I have to develop a website in a different language, in my case “Afrikaans”.
I’m Using “Hotdates” example as a starting point and need to translate all the JQUERY calendars to “Afrikaans”.
I know from some reading I’ve done, that I need to add the loc:options as seen below to my code.
loc:options = 'dayNames: ["Maandag", "Dinsdag", "Woensdagi", "Donderdag", "Vrydag", "Saterdag", "Sondag"],
I need some baby step guidance where to add it the code please
Clarion 6.3
NETTALK 5
Many thanks
Louis
My worst nightmare came true. I have to develop a website in a different language, in my case “Afrikaans”.
I’m Using “Hotdates” example as a starting point and need to translate all the JQUERY calendars to “Afrikaans”.
I know from some reading I’ve done, that I need to add the loc:options as seen below to my code.
loc:options = 'dayNames: ["Maandag", "Dinsdag", "Woensdagi", "Donderdag", "Vrydag", "Saterdag", "Sondag"],
I need some baby step guidance where to add it the code please
Clarion 6.3
NETTALK 5
Many thanks
Louis
29
Web Server - Ask For Help / RightReports applying filters to web Reports
« on: December 10, 2011, 09:17:10 PM »
Hi
Clarion 6.3
Nettalk 5.43
RightReports 1.76
RightReports works great with Nettalk. It has eased the pain of designing reports.
My problem
I need to print invoices based on the p_web.GSV(Dealer_name) filter in the web Interface.
In the GUI design side, how do I define this? It does not seem to understand the GetSessionValue.
Please assist
Regards
Louis
Clarion 6.3
Nettalk 5.43
RightReports 1.76
RightReports works great with Nettalk. It has eased the pain of designing reports.
My problem
I need to print invoices based on the p_web.GSV(Dealer_name) filter in the web Interface.
In the GUI design side, how do I define this? It does not seem to understand the GetSessionValue.
Please assist
Regards
Louis
30
Web Server - Ask For Help / PDF generated reports in landscape.
« on: August 29, 2011, 06:06:06 AM »My Web Server system works fine on my own workstation to generate reports to
PDF. The problem is that when it is on the web server, the PDF
reports are generated in landscape and the bottom half of the reports are
cut off. Is there something that needs to be deployed to my web host printer drivers or settings ?
The webserver.exe does not use a service account. I even changed it to run under the local admin account.
I have changed the paper size ect.
What causes this. Is this a Adobe Reader 9 issue, printer issue or setup problem ?
Thanks
Louis