[Gambas-user] [Gambas Bug Tracker] Bug #1296: not able to use db.find or sql.request with postgreSQL
bugtracker at gambaswiki.org
bugtracker at gambaswiki.org
Sun Apr 15 15:11:14 CEST 2018
http://gambaswiki.org/bugtracker/edit?object=BUG.1296&from=L21haW4-
Comment #1 by BenoƮt MINISINI:
You didn't understand that you are calling different methods, and so the substitution index always starts with "&1":
objSqlRequest = New SqlRequest(SYS.conMain)
Print objRequest.Select("HDR", "TXT").From("MA00").Where("MDL = &1", VAR.INFCOD).And().Where("TNR = &1", VAR.INFMOD).And().Where("AS4LOCAL = &1", VAR.SYSLNG).OrderBy("HDR DESC").Get()
More information about the User
mailing list