Messages

16

Web Server - Ask For Help / Re: Refresh IndexPage after login

« on: March 30, 2016, 08:45:20 PM »

Thank you Bruce, but honestly, I do not know how to do it. Maybe a hint?

Best regards,

Djole

17

Web Server - Ask For Help / Refresh IndexPage after login

« on: March 28, 2016, 08:55:56 PM »

I have popup login form. After user login, IndexPage stay unchanged like it was before login only after refresh, by Home button on menu, rest of option become visible and user can activate other, till that moment hidden options.

How can I refresh IndexPage programmatically after user successfully login?

Best regards,

Djordje Radovanovic

18

Web Server - Ask For Help / Re: Programmatically (without user intervention) run javascript using NT9

« on: March 23, 2016, 05:29:24 AM »

My English is no better than that. 

Best regards,

Djole

19

Web Server - Ask For Help / Re: Post messages to the client

« on: March 08, 2016, 12:16:55 PM »

NT 9 Server (do not know what version) has new feature. WebSocket. This is what you need. I have never use it but it looks like what you are looking for.

Djole

20

Web Server - Ask For Help / Re: Filtering problem - MakeFilter

« on: March 02, 2016, 03:39:30 AM »

Just for clarification. This workaround works with no problem, but you must enclose your code with, in my case, this code

      if clip(left(Loc:LocateOnFields)) = 'ROB:Description'
          ...
      END

Code is needed for every locator in your browse to make changes only for fields you need.

I found some other bad behavior in locator. When I have numeric field and immediate locating after every locating code execution NT code clears locating field and if you do not type very fast you could not locate on as many characters as you need but only one or two. This workaround gives me solution to mend this problem too.

Best regards,

Djole


 

21

Web Server - Ask For Help / Re: Filtering problem - MakeFilter

« on: March 02, 2016, 03:26:36 AM »

Found the way to stop generating filter code.

    if clip(loc:LocatorValue) <> ''
      loc:FilterWas = sub(clip(FilterString),1,Len(clip(FilterString))-1)&' AND A.Description like '''&Clip(loc:LocatorValue)&'%'')'
      ThisView{PROP:Filter} = loc:FilterWas
      loc:viewoptions = bor(loc:viewoptions, Net:NoFilter)
   END

First test looks good.

Best regards,

Djole

22

Web Server - Ask For Help / Re: Filtering problem - MakeFilter

« on: March 02, 2016, 02:53:31 AM »

During my root cause analysis I found place for my code.

It is GenerateTableRows  Routine

    if clip(loc:LocatorValue) <> ''
      loc:FilterWas = sub(clip(FilterString),1,Len(clip(FilterString))-1)&' AND A.Description like '''&Clip(loc:LocatorValue)&'%'')'
      ThisView{PROP:Filter} = loc:FilterWas
    END

only trouble is that NetWeb.CLW routine SetView still tried to add locating part of filter. If I could stop generating code I will be a winner.
Now filter looks like this
 (SQL(A.PGOD =2016 and A.Internet = 1 and A.PCena > 0 AND A.Naziv like 'PLA%')) AND ( UPPER(ROB:Description ) >= 'PLA' AND  UPPER(ROB:Description ) <= 'PLA<254>')

Best regards,

Djole

23

Web Server - Ask For Help / Re: Filtering problem - MakeFilter

« on: March 02, 2016, 01:09:35 AM »

Yes, it is Browse filter. It is more complicated but for example simplicity I just use this part of filter.

My browse with no locator filter with no problem. When locator is populated with less characters it works, for example
(SQL(A.PGOD =2016 and A.Internet = 1 and A.PCena > 0)) AND ( UPPER(ROB:Description) >= 'PLAS' AND  UPPER(ROB:Description) <= 'PLAS<254>')

gives me whole dataset with for "P" starting description, same for "PL", same for "PLA" but when I enter "PLAS" there are no records.
Same apply for locator field "SAP", it gives me no dataset but "SA" gives records with start with "SA" and  records start with "SAP" too.

This is filter string when I set filter fields in classic clarion fashion.
 (ROB:PGOD =2016 and ROB:Internet = 1 and ROB:PCena > 0) AND ( UPPER(ROB:Description) >= 'PLAS' AND  UPPER(ROB:Description) <= 'PLAS<254>')

<254> is nondisplayable  character and I manually changed it.

Conclusion is that the same is for filter string no meter how they are built.

Best regards,

Djole

24

Web Server - Ask For Help / Filtering problem - MakeFilter

« on: March 01, 2016, 08:51:52 PM »

I have problem with locator field in my browse.

Example:
Locator is set on field ROB:Description. When user enter 'PLAS' and filter is set to 'Start-With' type locator my browse is empty.

I dig around and found that MakeFilter routine crates this problem. It creates filter like:
(SQL(A.Internet = 1)) AND ( UPPER(ROB:Description) >= 'PLAS' AND  UPPER(ROB:Description) <= 'PLAS<254>')
I understand that this construction is very appropriate for ISAM file drivers but there is less and less application that use them.
Firebird SQL is not happy with this construction and it returns empty dataset. I believe that this is the same for other SQL flavors.

I am sure that it is not easy to change this MakeFilter routine to give us something like A.Description like 'PLAS%' and in other variation  A.Description like '%PLAS%' but it is possible to make in template placeholder to be included in our filter like this
(SQL(A.Internet = 1 %SomeLocatingString)
%SomeLocatingString will be defined by programmer and in my case will looks like ' AND A.Description like '''&clip(UserLocatingString)&'%'''.
If UserLocatingString is empty same apply for %SomeLoactingString and it will also be empty.
This option will give us freedom to use our locating options and mend this problem.
Of course this options will be used by our responsibility.

Best regards,

Djordje Radovanovic

25

Web Server - Ask For Help / Re: DisconnectedDesktop

« on: February 25, 2016, 08:51:12 PM »

I was looking into C:\Clarion10\accessory\Capesoft\NetTalk and did not found anything like that but indeed I have same folder in my Clarion10 as you.

Thank you.

26

Web Server - Ask For Help / DisconnectedDesktop

« on: February 25, 2016, 01:37:19 PM »

I tried to find DisconnectedDesktop applications on my C: drive but no luck.
I am using Clarion10 and NetTalk9App.

Where are they hidden?

Best regards,

Djordje Radovanovic

27

Web Server - Ask For Help / Re: Webserver Big Problems

« on: February 08, 2016, 07:56:54 PM »

Maybe C10 is to blame.

Djole

28

FTP - Ask For Help / FTP Server

« on: January 29, 2016, 10:50:34 PM »

Is it possible to make FTP server with NT?
If it is possible is there any example of that?

Best regards,

Djole

29

Web Server - Ask For Help / Re: NT9 Apps Examples

« on: January 29, 2016, 01:43:03 AM »

I found examples. I believe that during some point of installation I was asked about destination folder and obviously I put it in a root of Clarion10 so all examples are in my c:\Clarion10\NetTalk\Apps folder.

Sorry for my carelessness.

Best regards,

Djole

30

Web Server - Ask For Help / Re: NT 9.03 Error in site javascript

« on: January 28, 2016, 12:41:33 PM »

+1