loliman
Offline
Last seen: 10 years 6 months ago
Joined: 09/16/2013 - 10:48
Hi Brian,
still no luck, I think I have to dig further, I'll diable every functionality not necessary and afterwards enable them step by step to localize the error. I'll tell you in the evening if I found something.
One small offtopic quastion: Is there a way to suppress popups in IDEA? I'm thinking about three different popups
1. Unable to apply the selected view. The following fields were: -not found in the database; or - have lengths and/or parameters, that do not match the field in the database (Appears when I try to apply a view to a database, that do not fit)
2. Not all columns will fit on the report. Try to reduce the font size to fit? (Appears when I try to print a database, that does not fit on one page)
3. Unable to reduce the report to fit on the page (Appears after 2.)
I thought, Client.DisplayAlerts =False or Client.SetWarnings = False could work (due to the fact, that IDEAScript is a child of VB) but it doesn't. Any suggestions?
Thanks in advance and have a nice day!
loliman
Not that I know of. As far as I know the DisplayAlerts functionality does not work in IDEAScript. I am not sure if the DisplayAlerts is part of VB or part of VBA. IDEAScript does not implement everything that is available in VB unfortunately.
For the views you could have an array of all the fields names in the view and check to make sure that the file contains those fields before using it, I admit this is like using a sledgehammer to fix a small problem but it is one way to get around it.
For part 2 and 3 maybe figure out the maximum and then add of the lengths of each of the fields to see if it will fit, if the total is greater than the max then don't output the print report.
Sounds like you are doing the correct things of trying to isolate where the error is happening. Good luck on that.
Thanks! One strange thing about the "Apply-View-Problem" is, that the the columns are (definitly! There is no case where it is different) the named the same. So the problem seems to be related to charecters. But what does CITY - [Character 33] mean? How can I fix the problem regarding the characters?
I beleive that is the width of the field. So it would mean that the CITY field is 33 characters wide. Is there actually a problem with the city field? Did you try to resave the view and see if that helps out.
Pages