BOF - EOF Error!!!

This topic is locked

BOF - EOF Error!!!	3/10/2008 9:09:30 AM
ASPRunnerPro General questions
G goomba author When I try to do an IN-Line edit I get this error on several records: "Record was not edited. Either BOF or EOF is True, or the current record has been deleted..." Well BOF/EOF are both false and the record is NOT deleted. I tried editing this DB in ASPmaker (which I am using until I'm sure I want to switch) and it's fine. I can return all rows in SQL Manager - edit them etc, I can run Query Analyzer and all is well - insert, change (via SQL query). It's NOTalways the SAME two records. It is random. In one instance, the first 4 records gave me this error. In another instance, record 4, record 5, record 11 gave me this error. This happens in IE 6.x and Firefox so it's not browser specific. I started a test project, with ONLY this one table (has 30 records in it) and the same error(s) TOTALLYrandomly. Well, now what? Is this a limitation of 5.2 Evaluation?

Mark as Solved Mark as not solved

8 replies


	Sergey Kornilov admin 3/11/2008
	I guess you doing something wrong. The only way to find what exactly is wrong is to post your application to Demo Account and to send the URL to support@xlinesoft.com.


G	goomba author 3/11/2008
	I guess you doing something wrong. The only way to find what exactly is wrong is to post your application to Demo Account and to send the URL to support@xlinesoft.com. Already did that!!! I had two of my developers try their own tests today (different SQL Databases)and they have the same problems - always with the registration page! When we do this with other code generators (ASPmaker and Codecharge Studio) they work fine. It's a very simple site that we are testing. Two tables - no links or relationships. These are flat files. One has 30 records, the other one (Members table) has one - that would be my record. The only thing that messes up is the Registration page. I can log in, but can't register anyone else. I can add users to the Members table and then they can log in! So it's not something that I am doing wrong. There is something in the code that is generated. BTW: when I uploaded my test app today, your site says I'm using mysql - not - it's MS SQL.


G	goomba author 3/11/2008
	I guess you doing something wrong. Why I have two posts here, I don't know. Could be I hit a shotcut key in firefox. Sorry about that The only way to find what exactly is wrong is to post your application to Demo Account and to send the URL to support@xlinesoft.com. Already did that!!! I had two of my developers try their own tests today (different SQL Databases)and they have the same problems - always with the registration page! When we do this with other code generators (ASPmaker and Codecharge Studio) they work fine. It's a very simple site that we are testing. Two tables - no links or relationships. These are flat files. One has 30 records, the other one (Members table) has one - that would be my record. The only thing that messes up is the Registration page. I can log in, but can't register anyone else. I can add users to the Members table and then they can log in! So it's not something that I am doing wrong. There is something in the code that is generated. BTW: when I uploaded my test app today, your site says I'm using mysql - not - it's MS SQL.


	Sergey Kornilov admin 3/11/2008
	You never sent the URL. Where I can see this?


S	semleon 3/11/2008
	FYI.. I had this problem. Dont know how I finaly figured it out but my issues was fixed when I went back and change the primary key on one of my tables to a field that wasn't being used to define my edit rights. bottom line, check your primary keys and see if you change them to something else if it fixes it.


G	goomba author 3/11/2008
	FYI.. I had this problem. Dont know how I finaly figured it out but my issues was fixed when I went back and change the primary key on one of my tables to a field that wasn't being used to define my edit rights. bottom line, check your primary keys and see if you change them to something else if it fixes it. Thanks semleon. I've tried everything I can think of. Here is the structure of my table (abridged, C=column,P=PK, I=IDX). It's actually pretty flat and it is the ONLY table I am experimenting with in runner: C1: RecNo(int), P. I do not use RECNO to link anything, it is there to satisfy runner, C2: Cat_ID(nvarchar:20), I C3 to C10 miscellaneous column data. When I View, Edit add etc, I DO NOT include RECNO as anything other than referrence because runner wants a PK. I've actually dropped the table in MS SQL, recreated it, re-loaded RAW data and set a new PK and IDX. I've even created an MS Access (yuk) DB and the same results occur. I then downloaded the eval version again and tried, thinking I might have gotten a bad load/install. Same result. Again, not trying to be a jerk, but ASPmaker and Codecharge studio work fine. I want to move to ASPrunner because it's easier and leaner than the other two (not withstanding some of the easier features). I resisted posting again last night because I thought that I was missing something and I really want to figure this out. I worked on this for a long time and still get the same error. I also get (periodically) another error that says, "Multi-step OLE DB operation generated errors...". I'm just having problems with this and I've looked at virtually every and any posting that remotely resembles this. Tried all kinds of things. No go. Anything else would be greatly appreciated.


	Sergey Kornilov admin 3/11/2008
	Goomba, how do you expect me to help you?


G	goomba author 3/11/2008
	Sergey, this is a client DB system that we are working on. I met with the client today and as this is on a secure IntraNet, they don't want to expose it to the outside universe. So, I'm going to have one of my developers convert this (port it I guess) to access then resubmit the entire app OR in the alerntative, place it onto one of our servers and let you know the URL if that's the way she wants to go. I'm flying out of town on business later this evening, but I've given her all the information to post as well as my account info for this forum. She will get it up there tomorrow sometime.

8 replies

Mark as Solved Reply