Table Names & Field Names

This public forum is for user-to-user discussions of ASPMaker. Note that this is not support forum.

Table Names & Field Names

Postby jcrowe » Thu Oct 19, 2017 3:30 am

During my project upgrade from ASPMaker 2017 to ASPMaker 2018 I have encountered the following issue:

Using the same Access Database and importing the ASPMaker 2017 *.agp file into ASPMaker 2018

Table Name: Category
-------------------------------------
Contains Fields:
ID (integer)
Image (string)
Category (string)

Table Name: Show
-----------------------------------
Contains Fields:
ID (integer)
Show (string)

When the scripts for these pages (list, edit, add, delete, copy) are generated they fail when called returning the error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'category'
/admin/categorylist.asp, line 407

Code from Line 407 Section
-----------------------------------------------
' Field (Category)
Public Property Get Category
Set Category = category.Category
End Property
--------------------------------------------
Microsoft VBScript runtime error '800a01a8'
Object required: 'category'
/admin/categoryedit.asp, line 198

Code from Line 198 Section
-------------------------------------------
' Field (Category)
Public Property Get Category
Set Category = category.Category
End Property
----------------------------------------

Has something changed in ASPMaker 2018 that does not allow Tables to posses Fields with the same names? I ask because this setup works in ASPMaker 2017

Thank you,
JCrowe
jcrowe
 
Posts: 16
Joined: Wed Apr 03, 2013 10:55 am

Re: Table Names & Field Names

Postby Webmaster » Thu Oct 19, 2017 11:04 am

Thank you for reporting. We will fix in the next build.

In the mean time, please avoid using field with the same name as the table.
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (ASPMaker)