Page 1 of 1

The word Dummy not Field names

Posted: Mon Oct 01, 2007 8:45 pm
by Shaughn_(Guest)
Hi, In version 12.1.001, I had a very strange error show up, when I use a DBC in Foxpro V9 I get the word DUMMY for each field name my master data file, nothing I did would correct it. I had to open the file as a DBF. not in the DBC.____Any ideas why all the fields would say ^DUMMY^,______Thanks.____Shaughn__

=> RE: The word Dummy not Field names

Posted: Tue Oct 02, 2007 11:08 am
by kfleming
SQL or Xbase and does this happen when you open an existing report?____Kathleen__R&R Support

==> RE: The word Dummy not Field names

Posted: Sun Oct 07, 2007 4:03 pm
by Shaughn_(Guest)
Hello Kathleen____Xbase reports, they are sometimes existing, other times brand new. Only happens when I use a file in an DBC. I have not had this problem for quite a while but it seems to be showing up more often.____Could it be with field names longer than 10 char.____Thanks for the help.____Shaughn

===> RE: The word Dummy not Field names

Posted: Thu Oct 11, 2007 2:16 pm
by kfleming
There is some code that would use the word dummy when a field name cannot be evaluated but I do not know why it would occur in the circumstances you have described.____To have development evaluate this, I need to have a reproducible way to see the error so that they indeed have something tangible to fix.____If you can send me a container/table/report that shows the problem that would be great. Otherwise we are just left with a bit of a mystery.____Kathleen__R&R Support

====> RE: The word Dummy not Field names

Posted: Mon Nov 19, 2007 8:00 pm
by Shaughn_(Guest)
Kathleen,____My customer just called and stated that a report that they run everyday just did it. When I went to check on the report, it too said DUMMY in the one table when you list the fields.____This is a big report and has about 5 relations, how should I try to get this to you.____Sg

=====> RE: The word Dummy not Field names

Posted: Tue Nov 20, 2007 11:03 am
by kfleming
Just email the report file to livesupport@livewarepub.com ____Kathleen__R&R Support

======> RE: The word Dummy not Field names

Posted: Tue Nov 27, 2007 7:54 pm
by Shaughn_(Guest)
Kathleen,____Thank you for your help and attention, I did a little bit of trouble shooting and found something very interesting. Prior to the error, I added a field to an existing table, and added a new table in my database container ( Visual FoxPro V9.0) Now the table that I added the field to did not have anything to do with the report and the new table has nothing to do with the report. But, since that update to the DBC some of my reports are showing that certain fields are no longer in certain tables. I put the old data and database container back and all the reports run fine. Any Ideas? Also I will send you the report and I will send you two screen shots of what I am showing. If you need the database container and the required tables let me know and I will get them to you also.____Thanks for all of your help.____Shaughn__

=======> RE: The word Dummy not Field names

Posted: Thu Dec 13, 2007 5:21 pm
by kfleming
Looks like the database was corrupted so that the dbc index number pointed to more than one table so R&R was confused.____Re-building the DBC structure was indeed the correct fix since the problem was indeed on the database side and not really R&R.____Kathleen__R&R Support