Slightly OT if this is more about PostGreSQL than LiveCodeServer
I'm doing my very first dbase insertion from an iRev form. finally getting
a successful a connection ID after fiddling with pg_hba.conf
ASIDE: does RevServer connect on local unix domain socket or local tcp/ip
Then tried this
Have an eye on this about irev = postgreSQL production state design skills :
put SELECT module_name,activation FROM CustModules
WHERE module_name = ' tparam1 ' into sqlStatement
put revQueryDatabase(myDatabaseID,sqlStatement) into
dbCursorID
Aloha, Pierre:
Thank you! there is nothing wrong with my SQL
If I use:
---
put INSERT INTO some-table (first_name, last_name, anonymous) VALUES
('Batman', 'MosquitoEater', TRUE); into tSQL
revExecuteSQL gConnectionID,tSQL
put the result into tResponse
---
I get '1' which is