Samuel Koops
|
| Posted: 07/24/2006, 11:02 AM |
|
Defining my query in Query Builder produced a nonsense SQL statement (first
error!) so I tried it in ms-access and it was executable (delivered correct
data):
SELECT tbl_or.Pfad AS Organisation, tbl_ma.Name AS Name, tbl_ma.Vorname AS
Vorname, tbl_an.Bezeichner AS Anlage, tbl_an_kat.Bezeichner AS
Anlagenkategorie, tbl_st.Bezeichner AS Standort, tbl_as.Bezeichner AS Asset,
tbl_mo.Bezeichner AS Modell
FROM (((((((tbl_or INNER JOIN int_ma_or ON tbl_or.ID = int_ma_or.ID_OR)
INNER JOIN tbl_ma ON int_ma_or.ID_MA = tbl_ma.ID) INNER JOIN int_ma_an ON
tbl_ma.ID = int_ma_an.ID_MA) INNER JOIN tbl_an ON int_ma_an.ID_AN =
tbl_an.ID) INNER JOIN tbl_an_kat ON tbl_an.ID_AN_Kat = tbl_an_kat.ID) INNER
JOIN tbl_st ON tbl_an.ID_ST = tbl_st.ID) INNER JOIN tbl_as ON tbl_an.ID =
tbl_as.ID_AN) INNER JOIN tbl_mo ON tbl_as.ID_MO = tbl_mo.ID;
Then I copied the statement into a empty Query Builder and within the
Builder it delivered me correct data too. Then I produced a Report and got
the error, Gridbuilder did the same.
Fehlertyp:
ADODB.Recordset (0x800A0E78)
Der Vorgang ist für ein geschlossenes Objekt nicht zugelassen.
/IuK_DB/Classes.asp, line 3193
????
Any ideas?
Thanks
SAM
|
|
|
 |
|
