Messages

16

Web Server - Ask For Help / Re: Browse Row CSS Classes

« on: January 14, 2013, 06:12:32 AM »

Hi Mike,

Yes, thanks, what was I thinking?  I also do this a lot, weak moment.

You can actually change the entire row, by making l:ColorResult a Byte (and set a number to this, 1,2,3, etc and then use choose(loc:ColorResult,'Green','Red,'Gray') etc in the CSS Clasess Tab in the Browse Row field.

Thanks
Charl

17

Web Server - Ask For Help / Browse Row CSS Classes

« on: January 14, 2013, 03:59:46 AM »

Hi,

I would like to change the color of a Browse Row to 'Green' if 2 conditions are met, eg

if (q:BrokerDone=1 and q:Status='B') then 'Green'.

This obviously gives an error.  Does anybody know how I can do this?

Thanks

Charl

18

Web Server - Ask For Help / Re: SessionID

« on: January 10, 2013, 05:57:20 AM »

Aah, that's a neat trick as well.

Of course, opening the Source I saw the code, and then I realised I use a Conditional Filter for this particular Browse, meaning Bruce's line did the trick once I put in in the right place.

Just shows how easy it is to forget what you did a month ago.

Thanks

19

Web Server - Ask For Help / Re: SessionID

« on: January 09, 2013, 10:05:30 PM »

Nope, that does not work.  Any other idea please?

20

Web Server - Ask For Help / SessionID

« on: January 08, 2013, 03:42:20 AM »

Hi All,

I have SessionID defined in a In Memory table in my dictionary as STRING(256).  Normally I would define it as a CSTRING but for some reason I did not (I think I read it somewhere).

Anyway, in my NetWebBrowse I defined filter as:

'WQUD:SessionID = ' & p_web.SessionID

and I tried

'WQUD:SessionID = <39>' & p_web.SessionID &'<39>'

Neither wants to work, so added the following in the Validate Record Embed point:

 if clip(WQUD:SessionId) <> clip(p_web.SessionID) then cycle.


Which then work.  So the question is, can I perhaps FIX the filter?

Thanks
Charl

21

Web Server - Ask For Help / NT7 OK.

« on: December 21, 2012, 07:22:21 AM »

Gosh, can anyone please post something like this so I can go on to it?   

Cheers
Charl

22

Web Server - Ask For Help / Re: Update Parent Browse - Accounts Example web31

« on: December 19, 2012, 05:43:21 AM »

Bruce,

You are BRILLIANT!

Danke Schoen

Charl

23

Web Server - Ask For Help / Re: Update Parent Browse - Accounts Example web31

« on: December 18, 2012, 02:50:11 AM »

Bruce,

Yes, sorry for wasting time, that was the old habit of just going to the CapeSoft folder in Clarion 8. 

Anyway, I made sure this time!

Thanks
Charl

[attachment deleted by admin]

24

Web Server - Ask For Help / Re: Reports - Progress Bar

« on: December 16, 2012, 01:14:08 AM »

I think this item has been forgotten, so to make my Sunday morning trip to the office useful:

Could you please also add an option for the 'Click here to download file' message to disappear once it has been clicked, as most of the time the pdf will anyway be deleted after it has been clicked.

Thanks and sorry for being a pain 

Charl

25

Web Server - Ask For Help / Re: Update Parent Browse - Accounts Example web31

« on: December 16, 2012, 12:44:19 AM »

Hi Bruce,

Good thing I postponed my 5 days holiday for 4 days.

Any news on this?

Thanks

Charl

26

Web Server - Ask For Help / Re: Update Parent Browse - Accounts Example web31

« on: December 11, 2012, 06:59:16 AM »

Bruce, sure, NOT always easy to tweak an example by the way!

Anyway, Account example 31 tweaked. Note:

1. Added Total field to Invoice.tps and don't do calculation in Invoices Browse, file field now.
2. Added 2 Buttons to Line Items Browse -> that goes to a Memory Form
3. One Edit button, that refreshes Browse Row, Other Insert Button that refreshes whole Browse
4. When I do something here, and Save changes, I update Invoices file total

Nevermind what I've tried, I cannot find the right place to put embed code to update the Invoices Browse (so I did not even try with the example).  So I guess, if you can please add the 6 lines of code at the right place I will probably be able to go away for Christmas.

Thanks a million

Charl





[attachment deleted by admin]

27

Web Server - Ask For Help / Re: Update Parent Browse - Accounts Example web31

« on: December 11, 2012, 02:03:56 AM »

Bruce, Yep, interesting indeed. 

Silly me did not notice the 'Paid' thing in the Invoices Browse, which means I could not do the EIP on the 1st Invoice, so I tried Change Line Item...

Please let me rephrase then:

I am calling a Pop-Up Memory Form from my equivalent of a row in the 'Line Items', which either (a) Change the Row, or (b) Add a New Row.

For (a) Change a Row - I Refresh in the Line Items the Browse Row Data and
for (b) Add a New Row, I Refresh the whole Line Items Browse.

I guess I cannot figure out the right     p_web.DeleteValue('_EIPClm_')     to use, it kind of looks wrong, I saw a _Pop-Up_ thing in the code.
I cannot figure out the right routine to place the code.

Thanks
Charl

28

Web Server - Ask For Help / Update Parent Browse - Accounts Example web31

« on: December 10, 2012, 02:09:45 AM »

Hi,

I have a similar Parent Browse -> Child Browse as per Invoices Browse in the above example.

When I update the Line Items Browse, I would like to update the Invoices Browse (the Total) as well.  This does not happen in the example, unless I press the Invoices Menu Item again (or indeed refresh in the browser in my case).  I have 'Other' Buttons on the Child Browse though.

I have tried this:

  ! End of "After Validate New Value"
  Loc:Eip = 0
  do CallBrowse
  ! Start of "After Data Refreshed"
  ! [Priority 5000]
 
    p_web.setValue('_ParentProc','')           ! Next 3 lines my Code which I saw in the web31 example, but this does not work
    p_web.DeleteValue('_EIPClm')         
    WBrowseNewSections(p_web)
   
  ! End of "After Data Refreshed"

Please, how can I do this?

Thanks

Charl

29

Web Server - Ask For Help / Re: Refresh a Field??

« on: December 10, 2012, 12:56:58 AM »

Hi,

As a matter of interest, why not just:

CASE Bil3:RouteId
      OF 6 OROF 7
          p_web.ssv('Bil3:ShipperId',  p_web.GSV('Cus3:CustomerId') )
          p_web.ssv('Bil3:ShipperName',  p_web.GSV('CustomerName') )         
      END

do Refresh::Bil3:ShipperName   ! Field is auto-validated
do SendMessage

Thanks, just wondering?

Charl

30

Web Server - Ask For Help / Re: Form with 2nd File

« on: November 23, 2012, 06:59:20 AM »

Hi Bruce,

Thanks for your pointers, yes, I forgot about that UseFile thing, I allways switch that Defer file opening to OFF in Global Properties.  If you have time, maybe you can tell me WHY that thing default to ON and what is actually the reason for that thing?  To me it feels like you just have to write another line of unnecessary code.

Anyway, I finally figured my problem out, most of the time I use Memory Forms, and then I use do openfiles and do closefiles to get the relevant information.  That appears to be a bad idea when you use a Table Form, so by simply putting access:client.open() as opposed to do openfiles, the problem disappeared.

Everyday I learn something.  Thanks.

Cheers
Charl