Home Forum Download/Upload Links Search

NetTalk User Group

NetTalk User Group Meeting!
Live Webinar!
Saturday Nov. 16 
7am PST
Click Here To Register!
Home arrow Forum
NetTalk Central
September 15, 2014, 08:55:52 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Welcome to the NetTalk Central Forums!
 
  Home Help Search Login Register  
  Show Posts
Pages: [1] 2 3 ... 15
1  NetTalk Web Server / Web Server - Ask For Help / Re: LOG: This is dangerous? on: August 27, 2014, 11:36:17 PM
Yeah,

On my public Nettalk webservers, I routinely see all sorts of calls made to phpmyadmin and other routes.  Tons of them.  Quite funny actually.  Oh well, I guess it is wasting processing time for some hacker, so I consider it a community service!  Grin

Cheers,
Devan
2  NetTalk Web Server / Web Server - Ask For Help / Re: Browse behaviour using MySQL on: August 27, 2014, 11:33:50 PM
Hi Rene,

I have problems with MySQL tables if I don't specify a truly unique index in the Browse procedure.  Sometimes I've tried using a non unique index and get some crazy things happening, so always have to resort to a unique primary index in the properties screen and do my other sorting under the 'Sort' tab.

Cheers,
Devan
3  NetTalk Web Server / Web Server - Ask For Help / Re: Printing a report with no detail lines on: August 18, 2014, 03:25:29 PM
Thanks Kevin.

We have another project where I have a 'placeholder' PDF to serve up when there are no reports, as you suggested.   It worked well, but this particular site is a unique case where on occasion the customer can enter an order with just some comments, and no actual line items being selected.

In these cases, my client wants the order to still be emailed with the customer details in the header and the comments in the footer so their sales team can still chase up the customer.

I am thinking that most of the other workaround are based around 'normal' Clarion reports on Win32 using the Previewer.  In this case, I am generating a PDF directly in the background with no previewer at all, so not sure if those workaround will be effective??

Cheers,
Devan
4  NetTalk Web Server / Web Server - Ask For Help / Printing a report with no detail lines on: August 18, 2014, 12:05:48 AM
This isn't technically a NetTalk issue directly, but it affects an NT7 site that we currently have (in Clarion 8 - We haven't upgraded this one to NT8 and Clarion 9 yet).

We have a routine in there that generates a PDF Order Confirmation report on disk and emails it to the user and our client's sales team on a background thread.  All works fine except that it used to NOT create the PDF whenever the user entered an order with no detail lines.

Our client has come back to us and said that even if the user does not enter any lines on the order, they still want the report to generate and be sent to the user and their sales team.  I've done a brief search, and it seems to be popular believe that if we embed:

ReturnValue = 0

on the ThisWindow.OpenReport embed point, it should print the report irrespective of whether it finds detail records or not, but it still does not seem to be working.

Any tips on how we can still get the report to forcibly print the header bands etc.?

Cheers,
Devan
5  NetTalk Web Server / Web Server - Ask For Help / NT8.10 - Adding a button to mobile header bar on: May 18, 2014, 02:39:22 PM
We are designing a NetTalk based web app that will be called when a user scans a QR Code on bottles of medication that is supplied by our customer.

Basically, when the user scans a QR Code, they will be taken straight to a WebForm which displays information on that vial.

It works fine on the desktop and mobile versions of the site - HOWEVER, on the desktop version, the main menu is available, so the user can then go to the home page by clicking the first menu option, then navigating elsewhere on the portal.

On the mobile version of the site - the menu does not appear.  Not a big problem.  I was thinking to add a 'Home' button on the top bar of the mobile screen so that the user can go back and do other thing but I am not sure which is the best way to go about this?

At the moment, I have added a button at the bottom of the form, but ideally would like it to be on the top bar for a better mobile experience.

Thanks,
Devan
6  NetTalk Web Server / Web Server - Ask For Help / Redactor editor kaput? on: May 15, 2014, 06:48:54 PM
Hi all,

Just starting a new project with Clarion 9.0 and NetTalk 8.10.

I have a form that has a Text edit area in it, and I left everything as per the default Redactor editor, but having a problem with it.

The editor box and controls are showing, along with the toolbar etc., but I cannot click within the editor window to make and changes to the content.  If I preload content in the database directly, it shows in the editor window, but I cannot change anything.

Tried it in Chrome and IE with the same results.

Have I missed something important?

I tried switching back to TinyMCE as the editor, but it gives me NO editor window - just a plain HTML text box.  Wondering if the template is broken, or there is another issue?

Thanks,
Devan
7  NetTalk Web Server / Web Server - Ask For Help / Re: Where to put user data? on: May 14, 2014, 04:40:45 PM
Keith,

We went through a similar thought process here with a project a couple of years ago.  We went with the single SQL database with unique user IDs, and glad we did.

MySQL is our database solution for nearly all our NetTalk proejct now.  We only use MS-SQL whenever the clients specifically request it to suit their network requirements.  We never use TPS anymore for NetTalk sites.

One of the biggest benefits we found with a single database table, was that it made it really easy for US to administrate and to check user activity levels etc.  We could easily tell which users were more active than other, plus run other periodic metrics and statistics in the database because all the data was in one place.  Trying to do that over a thousand separate sets of data would have been a nightmare.

Hope this helps.

Devan
8  The Rest Of NetTalk / The Rest - Ask For Help / Re: Multiple page requests with NetWebClient on: March 27, 2014, 08:08:30 PM
Thanks Bruce,

I did as you suggested and split the routine up into two parts, i.e. populate a queue from the SQL database, then run a process to 'run down' the queue and perform the fetches.

It still needed some deft timing to ensure that the processing didn't start a race condition.  I tried using the ThisNetWebClient.Busy property within the loop to see if the previous Fetch() was still working but didn't seem to have much luck with that, so I ended up creating a local BYTE variable called LOC:Busy which I set upon calling the Fetch() routine and cleared when ErrorTrap() and PageReceived() were called, and that seemed to work fine for my needs.

Cheers,
Devan
9  The Rest Of NetTalk / The Rest - Ask For Help / Multiple page requests with NetWebClient on: March 26, 2014, 08:43:37 PM
I have a small Clarion applet which runs a NetWebClient Fetch() against a web service.  Sometime only one page, but often 3 or 4 pages depending on the results of a SQL query.

I have the Fetch()es in a loop, i.e.

Code:
Loop
  Next(SQLFile)
  If Error() Then Break.
  ThisNetWebClient.Fetch('http://mywebservice.com/getarecord?id=' & SQL:SomeID)
End

I thought with asynchronous Fetch()es, that the ThisNetWebClient.PageReceived will be called each time a Fetch() returned some data, but it doesn't seem to be doing that.  So far, I trace multiple Fetch() calls going out, but only one PageReceived() being called - for the first Fetch() only.

What is the best way to queue up multiple concurrent Fetch() calls?

Thanks,
Devan
10  NetTalk Web Server / Web Server - Ask For Help / Re: CSS hierarchy tool on: March 03, 2014, 10:02:17 PM
I also use Chrome's Developer Tools option (F12 on the PC) for inspecting CSS.  Best thing ever for checking the hierarchy and also changing/removing/adding CSS code on the fly to see what will happen.

NOTE: It's all built into Chrome natively.  No need to install an extension.
11  NetTalk Web Server / Web Server - Ask For Help / NetTalk threads and open files on: March 03, 2014, 10:00:36 PM
Hi all, just come across a curious situation here, and wondering if someone can shed some light on where the problem lies.

We have designed a small NetTalk app for a customer to register walk in members for a gym.  Really simple NetTalk site with a page that asks for the member ID (which is scanned at the terminal), then another Process that checks the number against a legacy database and then displays either a "Welcome" screen or a "Please Register" screen momentarily before going back to the main screen.

The only file access is during the CheckLogin procedure that gets called by the IndexPage.  The CheckLogin process opens up the user file on the legacy database using an ODBC driver, then closes the files straight afterwards.

I thought this would only momentarily touch the files and exit, leaving those files free from locks, however the customer's IT department is saying that they cannot backup the legacy database every night because it is saying the files are open in the NetTalk app.  Closing down or restarting the NetTalk app completely appears to clear the locks.

Now, I thought that once I deliberately closed the files in the Process, or the process thread ended, the files would be closed and any locks released?  Could there be phantom threads still running in the background?  Is the fault with the third party ODBC driver?  Or the Clarion ODBC driver architecture?

The files are defined in the main app dictionary, but the files are ONLY referenced in the CheckLogin NetWebPage - which is not actually a displayed page, but a snippet of embed code that then redirects the user depending on the check login status.

It's not a huge problem, but I'm curious to know where to start looking for the issue.

Thanks,
Devan
12  NetTalk Web Server / Web Server - Ask For Help / How many using C9 now? on: February 25, 2014, 05:02:12 PM
Hey all - This is off topic I know, but I was wondering how many NetTalkers have moved up and are using C9.x for production code?

I am still on 8.0.9759 but am on the CSP and have C9 as well - just haven't bothered to upgrade all my myriad of 3rd party libraries etc. up to C9 to begin using it properly.  Been really happy with the stability of C8, so was wondering if there was any compelling reasons to step up to 9?

At this point in time, our app development word is around 60% NetTalk webapp projects and 40% Windows native projects.  All straight up Clarion, not Clarion.NET.

What are others using?  I'd be interested to hear if anyone is still on C7 or C6 even...

13  NetTalk Web Server / Web Server - Ask For Help / Re: Browse not saving data back to database? on: February 12, 2014, 12:21:58 AM
EDIT: Actually, I just checked the NetWebForm, and I must have been getting really stressed at it not working, because I have the price calculation routine called on the:

Validate::LIN:Price (even though this field is read only)
Validate::LIN:ProductCode
Validate::LIN:Quantity
PreInsert
ValidateAll
ValidateInsert

embed points within the form !!! Smiley


14  NetTalk Web Server / Web Server - Ask For Help / Re: Browse not saving data back to database? on: February 12, 2014, 12:16:17 AM
Bruce,

Your questions are actually GREAT, because they are leading me in the right track to find out what is happening.

I remember now that we DO have a calculation routine in the form to calculate the price and line total, but it never worked 100% of the time.  So I worked around this by putting the price calculation routine in the browse as well, forgetting that the Browse procedure DOESN'T ACTUALLY SAVE the line item data.  So in effect, I was just masking the fact that the problem was there, and caused by the NetWebForm in the first place! Smiley

Now, the NetWebForm really only has two changeable fields, the Product Code (which is always called from a lookup button), and the quantity.  I have set the code in the Validate::LIN:Quantity embed point to calculate the Price and LineTotal, but as I mentioned - it doesn't always seem to fire.  I think it may be depending on whether the user [Tabs] out of the quantity field, or whether they just hit the [Save] button immediately after keying in the quantity.

Need to find a better embed point to do the calculation, I think...

Cheers,
Devan
15  NetTalk Web Server / Web Server - Ask For Help / Re: Browse not saving data back to database? on: February 11, 2014, 10:42:38 PM
Thanks for the replies Kevin & Bruce.

Bruce - good call about the timing of the screenshots.  It turns out that the web screenshot was AFTER they found the missing data in the report.  I was amazed that the pricing appeared again AFTER it was zero in the database.

I checked the code again, and there IS a routine being called when the browse fields are being built.  Upon the Value::Routine embed for the LIN:Price field, a procedure gets called to calculate the default item price (It is a stupidly LONG and complicated pricing calculation).

I am thinking that this price is getting kludged at some other point when saving?

In the Value::Routine for the LIN:LineTotal field, I have a simple formula which is just LIN:LineTotal = LIN:Price * LIN:Quantity

I am assuming the LineTotal value is zero because at that point, the Price field was also zero.

Is this the best embed point(s) to be pre populating the pricing for the line items?  Should I be using a different validation embed point perhaps?

Note: These are the only two embedded bits of code in the entire browse procedure.

Pages: [1] 2 3 ... 15
Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

Login Form

Welcome Guest.






Lost Password?
No account yet? Register
home contact search contact search