2. ASPRunnerPro General questions
  3. [SOLVED]  Adding New Records with Dummy Field
This topic is locked
[SOLVED]

 Adding New Records with Dummy Field

 		1/10/2012 3:10:55 AM
ASPRunnerPro General questions
ZeinzuKun author

Hi again,
I got an error while adding a new record that uses a Dummy Field.
Unknown column 't_wod_001.Dummy2' in 'field list'
Here's what I did:
First, I declared the Dummy Field in the 'Query Tab.' (e.g. Select 0 as Dummy, col1, col2 from table1)
When using the 'Lookup Wizard' in the 'Editor Tab,' there is a 'AutoFill' function that automatically fills a field depending on the selected item.
I created a Dummy Field to temporarily store information given by the 'Autofill.'
But when I pressed 'save,' the error above appears.
Is there a way to produce a Dummy Field without getting the error above? Are there any alternatives?
I hope someone can help me. Thanks.
ZeinzuKun author 1/10/2012

I would like to add.
The purpose of the Dummy Field is reference/display only.
For example, the field requires me to enter the quantity of the item. The Dummy Field will display the Remaining Quantity for that item.
This is very helpful to lessen the mistakes of the end-user. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=63539&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 1/10/2012

Make sure you removed Dummy field from the Add page. This can be done on 'Fields' screen in ASPRunnerPro.
ZeinzuKun author 1/10/2012



Make sure you removed Dummy field from the Add page. This can be done on 'Fields' screen in ASPRunnerPro.


Hi,
So, Dummy can't be used in the 'Add Page.'
Is there a way to temporarily hold the data coming from the 'Auto Fill?'
The said data is needed for the end-user's reference and at the same time, needed for the calculation.
Are there any alternatives?
Sergey Kornilov admin 1/10/2012

Another approach is to use the following code in BeforeAdd event:

values.Remove("Dummy")


More info:

http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm
ZeinzuKun author 1/10/2012



Another approach is to use the following code in BeforeAdd event:

values.Remove("Dummy")


More info:

http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm


Hi,
It works! That's what I'm looking for!

Thanks!