Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Error
Message
 
 
À
17/02/2007 17:11:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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:
01196863
Vues:
9
Which column is of type 'uniqueidentifier'?

>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
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform