ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Bad field type in WORKORD
http://www.istechforum.com/YaBB.pl?num=1279122858

Message started by BLEWIS on 07/14/10 at 08:54:18

Title: Bad field type in WORKORD
Post by BLEWIS on 07/14/10 at 08:54:18

We are using a version of EVO that is at least 3 versions old so this may or may not be a legitimate questions.

While writing a Crystal report to explore what exactly is where in the WORKORD table, I got a Bad filed type on the MTWO.WIP.ASTART field that had to close Crystal had to close itself to recover from.

I saw this another table that I did not note.

I was wondering if anyone else had seen this or had any information on this field as I will want to use it eventually.

Thanks all!

Title: Re: Bad field type in WORKORD
Post by Kelloggs on 07/14/10 at 13:39:15

The actual name of the field is: MTWO_WIP_ASTART
It stores the day that the work has actually started.

:-?

Kelloggs

Title: Re: Bad field type in WORKORD
Post by BLEWIS on 07/15/10 at 10:00:03

I thought that was what the data was supposed to be but I can't access if from Crystal.

Bizarre.

Are you able to use this field in a Crystal report?

:)

Title: Re: Bad field type in WORKORD
Post by GasGiant on 07/15/10 at 12:30:35

Did you create the ODBC DDFs from inside Evo for that company or are you trying to use the Pervasice DDFs?