links to 'open contractor'

[#1]

Hi,

Has anybody made successful links to a system called Open Contractor?

This system holds all our repairs information so trying through OBDC connection to extrapolate some of this data held in the system. In our current application we are trying to bring some job information through which we know is held in the:

Table RM-JOB-ELEMENTS and field ELEMENT-CODE.

However,. when we add this and then click reload its trying to get 500,000+ records (as mentioned system holds all repairs completed) so eventually crashes due to having to allocate too much menory. To address this thinking we need to amend the script  to highlight specific job codes within the field ELEMENT-CODE which will reduce the sample. Do this sound logical? And any advice on the script we have so far got together that isn't working:

CONNECT TO live_ih;

LOAD "ELEMENT-CODE";

SQL SELECT "ELEMENT-CODE",

IF (["ELEMENT-CODE"]) = 'G90040';

FROM PUB."RM-JOB-ELEMENTS";


Any response would be greatly appreciated.

Chris

[Josh_Good]

I think you should be using a Where clause like this:

CONNECT TO live_ih;

LOAD "ELEMENT-CODE";

SQL SELECT "ELEMENT-CODE"
FROM PUB."RM-JOB-ELEMENTS"

Where "ELEMENT-CODE" = 'G90040';

As a side note 500,000 records isn't a lot for QlikView.  Are you bringing in any other tables?  It my crashing due to a QV trying to resolve an unintended synthetic key.  Trying running the script with using the debug function and loading only a few records.  This video may help. Creating a Data Model

Go to 1:46 or so to see how to use the debugger to load a limited number of records.