This topic is locked

Formatting not generated correctly

10/12/2004 2:25:17 PM
ASPRunnerPro General questions
author

On the Formatting page I have the 2 key fields of my table checked for Add and unchecked for Edit. However when I view the resulting web pages nad click on the Add New link I get a page without the 2 key fields.
How can I troubleshoot this so that I get the fields only on the Add screen but not on the Edit screen?
Thanks!

Sergey Kornilov admin 10/13/2004

Dan,
one of possible reasons that those fields are not updatable ie Autonumber field.
You can zip and send me your sample database along with the project file to support@xlinesoft.com for investigation.

501095 10/14/2004

My database is MS SQL Server so it would be difficult to zip a copy to you, however here is the script for the table in question.
CREATE TABLE [dbo].[vend_tbTransmittal] (

[contract_id] [varchar] (20) COLLATE Latin1_General_BIN NOT NULL ,

[submittal_id] [varchar] (30) COLLATE Latin1_General_BIN NOT NULL ,

[transmittal_id] [varchar] (30) COLLATE Latin1_General_BIN NULL ,

[printed] [varchar] (3) COLLATE Latin1_General_BIN NULL ,

[information_only] [varchar] (3) COLLATE Latin1_General_BIN NULL ,

[remarks] [varchar] (300) COLLATE Latin1_General_BIN NULL ,

[date_printed] [datetime] NULL ,

[change_user] [varchar] (21) COLLATE Latin1_General_BIN NULL ,

[change_date] [datetime] NULL

) ON [PRIMARY]

GO
I have not created any indexes or references to other tables yet. The contract_id is the key to my contract table which can have multiple submittals. submittal_id is the key to the submittal table and transmittal_id is the final part of the key.
A transmittal is basically a response to a vendor submittal and there can be multiple transmittals per submittal.
The information_only field is another place I'm having trouble. It should be a Yes/No value. I wanted to have a list of values using the lookup wizard where if the user selects "Information Only" the value would be "Yes" and if he selects "Approval" the value would be "No".
As far as the problem with the keys, I have actually found a work around by editting the _variables.asp file and inserting an IF...Then that checks for "add" or "added" and changes the flags so that the fields are edittable. This seems to work but I don't understand why ASPRunner doesn't do this as part of the build process.
If I need to rebuild the project my changes will be lost and I will need to keep updating the variables file manually.

Sergey Kornilov admin 10/19/2004

Dan,
I still cannot do anything without having your project file.

501096 10/20/2004

I've sent the project bfile to your email address.