[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