Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Error
Message
De
17/02/2007 17:11:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remote View Error
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01196851
Message ID:
01196851
Vues:
45
Anybody know what this error message means?

Error In SQL: Error number 8169 Connectivity error: [Microsoft][ODBC SQL Server Driver] [SQL Server] Syntax error converting from a character string to uniqueidentifier.

I get this message when I try to save the view in VE Professional.
SELECT Assessors.cFax, ;
      Audits.cCert, ;
      Customers.cCompany, ;
      Audits.dAuditSched, ;
      Audits.cAudit_Types, ;
      Audits.cAudSubType, ;
      Standards.cStandard, ;
      Standards.cStndDate, ;
      Customers.cPCity, ;
      Customers.cPState, ;
      Audits.cAuditID, ;
      Assessors.cLast_Name, ;
      Assessors.cFirst_Name, ;
      (RTRIM(clast_name)+', '+cfirst_name), ;
      Audit_team.cInitials, ;
      Audit_team.cJob, ;
      Audit_team.dStart, ;
      Audit_team.dEnd, ;
      Audit_team.nAudit_Days, ;
      Employees.cName, ;
      Status_codes.cDescription;
   FROM dbo.Audits Audits ;
      LEFT JOIN dbo.Registration Registration ;
         ON Audits.cRegistration_cId = Registration.cId ;
      LEFT JOIN dbo.Status_Codes Status_codes ;
         ON Registration.cStatus_Codes_cid = Status_codes.cId ;
      LEFT JOIN dbo.Employees Employees ;
         ON Registration.cResponsible = Employees.cId ;
      LEFT JOIN dbo.Audit_Team Audit_team ;
         ON Audits.cAuditID = Audit_team.cAuditID ;
      LEFT JOIN dbo.Assessors Assessors ;
         ON Audit_team.cAssessors_cId = Assessors.cId ;
      LEFT JOIN dbo.Standards Standards ;
         ON Audits.cAudStd_cid = Standards.cid ;
      LEFT JOIN dbo.Customers Customers ;
         ON Registration.cCustomers_cid = Customers.cId ;
   WHERE (Audits.dStart >= getdate() ;
      OR Audits.dStart IS NULL) ;
      AND Assessors.cId = ( ?VP_Assessors_cId ) ;
   ORDER BY Audit_team.dStart
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform