Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #12033

Re: Mem2String

From JohnMartens <martens@tennishulp.info>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Mem2String
Date 2018-10-05 22:37 +0200
Organization A noiseless patient Spider
Message-ID <pp8i2q$2ju$1@dont-email.me> (permalink)
References <pp6078$m99$1@dont-email.me> <0535ea6d-b916-49ca-a424-c004ec55059d@googlegroups.com> <pp7ked$r64$1@dont-email.me> <pp87uu$v4d$1@dont-email.me> <pp8f67$h3v$1@dont-email.me>

Show all headers | View raw


So calc won't open your file because it is to big ?


Op 5-10-2018 om 21:48 schreef James Martin:
> I don't have Excel but Libre Office opens the smaller files. Has there 
> ever been a Visual Fox Pro RDD for VO?
> 
> James
> 
> On 10/05/2018 01:45 PM, JohnMartens wrote:
>> I think Mathias question is: Can you open the file in Excel ?
>> If so you can let Excel save the file as a format that you can read in 
>> your App
>>
>>
>>
>> Op 5-10-2018 om 14:11 schreef James Martin:
>>> No. I would like to generate reports regularly. Anyhow, if I can't 
>>> open it I can't convert it to Excel.
>>>
>>> I have a hunch that the routine that reads in the whole record chokes 
>>> at the ascii 198. The data comes in properly until the memo field; 
>>> the fields after that are blank.
>>>
>>> James
>>>
>>> On 10/05/2018 02:43 AM, Mathias wrote:
>>>> Is it a one time conversion? Try Excel.
>>>>
>>>> /Mathias
>>>>
>>>> Den torsdag 4 oktober 2018 kl. 23:20:41 UTC+2 skrev James Martin:
>>>>> I am reading an unusual DBF via ODBC and the standard 
>>>>> SQLSelect:GetData
>>>>> uses Mem2String(pTemp,UILen) to pass the buffer to a string. The first
>>>>> character of a memo field is ASCII 198 and this causes the routine to
>>>>> choke - at least I think so. The data is actually a reference to a 
>>>>> memo
>>>>> field and is 4 characters long. I don't need the memo field 
>>>>> information,
>>>>> but I do need all the other fields.
>>>>>
>>>>> What happens is that SQLSelect:GetData reads up to the memo field and
>>>>> then none of the rest of the record is read. The next record is 
>>>>> read up
>>>>> to the memo field again, and so on.
>>>>>
>>>>> I have tried to change the fieldspec for the field to Character(4) but
>>>>> that does not work. I am fwriting information to a file and the
>>>>> nODBCType is -1.
>>>>>
>>>>> Any ideas of what I could do?
>>>>>
>>>>> James
>>>>

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Mem2String James Martin <james@northwoodlumber.com> - 2018-10-04 17:20 -0400
  Re: Mem2String Mathias <mathias.hakansson@consultec.se> - 2018-10-04 23:43 -0700
    Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-05 08:11 -0400
      Re: Mem2String JohnMartens <martens@tennishulp.info> - 2018-10-05 19:45 +0200
        Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-05 15:48 -0400
          Re: Mem2String JohnMartens <martens@tennishulp.info> - 2018-10-05 22:37 +0200
            Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-05 16:56 -0400
    Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-05 08:39 -0400
  Re: Mem2String "Jamal" <noooospam@example.com> - 2018-10-05 15:41 -0400
    Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-05 17:04 -0400
      Re: Mem2String "Jamal" <noooospam@example.com> - 2018-10-05 17:52 -0400
        Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-06 08:10 -0400
          Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-06 09:36 -0400
            Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-06 12:39 -0400
              Re: Mem2String Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> - 2018-10-09 17:18 +0200
                Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-10-11 15:21 -0400
                Re: Mem2String D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2018-11-05 18:47 +0100
                Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-11-05 13:00 -0500
                Re: Mem2String D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2018-11-05 20:24 +0100
  Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-11-06 10:50 -0500
  Re: Mem2String James Martin <james@northwoodlumber.com> - 2018-11-06 10:56 -0500

csiph-web