Information générale
Catégorie:
Codage, syntaxe et commandes
>When I run the View Designer I get the following message when I try to quit the designed:
>
>SQL Column "Auth_code" is not found. There is an auth_code field in each of the tables that makes reference to them. I picked them with the designer. Here is the SQL code when viewed:
>
>SELECT *;
> FROM calllink!faxque INNER JOIN calllink!schedule;
> INNER JOIN calllink!pending;
> INNER JOIN calllink!assigned;
> INNER JOIN calllink!account ;
> ON Assigned.actnum = Account.actnum ;
> ON Pending.actnum = Assigned.toll ;
> ON Faxque.audit_num = Pending.audit_num ;
> ON Faxque.audit_num = Schedule.audit_num
>
>What is going on?
>
>Ed
I made a Typo. The error is: "Audit_num" is not found.
PS: How do you delete a thread when you discover an error afer you send it?
Ed
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement