A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SQLCA.dbms = ProfileString("dbServers.ini","oceanmd_db","dbms","") SQLCA.servername = ProfileString("dbServers.ini","oceanmd_db","servername","") SQLCA.database = ProfileString("dbServers.ini","oceanmd_db","database","") SQLCA.DBParm = "Host = 'Tidebox App'" SQLCA.DBParm = "Identity='SCOPE_IDENTITY()'" //new SQLCA.LogId = logname SQLCA.LogPass = logpass SQLCA.AutoCommit = FALSE
dw_station_location.AcceptText() li_r = dw_station_location.update(true, false) IF li_r = 1 THEN //SELECT @@identity INTO :new_locId FROM LOCATION USING SQLCA; SELECT SCOPE_IDENTITY() INTO :new_locId FROM LOCATION USING SQLCA; dw_stations.SetItem(li_row, "tb_station_location_id", new_locId) // Before we do the update, set all rows to NewModified! // This will insure that we inserting a new row and not updating an existing row. dw_stations.SetItemStatus(li_row, 0, Primary!, NewModified!) // do the update dw_stations.AcceptText() li_r = dw_stations.Update(true, false) IF li_r = 1 THEN uf_updatecomments(dw_stations).Update(true, true) IF li_r = 1 THEN Messagebox(confirmname, "Update Completed Successfully.") COMMIT USING SQLCA; ELSE ROLLBACK USING SQLCA; //Write to log file END IF ELSE ROLLBACK USING SQLCA; //Write to log file END IF ELSE ROLLBACK USING SQLCA; //Write to log file END IF
Database C0038: Function 'SCOPE_IDENTITY' not found. If this is a SQLJ function or SQL function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to call a web service and get the results posted in a form in PHP||9||79|
|VB.NET String Settings and Temp Folder Question||3||75|
|Why is initMap returning "not a function" error.||3||75|
|Where to download python requests library||6||68|