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


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

Re: Mem2String

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Mem2String
Date 2018-10-05 08:39 -0400
Organization A noiseless patient Spider
Message-ID <pp7m30$6t4$1@dont-email.me> (permalink)
References <pp6078$m99$1@dont-email.me> <0535ea6d-b916-49ca-a424-c004ec55059d@googlegroups.com>

Show all headers | View raw


I can open the DBF with a program called "DBF Manager" and it opens it 
as a Visual Foxpro file. Will this help?

That program does not export the DBF as a VO compatible Foxpro file. It 
does not allow it to be exported in any other DBF format. DBAdmin does 
not open the DBF.

DBV Smart DataViewer opens the DBF but does not fill in the memo fields. 
This would work for me at this time. I would have to copy the required 
DBF out of the working directory so as not to conflict with the 
operation of the program. Since I just wan t to make reports for now 
this would work. How does DBV open this database since it is written in VO?

But what I really want to do eventually is to open it via the ODBC 
driver so my program works along with the other program through the 
server client architecture.

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