I am trying to use Webfocus to query an MS Access database and I am getting strange results. If I take a sample of data from the Webconsole it looks fine but if I try to query the data through Devstudio I get the same record repeated over and over again. The table is named CONTACT and REGID is the key field. There is no record with a REGID of "0" but that what shows up in the results through Devstudio. I setup this scenario on my PC and it works fine but trying to do this on the server seems to have the issue.

FILENAME=CONTACT, SUFFIX=SQLMAC  , $
  SEGMENT=CONTACT, SEGTYPE=S0, $
    FIELDNAME=REGID, ALIAS=RegID, USAGE=I11, ACTUAL=I4, $
    FIELDNAME=REGIDOLD, ALIAS=RegIDOLD, USAGE=I11, ACTUAL=I4,
      MISSING=ON, $
    FIELDNAME=LASTN, ALIAS=Lastn, USAGE=A19V, ACTUAL=A19V,
      MISSING=ON, $
    FIELDNAME=FIRSTN, ALIAS=Firstn, USAGE=A15V, ACTUAL=A15V,
      MISSING=ON, $
    FIELDNAME=AGENCY, ALIAS=Agency, USAGE=A60V, ACTUAL=A60V,
      MISSING=ON, $
    FIELDNAME=PROGRAM, ALIAS=Program, USAGE=A60V, ACTUAL=A60V,
      MISSING=ON, $
    FIELDNAME=STREET, ALIAS=Street, USAGE=A139V, ACTUAL=A139V,
      MISSING=ON, $
    FIELDNAME=ADDRESS2, ALIAS=Address2, USAGE=A31V, ACTUAL=A31V,
      MISSING=ON, $
    FIELDNAME=CITY, ALIAS=City, USAGE=A15V, ACTUAL=A15V,
      MISSING=ON, $
    FIELDNAME=STATE, ALIAS=State, USAGE=A10V, ACTUAL=A10V,
      MISSING=ON, $
    FIELDNAME=ZIP, ALIAS=Zip, USAGE=A22V, ACTUAL=A22V,
      MISSING=ON, $
    FIELDNAME=OLD_ADDRESS2, ALIAS=Old_Address2, USAGE=A31V, ACTUAL=A31V,
      MISSING=ON, $
    FIELDNAME=OLD_CITY, ALIAS=Old_City, USAGE=A15V, ACTUAL=A15V,
      MISSING=ON, $
    FIELDNAME=OLD_STATE, ALIAS=Old_State, USAGE=A122V, ACTUAL=A122V,
      MISSING=ON, $
    FIELDNAME=OLD_ZIP, ALIAS=Old_Zip, USAGE=A22V, ACTUAL=A22V,
      MISSING=ON, $
    FIELDNAME=PRIMARYPHONE, ALIAS=Primaryphone, USAGE=A15V, ACTUAL=A15V,
      MISSING=ON, $
    FIELDNAME=EXTPHONE, ALIAS=EXTphone, USAGE=A15V, ACTUAL=A15V,
      MISSING=ON, $
    FIELDNAME=SECONDARY, ALIAS=Secondary, USAGE=A21V, ACTUAL=A21V,
      MISSING=ON, $
    FIELDNAME=EMAIL, ALIAS=Email, USAGE=A43V, ACTUAL=A43V,
      MISSING=ON, $
    FIELDNAME=FAX, ALIAS=Fax, USAGE=A10V, ACTUAL=A10V,
      MISSING=ON, $
    FIELDNAME=CATEGORY, ALIAS=Category, USAGE=A8V, ACTUAL=A8V,
      MISSING=ON, $
    FIELDNAME=LAST4SSN, ALIAS=Last4SSN, USAGE=A22V, ACTUAL=A22V,
      MISSING=ON, $
    FIELDNAME=GENDER, ALIAS=Gender, USAGE=A6V, ACTUAL=A6V,
      MISSING=ON, $
    FIELDNAME=ETHNICITY, ALIAS=Ethnicity, USAGE=A28V, ACTUAL=A28V,
      MISSING=ON, $
    FIELDNAME=AGE, ALIAS=Age, USAGE=A50V, ACTUAL=A50V,
      MISSING=ON, $
    FIELDNAME=POSITIVESUPPORTS, ALIAS=PositiveSupports, USAGE=A255V, ACTUAL=A255V,
      MISSING=ON, $
    FIELDNAME=COMMUNITIESREP, ALIAS=CommunitiesRep, USAGE=A255V, ACTUAL=A255V,
      MISSING=ON, $
    FIELDNAME=NOTES, ALIAS=Notes, USAGE=A255V, ACTUAL=A255V,
      MISSING=ON, $
    FIELDNAME=BIOONFILE, ALIAS=BioOnFile, USAGE=I11, ACTUAL=I4, $
 

Webfocus 7.6.8
Windows Server 2003

This message has been edited. Last edited by: dendem,

P.S.

If I use a SQL command it works fine:

SQL
SELECT *
FROM CONTACT
END

This gives me the correct results.

Resolved. I had it in the EDASPROF.