Messages

1

Web Server - Ask For Help / Ajax Loader

« on: February 07, 2011, 03:06:30 AM »

Any ideas why the ajax loader image (_busy) does not animate?

If I call jQuery("#_busy").show(); when opening the console, it is animating perfectly, but when browsing through records it only show the flat image.
This is also happening within the examples.

I'm using 5.15

2

Web Server - Ask For Help / Re: ValidateUpdate/All are no longer called

« on: February 03, 2011, 05:01:03 AM »

No that's the pain. I can't. I only goes wrong I my current app.

3

Web Server - Ask For Help / Re: Filters and Locators Combined

« on: February 01, 2011, 04:41:51 AM »

Problem solved...

Since I used linked tables I had to use {prop:alias} in my custom SQL() filters....

4

Web Server - Ask For Help / Re: ValidateUpdate/All are no longer called

« on: February 01, 2011, 03:44:00 AM »

Just added this debugout:
Just before 'case p_stage' I entered: db.debugout('p_stage=' & p_stage,'frmLogout')

Resulting in this debug output:

[1084] `JeGer2 - frmLogout - p_stage=0
[1084] `JeGer2 - frmLogout - p_stage=16384

No stage is called for updating the form...

5

Web Server - Ask For Help / Re: Popup title

« on: February 01, 2011, 03:11:02 AM »

crap....


Thanks! 

6

Web Server - Ask For Help / Re: Filters and Locators Combined

« on: February 01, 2011, 03:09:00 AM »

Bruce,

This is the handcoded filter:
I use the local loc:sqlfilter variable as the filter on the browse.

Code: [Select]

        loc:filter = ''
        loc:filter =  loc:filter & |
                        CHOOSE(loc:filter<>'' AND p_web.GSV('svLocVoornaam')<>'' ,' AND ','') & |
                        CHOOSE(p_web.GSV('svLocVoornaam')<>'', 'voornaam like ''%' & p_web.GSV('svLocVoornaam') & '%''', '')

        loc:filter =  loc:filter & |
                        CHOOSE(loc:filter<>'' AND p_web.GSV('svLocAchternaam')<>'' ,' AND ','') & |
                        CHOOSE(p_web.GSV('svLocAchternaam')<>'', 'achternaam like ''%' & p_web.GSV('svLocAchternaam') & '%''', '')

        loc:filter =  loc:filter & |
                        CHOOSE(loc:filter<>'' AND p_web.GSV('svLocDatum')<>0 ,' AND ','') & |
                        CHOOSE(p_web.GSV('svLocDatum')<>0, 'datum like ''%' & p_web.GSV('svLocDatum') & '%''', '')

        loc:filter =  loc:filter & |
                        CHOOSE(loc:filter<>'' AND p_web.GSV('svLocPostcodeUnique')<>'',' AND ','') & |
                        CHOOSE(p_web.GSV('svLocPostcodeUnique')<>'', 'postcodeunique like ''%' & p_web.GSV('svLocPostcodeUnique') & '%''', '')

        loc:filter =  loc:filter & |
                        CHOOSE(loc:filter<>'' AND p_web.GSV('svLocType')<>'',' AND ','') & |
                        CHOOSE(p_web.GSV('svLocType')<>'', 'type like ''%' & p_web.GSV('svLocType') & '%''', '')

        loc:filter = loc:filter & |
                        CHOOSE(loc:filter<>'',' AND ','') & |
                            ' PlaatsnaamId IN (SELECT PlaatsnaamId FROM PlaatsnaamRechten ' & |
                            'WHERE PlaatsnaamRechten.MedewerkerId=' & p_web.GSV('SV:MedewerkerID') & ')'
       
        db.debugout('browseNAW filter=' & loc:filter)
       
        if loc:filter <> '' then loc:sqlfilter = 'SQL(' & loc:filter & ')' .


7

Web Server - Ask For Help / Re: Popup title

« on: January 31, 2011, 10:54:14 AM »

Just tried to test this in example 3.

I entered this inside the BrowseRow, Set Queue Record EMBED:

Code: [Select]

p_web.site.ViewButton.PopupHeader = 'TEST' & MAI:MailBoxName
p_web._Trace('p_web.site.ViewButton.PopupHeader =' & p_web.site.ViewButton.PopupHeader )

The result in DebugView is in Capture1.PNG
The result on the screen (in the popupheader) is just a simpel space.
See Capture2.PNG

[attachment deleted by admin]

8

Web Server - Ask For Help / Re: Popup title

« on: January 31, 2011, 06:00:00 AM »

I understand the popupheader property, but now I think there is a limitation.

I would like the header to be changed whenever I select another row in the browse.
Basically I would like to to something like this in the CallClicked EMBED:

Code: [Select]

p_web.SSV('svMedewerkerNaamSelected',SQLCmd('SELECT Naam FROM Medewerker WHERE Id=' & p_web.GSV('Med:Id')))
p_web.site.InsertButton.PopupHeader = 'Nieuwe Medewerker'
p_web.site.CopyButton.PopupHeader = 'Nieuwe Medewerker (Kopie [' & p_web.GSV('svMedewerkerNaamSelected') & '])'
p_web.site.ChangeButton.PopupHeader = 'Wijzigen Medewerker [' & p_web.GSV('svMedewerkerNaamSelected') & ']'
p_web.site.ViewButton.PopupHeader = 'Medewerker [' & p_web.GSV('svMedewerkerNaamSelected') & ']'

Is this possible?

9

Web Server - Ask For Help / Browse with View, different Prefixes

« on: January 31, 2011, 05:42:29 AM »

Hi,
In my dictionary I have two tables for example. One is called CARS with prefix CAR. And the other one is a VCARS which is a view on the backend and therefor has a different prefix VCAR.
When I configure a browse with the table (view) VCARS and tell it to use the form for updating the CARS table, I cannot use the default Edit/View/Delete row buttons, because of the different prefixes.
How can I solve this. I now do this with custom row buttons, but they don't support the POPUP mechanism. I would like to use the default buttons. But how?

10

Web Server - Ask For Help / Re: Child browse empty at first

« on: January 31, 2011, 05:22:22 AM »

Same here for quite a long time. Happy to see this one solved... 

11

Web Server - Ask For Help / Filters and Locators Combined

« on: January 31, 2011, 05:20:38 AM »

Hi,

When having a browse with a filter in place the locator doesn't seem to work.
It doesn't matter what kind of filter, just having confgured one breaks the locator.

Any ideas?

12

Web Server - Ask For Help / ValidateUpdate/All are no longer called

« on: January 31, 2011, 02:02:29 AM »

Hi,

I have a logout form in place for quite a long time. Now all of a sudden this does not work any more. When tracking down the cause, I found out that the embeds ValidateUpdate and ValidateAll on this form are not called.
This form is used to 'logout' the user with the following code in the ValidateUpdate embed (like example 3).

    p_web.SetSessionLoggedIn(0)
    p_web.DeleteSession()
    db.DebugOut('p_web.GetSessionLoggedIn()=' &p_web.GetSessionLoggedIn(),'frmLogout')

The debug is placed to see if this embed is called.

But it doesn't. Also when deleting this form and recreate it again doesn't help.
What am I doing wrong of overseeing here?

13

Web Server - Ask For Help / Re: Problem with Lookup

« on: January 28, 2011, 05:10:47 AM »

Hoi Rene,

Maybe you are right, but I think this is regarding the PrimaryKey. That is indeed also configured in my browse as the primary key with only one field. But I have an index on the backend (sybase sql) that has a key with three fields. And it was configured for two. So I somethings created non-unique records.

Groeten!
Sjoerd

14

Web Server - Ask For Help / Re: Problem with Lookup

« on: January 26, 2011, 11:47:08 PM »

Bruce,

The table on the browse is the 'link' table of three related tables.
So I have four tables:

-RegistratieVraagAntwoord (RegistratieId,VraagId,AntwoordId)
-Registratie
-Vraag
-Antwoord

As answer to your question: the RVAUniqueKey contains VraagId and AntwoordId, but I have forgotten to put RegistratieId in there as well, since combination VraagId and AntwoordId could possibly already have occurred.

Thanks for shining this light

15

Web Server - Ask For Help / Problem with Lookup

« on: January 26, 2011, 02:17:18 AM »

Hi

I have a browse with EIP lookups. When answering all the lookups they all go OK, but every 4/5 lookups I get this error message:



When clicking OK (on the serverside) it looks like everything is continuing as it's supposed to.

As you can see on the last row (where the message appeared) the unique code is showing. When pressing OK the correct description is visible again.

What can this be?