I just got an error message when reading data from a replicated table.
The SQL statement is
sql = "Select DISTINCT p.*, f.Firmen_Nr, f.Firmen_Name" _
& " From Projekte p, ProjektPartner pp, Firmen f" _
& " Where p.ProjektID=pp.ProjektID" _
& " And f.Firmen_Nr=p.FirmenNr"
The message (I get it in German) is number -2147217887 and like "If you
select distinct values (s_ColLineage) no Memo- or OLE-object must be
included."
What's with this message? Is this due to the p.*?
Lothar Geyer
Cheval - 19 Apr 2005 23:15 GMT
Memo fields cannot be indexed or grouped by. They even have to have their
own system replica fields to deal with them. Yes.
I just got an error message when reading data from a replicated table.
The SQL statement is
sql = "Select DISTINCT p.*, f.Firmen_Nr, f.Firmen_Name" _
& " From Projekte p, ProjektPartner pp, Firmen f" _
& " Where p.ProjektID=pp.ProjektID" _
& " And f.Firmen_Nr=p.FirmenNr"
The message (I get it in German) is number -2147217887 and like "If you
select distinct values (s_ColLineage) no Memo- or OLE-object must be
included."
What's with this message? Is this due to the p.*?
Lothar Geyer