|
| Need to be in string format for search |
| Iniciado por guest, 20,jul. 2017 05:22 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 20,julio 2017 - 05:22 |
I can't figure out how to set this up to run right -
FOR EACH gpsdContact WHERE sFirstName [= EDT_FirstName AND sLastName [= EDT_LastName
Keeps saying it needs to be in String format like in HFilter - I can't figure out how to do it -
Help? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 05:49 |
Well, I got it to this point -
FOR EACH gpsdContact WHERE "sFirstName [=' "+EDT_FirstName+" ' AND sLastName [= ' "+EDT_LastName+" ' "
And it doesn't throw an error in the Code editor, but when I run it I get this error:
WL call:
Process of 'Click of Lnk_Go ( CELL_CellTemplate1 ) (server)' (PAGE_Select_Contact_ReferredBy_SearchName_Dialog.CELL_CellTemplate1.Lnk_Go), line 31, thread 0
What happened?
The HFSQL security mechanism was triggered while browsing the 'gpsdContact' file on the '(null)' item.
Error returned by server:
Error initializing filter.
Unexpected word: =
Error code: 70209
Level: fatal error (EL_FATAL)
WD55 error code: 209
Dump of the error of 'WDSQLSrv.DLL' module (19.0.60.2).
Debugging information:
IEWDSQLSrv=2.1
Module=
Version=<19.0.60.2>
Additional Information:
EIT_SERVEURCS :
EIT_LOGICALTABLENAME :
EIT_PILEWL :
Click of Lnk_Go ( CELL_CellTemplate1 ) (server) (PAGE_Select_Contact_ReferredBy_SearchName_Dialog.CELL_CellTemplate1.Lnk_Go), line 31
EIT_DATEHEURE : 19/07/2017 23:46:50
(25, ERR_MSG_BOX)
Ideas? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 11:12 |
FOR EACH gpsdContact WHERE "sFirstName [=' "+EDT_FirstName+" ' AND sLastName [= ' "+EDT_LastName+" ' "
I think that you don't need the first "
.... WHERE " sFirstNaam |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 14:37 |
Hi Joel,
Is gpsdContact a variable holding a file name? If yes, then it won't work. Try using the real file label instead. You cannot pass a filename as a variablle to "FOR EACH", not directly nor indirectly.
See also
http://27130.foren.mysnip.de/read.php…
Best regards
Ola |
| |
| |
| | | |
|
| | | | |
| | |
|