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


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

Re: Mem2String

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Mem2String
Date 2018-11-06 10:56 -0500
Organization A noiseless patient Spider
Message-ID <prsdiq$85l$1@dont-email.me> (permalink)
References <pp6078$m99$1@dont-email.me> <prqh9h$9kr$1@dont-email.me>

Show all headers | View raw


Incidentally the company who made this is Sequiter, from Alberta Canada, 
and calls it CodeBase. It is always server-client, and is extremely 
robust and fast. I suppose that is why the accounting software company 
is so loath to change to something slower and more problematic like SQL 
server.

In two years the customer has been using the software they never had any 
data corruption, and it seems to do everything almost instantly, except 
Crystal Reports takes its jolly old time sometimes.

James

On 11/5/18 5:47 PM, Johan Nel wrote:
> Hi James,
> 
> Sorry for jumping in so late, if I remember correctly, I don't think it 
> is the ODBC driver, it is something in the SqlSelect class.  Had the 
> same issue with trying to retrieve text/memo from MS-Access.
> 
> 
> On 2018/10/04 23:20, James Martin wrote:
>> 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
>>
> 
> -- 
> *Johan Nel*
> George, South Africa

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous 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