strsqlUpdate

What event do you use?
Instead of executing queries I recommend to print them on the page to see if everything looks good.

What event do you use?

I dont know what you mean by event, please explain <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23600&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
the keys("id") part returns nothing instead of the id of the line that was just updated (this is what im trying to get) all the rest works fine..

Where do you put this code?

Where do you put this code?

I use it in edit - afteredit - custom

What version of ASPRunnerPro do you use?

What is the actual name of key column?
Instead of executing the query print it on the web page and post it here.
response.write strSQLUpdate

response.write strSQLdrop

response.write strSQLInsert
'dbConnection.execute strSQLUpdate

'dbConnection.execute strSQLdrop

'dbConnection.execute strSQLInsert

What version of ASPRunnerPro do you use?

I'm using asp pro 5.1 latest build.

the column name is id
and the output of strSQLUpdate is:
update RBV_WS_NTS_CALC_nts_retail_rates set Chargeband_Name = tbl.Chargeband_Name, Chargeband_Description = tbl.Chargeband_Description, WholesalePriceClass = tbl.WholesalePriceClass, Start_Date = tbl.Start_Date, End_Date = tbl.End_Date, Daytime_ppm = tbl.Daytime_ppm, Evening_ppm = tbl.Evening_ppm, Weekend_ppm = tbl.Weekend_ppm, Daytime_ppc = tbl.Daytime_ppc, Evening_ppc = tbl.Evening_ppc, Weekend_ppc = tbl.Weekend_ppc, Retail_CB = tbl.Retail_CB from RBV_WS_NTS_CALC tbl where RBV_WS_NTS_CALC_nts_retail_rates.id = ''
it completely idnores the keys part. I also tries with dict and no results...

I see what you saying.
You can post your application to Demo Account and send the URL to support@xlinesoft.com along with your order number.