This topic is locked

Problem with add a record

6/4/2008 8:21:16 PM
ASPRunnerPro General questions
Y
yairilan author

Hi,

I had a problem to add a record in a simple table add page - after click on SAVE botton the "Key Field" was filled with the OwnerId's value, and the error message was about adding a dubble record.

I found out that the problem was in the "tableName_add.asp" with this 2 lines:
' insert ownerid value if exists

avalues("Field_Name")=prepare_for_db("FieldName",SESSION("" & strTableName & "_OwnerID"),"","")

When I erase these 2 lines it it works !! but now each time I "build" the project - those lines are beeing written again in the new "tableName_add.asp"
My question is - where can I fint the line in the "Project.aspr" file that creates this 2 lines and cancel it for the next "build".
Tx very much,

Yair.

Sergey Kornilov admin 6/4/2008

Make sure you are not using "Users can see and edit their own data only" security mode.

Y
yairilan author 6/9/2008

Tx, I am using it and when I canceled it it works,

But - I need this "Users can see and edit their own data only" security mode

How can I use it anyway?