Getting error message when using SQL for data source in ADOC
Need help. VB neophyte here. Getting error message "Complex Query" when
attempting to use VisiData to create query for record source for
ADOC data source. Trying to recreate what we did in access for a query;
e.g. using four tables that are joined together. Listed the fields in
VisiData new query function, and made four joins for the four tables.
But got "Complex Query" error message when trying to run it or
using the fields to assign to a text box.
The query from VisiData is as follows:
SELECT CASEFILE.*, CLIENT.*, ENROLL.*, [PROVIDER NAMES].*
FROM CASEFILE, CLIENT, ENROLL, [PROVIDER NAMES]
WHERE (CASEFILE.CNUM = '' ) And (CASEFILE.CNAME = '' ) And
(CASEFILE.STREET = '' ) And (CASEFILE.CITY = '' ) And (CASEFILE.STE = ''
) And (CASEFILE.ZIP = '' ) And (CASEFILE.PHONE = '' ) And
(CASEFILE.TXTYPE = '' ) And (CASEFILE.REASON = '' ) And
(CASEFILE.MAILSTRET = '' ) And (CASEFILE.MAILCITY = '' ) And
(CASEFILE.MAILSTE = '' ) And (CASEFILE.MAILZIP = '' ) And (CLIENT.CIN =
'' ) And (CLIENT.DOB = '' ) And (CLIENT.CATCD = '' ) And (CLIENT.COVCD =
'' ) And (CLIENT.MATO = '' ) And (CLIENT.SSN = '' ) And (CLIENT.FRSTNAM
= '' ) And (CLIENT.LSTNAM = '' ) And (CLIENT.INDVSTAT = '' ) And
(ENROLL.ENROLDATE = '' ) And (ENROLL.DISDATE = '' ) And (ENROLL.REASON =
'' ) And (ENROLL.INDST = '' ) And (ENROLL.STARTDATE = '' ) And
(ENROLL.PROVIDER = '' ) And (ENROLL.RECERTED = '' ) And (ENROLL.GUARDATE
= '' ) And (ENROLL.PENDDATE = '' ) And (ENROLL.PENDPROV = '' ) And
(ENROLL.STATUS = '' ) And (ENROLL.NPCHAN = '' ) And (ENROLL.MEMO = '' )
And (ENROLL.PSTATDT = '' ) And (ENROLL.CHANGDATE = '' ) And
(ENROLL.CHANGWHO = '' ) And ([PROVIDER NAMES].[PROVIDER NAME] = '' ) And
CASEFILE.CNUM=CLIENT.CNUM And CLIENT.CIN=ENROLL.CIN And
ENROLL.PROVIDER=[PROVIDER NAMES].PROVCODE;
ANY AND ALL HELP IS APPRECIATED IN ADVANCE.
BOB GEEZER HERE! ;)
Sent via Deja.com http://www.*-*-*.com/
Before you buy.
