Re: VFP 6.0 & Crystal Reports 8.5 Numeric field problem

Are you accessing the free table via ODBC? Are you using the Microsoft VFP
ODBC driver or a third party one. What happens if you use OLE DB?

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net


"mks" <muthuksamy@xxxxxxxxx> wrote in message
news:1136183078.401273.269990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I am using crystal reports 8.5 with VFP 6.0. Using ODBC to connect the
> .DBC with CR.
>
> I get a strange problem. All the numeric fields appear wrong in the
> report. For example, if the value in the table is 10,000 then it is
> displayed as 100 in CR. However, if I try a free table, the value is
> correct.
>
> Can anyone help me?
>
> Thanks in advance
>
> MKS
>


.

Relevant Pages

  • Re: Reading BLOB
    ... > How can I read a binary value from a blob via ODBC (Microsoft VFP ... Maybe posting a very small snippet of code which reproduces the ...
    (comp.lang.python)
  • Reading BLOB
    ... How can I read a binary value from a blob via ODBC (Microsoft VFP ... TIA ...
    (comp.lang.python)
  • Re: DDE Access to Word using mde
    ... OLE DB is the method that Word 2002/2003 use by default - in fact, given the code you are using, I am pretty sure that when your Access code opens the word document in Word 2002/2003, Word will be using OLE DB rather than DDE to open the data source. ... So either the OLE DB connection is handling your dates and memos just fine, or I'm wrong and DDE is being used. ... ODBC should get your dates OK, but you would need to use switches in the Word fields to format them correctly. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Problem importing recipients from nominated Excel worksheet
    ... you should be seeing the OLE DB dialog box. ... to an Excel data source, it tries OLE DB first, but if it cannot open ... the Excel workbook using OLE DB, it tries ODBC, which is an older ... that there could be something wrong with your workbook, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Samplclnt example in MDAC 2.8: My Story
    ... I was incorrect when I stated that ODBC as a whole is deprecated. ... ODBC provider for OLE DB is deprecated; ... > | compiler errors. ...
    (microsoft.public.data.oledb)