Messages

61

Web Server - Ask For Help / Re: SetSessionValue

« on: May 06, 2014, 10:43:57 AM »

Hello Brian,

Have You remembered to add the fields CVF:PayValue etc in the Reset -table on the Client-Side Tab on your check-box?
I usually forget...

:: rainer

62

Web Server - Ask For Help / Re: Missing proceduredefinition

« on: May 05, 2014, 11:47:46 PM »

Hi Rene

Don't know if this is of any help
I struggled with a similar thing often - at least with older NT versions.
Sometimes the errors appeared and did not disappear until I regenerated everything. The problem was that the errors appeared again on next compilation.
I noticed this happened when I added a non-nettalk procedure to the app (source, report).
If I added a new nettalk-procedure, the problem disappeared, at least until I added a new source procedure. But I have no clue what caused this.

:: rainer

63

Web Server - Ask For Help / Re: NT7 -> NT8 redactor broken?

« on: May 05, 2014, 12:51:07 AM »

Thanks,

Then TinyMCE it is!

:: rainer

64

Web Server - Ask For Help / NT7 -> NT8 redactor broken?

« on: May 04, 2014, 11:24:18 PM »

Hi everybody

Converted app from NT7 to NT8.
Redactor editor toolbar is missing icons and some funtionality.
The toolbar looks like:

</>  </>  </>  </>  </>    etc

Any ideas?
worked in NT7
TinyMCE seems to be ok.
Did run gzipall
Clarion 8
Nettalk 8.10

TIA
:: rainer

65

Web Server - Ask For Help / Re: One application with multiple databases

« on: November 18, 2013, 03:49:19 AM »

Hi,

I did start a project with filtering all data with companyId as first element but it did get a bit clumsy and complicated (and with
my skills also risky - what if the filter fails and displays all data?)

Instead, when  a new customer (with one or more users) register, the customer company gets a unique database path.
At this point the necessary directories get crated and basic data is copied.

I set the path (at login) in a sessionvariable and then let Webhandler rename all tables like "path" & '\mytablename".

I sure hope this technique also workds with SQL, just by letting Webhandler rename Glo:Owner...

:: rainer

66

Web Server - Ask For Help / Re: Killer filter SOLVED

« on: October 28, 2013, 01:25:33 AM »

Hi Kevin

Thanks for your input.
Yes, I am aware of sending filters to trace. Important to me - losing too often track of the '.

You were absolutely correct: MAK:PERIOD is actually a STRING, not a long. Clarion has tought me through the years that it is not really important what type of variables you compare, Clarion has sort of been very forgiving there converting stuff on the fly.

The solution is to use filter:

'MAK:Company = ' & p_web.gsv('Company') & ' AND MAK:Period = <039>' & p_web.gsv('period') & '<039>'

(actually I converted MAK:PERIOD to "long" in the dictionary so I don't have to be scared of filling the dard drive on the server ever again)

67

Web Server - Ask For Help / Killer filter

« on: October 27, 2013, 10:11:51 AM »

Hi,

I have been fighting with this for several days. Now even sure this is a NetTalk-problem but I can not
repeat this with a traditional Clarion app...
I have a TPS table with some 3800 payments.

I have a NetWebBrowse
A filer like 'MAK:Company = 10' is ok
a filter like 'MAK:Period = 40023' id ok.
A filter 'MAK:Company = 10 AND MAK:Period = 40023' hangs the app and the worse thing is: it starts writing a temp file that eventually FILLS THE SERVERS HARD DRIVE!

Any ideas?

The table has a key
MAK:PERIODKEY         KEY(+MAK:COMPANY,+MAK:PERIOD),DUP,OPT

COMPANY and PERIOD are Long

No relations

so I can use the range limit (This works ok) but I really do not like the disk filling effect, especially since
Bruce has convinced me that ranges are always filters.

Tried with Clarion 7 and Clarion 8, I run the table thru TPSFIX (nothing to fix)

Anything that could lighten anything on this is greatly appreciated.

:: rainer

68

Web Server - Share Knowledge / Re: Character Sets

« on: June 29, 2010, 03:21:28 AM »

Just updated to PR23 and my scandinavian characters are back - great!

I had to disable dictionary validation though in forms. This is no issue since I have no use for this anyway.
Bruce, if you are going to add translation table for scandinavian charsets, I would like help - if possible...

thanks,

rainer

69

Web Server - Share Knowledge / Re: Character Sets

« on: June 16, 2010, 03:59:34 AM »

This charset-issue is really getting to me. I am obviously doing something very wrong here.

I updated today to PR 19 and things got even worse.

I have problems presenting scandinavian characters (and all other european characters) in prompts as well as input fields. Field validation erases seemingly randomly characters including å, ä, ö (umlauts) etc.
I tried using polish or spanish language setting as Bruce wrote in another message - no help.
And the webserver even "translates" double quotes and brackets to html-code (for example: < to /&lt;) ruining ímgae displaying.
So the problem is both data displayed AND data from database (topspeed).
Any help is highly appreciated.
TIA, rainer