VB Forms

hbNew Member

Hi.. I have created some very simple forms in VB6 that reads information from the current record in Maximizer. I have used the integrators toolkit library i.e using getfield and setfield. However the problem is when I am trying to read lots of udf's more than 20, when the form loads and again upon closing and updating, there is atleast a 6 sec delay before this is done.

Also I have written a loop that allows me to scroll down the maximizer address book and read information in udf's and update other udf's accordingly. THis however takes forever, and by that I mean about 10-15 secs per record and there are hundreds a day.

Any thoughts please?

9/27/007:33 AM

❤️ 0

Original Post

Replies sorted oldest to newest

advocosupportMaximizer CRM Consultants

Hi,

For your first problem what you need to do is read in the information and then write it as a chunk. Try using the command "setupdatemode" around your updates.

For your second problem in order to speed up your piece of code what you need to do is minimise other activities when moving between records. e.g. do not allow the system to write to the screen unless needed. You need use the command "refreshwindows".

If you are still having problems then we can always develop to a spec for you

Nick Welburn
CABC Technical Support Manager

10/11/006:58 PM

❤️ 0

hbNew Member

Great... I'll try that. But I have tried using setting the refreshwindows to false but it still appears to update the windows. Is the command no refreshwindows(false)???

Also how can I insert opportunities using code?

Thanks

10/12/006:59 AM

❤️ 0

advocosupportMaximizer CRM Consultants

Hi,

The appropriate command is refreshwindows(false), are you sure that you have called it in the correct place. Also check that you are not getting an error raised at any point. Other than that the best advice I can give you is to just tinker with the code.

On the subject of trying to insert opportunities using code you will probably need to use the ODBC driver. This isn't really something that I can describe by Email. Do you have a copy of the integrators toolkit? If not we can supply you with one. If you wish to contact us our details are on www.cabc.co.uk

Regards,

Nick Welburn
CABC Support

10/12/008:34 PM

❤️ 0

hbNew Member

I do have a copy of the Toolkit.. am i right in thinking I need to use the OMS hook, if so where do I place this and when do I call it?

Thanks

10/12/009:46 PM

❤️ 0

elmurNew Member

OMS Hook Is not really used for that.
The OMS Hook is used for Triggering actions on opening an Opportunity.
What you can use is an insert table into the Opportunity Tables. These are availible in the Toolkit

11/13/002:04 PM

❤️ 0

hbNew Member

Thanks for That. That worked. However when I try to use variables to feed information into the SQL statement, in particular for Team_id, it gives me an error in assignment. I am assigning a integer to it through a variable. But when I just use the actual value in the Statement it works fine.

Any ideas...

Thanks very much.

11/20/006:20 PM

❤️ 0

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...