472,103 Members | 1,073 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

Adding infos to my Database using ASP programs keeps on deleting infos in my Database

Good day to everybody!

I have been having this problem for quite a few times already.

I have been trying to add informations to our database, the programs on my add page (entry_schedule.asp) is working great, it could add infos to the Database, no problem but for some reason when i am using it for a long time already it just deletes the informations in the Database so i would go back again to information number 1.

Say i am adding informations and i am half way through already and hit my Add button it will just show this error:

ADODB.field error (800aObcd)
Either bof or eof is true, or the current record has been deleted.
Requested operation requires a current record.

And when i check my database, the informations are all gone

I am confused now and i don't know what was going on. I don't even know if it's my program or some virus out there.

If anyone could tell me what can i do or direct me to a software place to avoid this, i would greatly appreciate it.

Thank you so much,

Celi
Oct 31 '06 #1
1 1239
nedu
65
Hi Celi,

For this problem u shall use the transactions in the connection object . .

Use the beginstrans,committrans,rollbacktrans property of the connection obj . .
Nov 2 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by mirko | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.