2. ASPRunnerPro General questions
  3. Two columns in title causing a problem
This topic is locked

Two columns in title causing a problem

 		3/28/2006 12:01:08 PM
ASPRunnerPro General questions
garydee author

Hi Sergey - silly little query here but its causing a problem for me.
In my edit record page there are numerous columns from the db including the ID (autoid) and RefCode (just text field).
Now I can edit all other columns without prob and obviously the ID field is a readonly one.
But if I edit the RefCode field it causes the error:
Error Type:

ADODB.Field (0x800A0BCD)

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/jc3_mar2006/admin2_2006/include/Products_aspfunctions.asp, line 204
Now I noticed the title at the top of my Edit page reads:
Products, Edit record [AutoID: 1, Refcode: GER221A]
So it seems to be cataloging the records using both fields - and so when i change one then it upsets the SQL.
Why is this Sergey - is it a setting in the ASPRunner - or a setting in my database?
Any help is VERY much appreciated!!!!
Top Quality product once again mate!!!
GaryDee
Sergey Kornilov admin 3/29/2006

Gary,
I need to see Products_aspfunctions.asp file, line 204.

You can post it here or send to [email=support@xlinesoft.com]support@xlinesoft.com[/email].
garydee author 3/29/2006

Hi Sergey - I zipped and sent the full page to make sure you see the correct part.
Thanks in advance!
Gareth
Sergey Kornilov admin 3/29/2006

Gareth,
you can not modify key fields in ASPRunnerPro.

Since your AutoID field is autoincrement field, you don't need Refcode field to be the key.
Proceed to Choose pages tab in ASPRunner, click Edit and uncheck Refcode field.

Then rebuild your project.
garydee author 3/29/2006

Brilliant Sergey - just seen that in my project build - I'll try that now - should work
Fantastic - thanks!!!
Gareth