NetTalk Central

Author Topic: Best embed to fill IMMD table for NetWeb Browse?  (Read 3955 times)

Neil Porter

  • Jr. Member
  • **
  • Posts: 88
    • View Profile
    • Email
Best embed to fill IMMD table for NetWeb Browse?
« on: April 30, 2014, 03:01:53 AM »
I use an SQL backend, so I quite often use a temporary table issue an SQL query on the fly, and then display the results on screen.

With the advent in NT8 and the export button, my users are getting very excited about being able to download all sorts or data, and I can see that I'm going to be generating lots of netweb browses like this so I just wanted to make sure that I'm doing things "Correctly"  ;)

I quite often embed my browse within a form, to allow my users to set a date range, and other filters, so I tend to remove the existing contents of my temporary file, and re-populate it in the Refresh::MyBrowseDetails  Routine in the form.

This seems to work OK, but I'm wondering if there is an embed point within the Browse procedure itself that I could utilise so that it doesn't matter where my browse gets called from, it will always populate the data.

There look to be quite a few candidate embeds, but I wondered if anyone could point me in the right direction?

Regards,

Neil.
Clarion 11.0.13244
NetTalk 11.04

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Re: Best embed to fill IMMD table for NetWeb Browse?
« Reply #1 on: April 30, 2014, 12:22:58 PM »
Hi Neil,

I use "After Setting Browse Behavior Settings"

-----------
Regards
Alberto

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Best embed to fill IMMD table for NetWeb Browse?
« Reply #2 on: April 30, 2014, 10:15:43 PM »
Hi Niel,

I'm not sure what you mean by "populate". I presume you've got a memory table or something?
Personally I'd only repopulate when necessary, ie when a filter changes. Presumably you have a routine to do this. Call it from the "server side code" of the filter fields.

Also, while I can see the need for this in some cases, it's a bad habit to get into. It's a lot more efficient to just do a "normal" browse on tables.

Cheers
Bruce

Neil Porter

  • Jr. Member
  • **
  • Posts: 88
    • View Profile
    • Email
Re: Best embed to fill IMMD table for NetWeb Browse?
« Reply #3 on: May 01, 2014, 01:43:15 AM »
Hi Bruce,

The table is in my dictionary, and hence I am doing a normal browse, but i'm using an SQL query to add rows to this table.

I was really asking for the correct place to call my SQL Query.

Regards,

Neil.
Clarion 11.0.13244
NetTalk 11.04

Neil Porter

  • Jr. Member
  • **
  • Posts: 88
    • View Profile
    • Email
Re: Best embed to fill IMMD table for NetWeb Browse?
« Reply #4 on: May 01, 2014, 03:09:43 AM »
Thanks Alberto,

Hi Neil,

I use "After Setting Browse Behavior Settings"



I've tested that, and it seems to work fine for me

Regards,

Neil.
Clarion 11.0.13244
NetTalk 11.04