Sorry to bother you but I have been working with parts of your Contact database and I have ran into an issue. I have ported the backend to SQL Server but I ran into an issue with fnd_AdrID listbox. When I run the record source:
SELECT qCart.CID AS CIDq, qCart.TypIDadr, Adr.CID, Adr.AdrID, IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr] AS [Address Type], [Ctry] & (" "+[St]) & (", "+[City]) & (", "+[zip]) & (", "+[Addr1]) & (", "+[Addr2]) & (" -- "+[Area]) & (" ("+[adrNote]+")") AS Address
FROM (SELECT C.CID, AdrTy.TypIDadr, AdrTy.TypAdr FROM c_AdrType AS AdrTy, c_Contact as C) AS qCart LEFT JOIN c_Address AS Adr ON (qCart.TypIDadr = Adr.TypIDadr) AND (qCart.CID = Adr.CID)
WHERE qCart.CID = 759 ORDER BY IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], Adr.Ctry, Adr.St, Adr.City, Adr.Addr1;
FROM (SELECT C.CID, AdrTy.TypIDadr, AdrTy.TypAdr FROM c_AdrType AS AdrTy, c_Contact as C) AS qCart LEFT JOIN c_Address AS Adr ON (qCart.TypIDadr = Adr.TypIDadr) AND (qCart.CID = Adr.CID)
WHERE qCart.CID = 759 ORDER BY IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], Adr.Ctry, Adr.St, Adr.City, Adr.Addr1;
I get the following message:
[Microsoft][SQL Server Native Client 11.0][SQL Server]
The multi-part identifier "AdrTy.TypIDadr" could not be bound. (#4104) The multi-part identifier "AdrTy.TypAdr" could not be bound. (#4104) The multi-part identifier "AdrTy.TypIDadr" could not be bound.
t must be SQL Server coughing on it because it runs fine your sample. Any ideas?
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar