New value in lookup wizard goes blank

An extra bit about this Add on the fly feature.
Found that there is no way to control max length of the input box, but input value will be AUTOMATICALLY truncated to fit on save.
Say, the field is in freehand text with database column definition: varchar(10)... if 11 characters are typed, only the first 10 will be saved.
Is this normal behaviour, or a bug?

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28918&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' /> I'm having the same problem with trying to get the newly added item to appear in the list instead of as a blank line. I'm trying to find a solution to this but haven't yet. If you find something, please let me know.
Thanks!

J.K, Nitescan
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing "Add on the fly" error.

I'll find what's wrong with your projects inspecting it at Demo account site.
Regarding the field length.

It's usual behaviour to truncate entered values to fit on save.

To restrict length of entered values change Max length on the "Edit as" settings dialog on the Visual Editor tab.

Jane,

Quick question before I go through the trouble of posting to the Demo Account and emailing details: In any project using MSSQL, when you have a field that is a drop down list based on another table and then "Add on the fly" a new record to that table, hit save, then click the drop down list, is that new item showing in your list?
JK,

Are you using MSSQL or another database?
Thanks,

Nitescan

Jane,
Thanks for the reply. I have already posted the project to Demo Account and sent an e-mail to support for further investigation.
About the max. length control, yes, it is natural to truncate it. The point is that the process is so automatic that front-end user will not notice as there is no message/alert. I assume there would be one as similar handling is found in mandatory fields.

Anyway, it is easy to set up the restriction, but more convenient if it is already there. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28969&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
Nitescan,
I'm using MSSQL also. There is no problem with the database in my case. It is just the parent page (add page) does not successfully (if there's an attempt) get the new content from the data source.

The new item is immediately inserted into the database right after the click of the Save button.
You may try to verify that in any SQL painter to isolate the problem, if you doubt it's database problem.

Nitescan,
it's hard to tell what's wrong.

Publish your project on the Demo Account and send link to your pages to support@xlinesoft.com.

The new item is immediately inserted into the database right after the click of the Save button.

Same thing happens to mine. It adds it fine, it just won't refresh the list after the add unless I refresh the page. It shows as a blank line at the bottom of the list. I'll work on getting mine posted to the demo acct so Jane can see.
Thanks.

Nitescan,

Jane,
I've now posted to the demo account and send the email to support.
-Nitescan

All,
I received the following from tech support:
"I found that there was a bug in ASPRunnerPro. Table name is spelled as dbo.tblShirts in one place and tblShirts in another place. To the best of my knowledge this was fixed in build 423. Please give it a try and let me know. Feel free to contact me if you need any help.

-Sergey Kornilov"
I'm currently on build 422 (shows in program title bar...took me a sec to find) so I'll try upgrading and post whether or not that worked.
-Nitescan

I downloaded the latest build (423) and installed and the problem still exists. I've emailed support again and am awaiting a response.
-Nitescan

I too got a reply from support. He recommended to check off a key field for the lookup table, in Choose Pages tab.
It was done... but nothing happens. Already got this with the support guy to see what advice he would give. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29040&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

the same problem when i add a new value (goes blank after saving, the value is inserted to the database and appear like an empty field in the list). plz jane post the solution and thanks.

I hope this isn't piling on, but I too am having this issue: add new on the fly - added record not showing in list until the page is refreshed. Any help is appreciated.
Thanks,

Tim

Tim, Elie
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

Hi All,
Tech Support wrote me back again after the last suggestion didn't work saying that the fix should be released in the next build. Then they sent me a zip file containing a fix to use for now for the add.asp file in C:\Program Files\ASPRunnerPro5.2\source however that didn't correct the problem either. I've advised tech support again and will post any responses.
-Nitescan

Then they sent me a zip file containing a fix to use for now for the add.asp file in C:\Program Files\ASPRunnerPro5.2\source however that didn't correct the problem either.

Correction:

This file does correct the problem, but only if you start a new project. If you just go in and rebuild a current project, the same problem occurs.
-Nitescan

Jane,

Talk to Alexey on this issue. A problem may exist with add.asp page.

Rds,

Emilio

Hi all,
I too got a reply from the support, stating there was a bug in add.asp. And the problem was linked with MSSQL.

After replacing the add.asp, it worked perfectly for my project.
Below are the steps ran through:

1. Replace add.asp
   
2. Start ASPRunnerPro
   
3. Open the project working
   
4. Hit Next to pass through ALL pages... NO skipping
   
5. Build the project in the last step
   
6. Open browser to check results
   

I am still having this problem and would like to get it resolved. I am using 5.2 build 423. Do I need to get a copy of a new add.asp file to fix this? If so, how can I get that?
Thanks,

Tim

Please contact [email=support@xlinesoft.com]support@xlinesoft.com[/email] directly.