|
| | | 
Forum Guru
 
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| We have just converted over to Point 6.0b, and all my reports that used the SQL field MACRO_f30000 have suddenly stopped working. Under investigation, it appears that this field no longer exists. Since this macro identified the file Status, I assume it is linked to the changes in Reports section within Point. Is there an alternate field that has the file status?
Thanks for your help, 
John Hoopes 
|
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204 |
| Point 6.0b should not have mad any changes to PDS 6.0.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| | Well, All my reports that use MACRO_f30000 have stopped working and all the Crystal reports that don't use that field still run. I tried to re-link the table macro, but cannot find a link path in which it will work. Would you have a link view of the table indexes that I could use? I would appreciate any help.
Thanks for your help,
John Hoopes |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204 |
| Try IX_Macro_f30000
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| I cannot find a table IX_Macro. If there is a field that carries the current status, that would work.
Thanks for your help,
John Hoopes |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204 |
| f30000 should be the right field It looked like you were referencing an old index name. It might be that name change that's confusing crystal.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| | I am sorry, what name change? Has the table name changed from MACRO? MACRO still appears on the SQL link, but there is no data in MACRO_f30000. Well there is data, but it stops on the date of the upgrade to 6.0b Any changes to status after the upgrade date are NOT shown. So the list is dwindling down. Is there another field that contains current status?
Thanks for your help,
John Hoopes |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 2:47:53 PM
Posts: 1,178, Visits: 9,204 |
| | that is odd. do you see any errors in your event log? you can try adding 6060 to your additional fields. it should have the current status.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| | Okay, This issue has just taken a big jump up the scale of serious issues. On internal Point reports and custom forms, the field short cut "PTYPE" is filling incorrect data. This field is from the 1008 and is NOT reliable. The impacts of this field not being correct are important, as we can no longer produce HMDA and Compliance reports based on Property Type. Our Locks with Investors are WRONG because the property type is wrong. I tried to find the field number for Property Type but FieldID.xls does not provide a direct ccorrelation to a Point field for this shortcut.
Thanks for your help,
John Hoopes |
| |
| | | |
|