Create Database Resource using Native SQL

[alvinsanusi]

I am creating a Database Resource. In the SQL Editor, I select Native SQL
and in the Select tab, I type in:

SELECT A.CLNTPFX, A.CLNTCOY, A.CLNTNUM, A.SURNAME, A.GIVNAME, B.ADDRTYPE, B.CLTADDR01, B.CLTADDR02, B.CLTADDR03
FROM DBASE_CLIENT.CLNTMAST A INNER JOIN DBASE_CLIENT.CLNTADDR B
ON A.CLNTPFX = B.CLNTPFX AND A.CLNTCOY = B.CLNTCOY AND A.CLNTNUM = B.CLNTNUM AND B.ADDRTYPE = '*'

So far so good. But I don't know how to bring in the Resource fields. The Resource fields box is empty and I can not create table using the resource.

Can anyone tell me which steps I missed out? Thanks beforehand.

[Jon]

You need a resource field for each column returned, so in your case: CLNTPFX, CLNTCOY etc
These resource fields then get mapped to form fields.

There is an alternative approach from V5.2 where you don't need mappings, but you then have to process the results yourself in code:
services.database.executeSelectStatement(databaseConnectionName, sqlStatement, callbackFunction)

[alvinsanusi]

Thank you Jon,

Found the way already.
And thank you for additional information for version 5.2

Best Regards,

Alvin