|
P
psciga author
Hello,
I'm working with PHPR 8.0 (Build 23540 x64) on Win7 x64 (PHP 5.3.8-X64) and connecting a SQL Anywhere 16 database via ODBC connection string.
In PHPR I can do all I need without any problem. After building I can call all single pages in the browser.
So far so good.
When build a master/detail relationship, the following ODBC error occures in the browser when calling the master table:
Fehlertyp 2
Fehlerbeschreibung odbc_exec() [function.odbc-exec]: SQL error: [Sybase][ODBC Driver][SQL Anywhere]Syntaxfehler bei '.' in Zeile 3, SQL state 37000 in SQLExecDirect
URL localhost/mapguide/vertrieb/DBA_Adr_Firma_list.php?
Fehlerdatei C:\apps\OSGeo\MapGuide\Web\www\vertrieb\connections\ODBCConnection.php
Fehlerzeile 72
SQL Abfrage SELECT Adr_ID, Kunde_Flag, Koord_Y, Koord_X, Name1, Name2, Strasse, Land, PLZ, Ort, Postfach, PF_PLZ, BLand_ID, Vorwahl, Telefon, Telefax, Mobil, WWW, Anrede_Brief, Bemerk, Klasse_ID, KQuelle, Einwohner, UntArt_ID, Bearb_ID, Erf_Datum, Last_Datum, WV_Datum,(SELECT count(*) FROM (SELECT Adr_ID FROM DBA.Adr_Personen ) subQuery_cnt WHERE subQuery_cnt.Adr_ID=DBA.Adr_Firma.Adr_ID) as DBA.Adr_Personen_cnt FROM DBA.Adr_Firma ORDER BY 1 ASC
Calling the details table is possible.
Using my old version of PHPR 7.0 (Build 19042) on Win XP SP3 32 Bits NO errors happen. The database and database engine is the same (SQL Anywhere 16) but 32 bit.
Then I copied the output files from XP- to my Win7-PC and got also NO errors.
Please tell me how to find the error.
Thank you in advance!
Best regards,
Peter
|
|