pcsoft.us.windevCopyright 2026, PC SOFT18 Aug 2015 17:19:00 Z18 Aug 2015 12:03:00 ZHi - Can't figure this out - sSQL is string = [ Select gpoDB:m_sdContactList_ActiveOrEnrolled.GUIDHFContact, gpsdContact.sFirstName, gpsdContact.sLastName, gpsdContact.nContactSimpleID FROM gpoDB:m_sdContactList_ActiveOrEnrolled, gpsdContact WHERE gpsdContact.GUIDHFContact = gpoDB:m_sdContactList_ActiveOrEnrolled.GUIDHFContact ORDER BY gpsdContact.sLastName, gpsdContact.sFirstName ] IF NOT HExecuteSQLQuery(gpoDB:m_sdReportSource,sSQL) THEN gpoError:CaptureError(HErrorInfo()) // Error while declaring the file, display the error END I keep getting the error - Unexpected Word "," gpoDB:m_sdContactList_ActiveOrEnrolled is a Data Source initialized earlier.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot/read.awp[WB19] - Help with SQL Statement - unexpected word ","moderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53575/read.awp18 Aug 2015 17:19:00 ZHi Joel, With text sql queries you need to use stringbuild to insert parameters into the query: gpsdContact.GUIDHFContact = …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53575/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53575/read.awp[WB19] - Help with SQL Statement - unexpected word ","Re: [WB19] - Help with SQL Statement - unexpected word ","guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53573/read.awp18 Aug 2015 14:14:00 ZHi Fabrice and thank you. Can't use the Query Editor because there is no analysis in the Project. Analysis is in only 1 project …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53573/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53573/read.awp[WB19] - Help with SQL Statement - unexpected word ","Re: [WB19] - Help with SQL Statement - unexpected word ","guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53572/read.awp18 Aug 2015 12:40:00 ZHi Joel 1. if you use the query editor, you won't have this kind of problems, as the syntax will ALWAYS be correct 2. I'm …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53572/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53568-wb19-help-with-sql-statement-unexpected-word-quotquot-53572/read.awp[WB19] - Help with SQL Statement - unexpected word ","Re: [WB19] - Help with SQL Statement - unexpected word ","