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


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

Re: Mem2String

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Mem2String
Date 2018-10-06 09:36 -0400
Organization A noiseless patient Spider
Message-ID <ppadp4$pdm$1@dont-email.me> (permalink)
References <pp6078$m99$1@dont-email.me> <pp8ep5$i9m$1@news.albasani.net> <pp8jk7$d4g$1@dont-email.me> <pp8meh$4gd$1@news.albasani.net> <ppa8n6$o7t$1@dont-email.me>

Show all headers | View raw


I've feel I've proven that it is the memo fields that cause the problem. 
When I copied the file to another directory, removed the memo fields, 
renamed the file and put it back to the original directory directory, it 
worked fine. I'll do that to another table just to be sure.

The next step will be to modify the sql program to ignore the memo 
fields and replace them with asterisks and label them character. This 
would work for me at this point. I think it will have to be done deeper 
in sqlselect than getdata.

James

On 10/06/2018 08:10 AM, James Martin wrote:
> The driver is OK. It is used by Crystal reports and it works without a 
> hitch there. It is a special driver for use by a server/client 
> architecture called codebase from Alberta Canada. The company no longer 
> supports the product, which is unfortunate since it works extremely fast 
> and we have no problems in the accounting program that uses it.
> 
> I expect that I will have to do some work to make it work, I already 
> have to modify the numeric section of GetData to handle numerics which 
> come across in base 16 instead of base 10.
> 
> James
> 
> On 10/05/2018 05:52 PM, Jamal wrote:
>> May be the problem then in the ODBC driver. Which driver are you using?
>>
>> Would this help https://www.devart.com/odbc/xbase They have a trial.
>>
>> Jamal
>>
>> "James Martin"  wrote in message news:pp8jk7$d4g$1@dont-email.me...
>> I don't have a handle fo how it all works, but GetData does not seem 
>> to be the problem. It seems the data did not all get read it. Get data 
>> works for a few fields beyond the memo field, but theye are empty.
>>
>> I would like to see the data Windows gets from the ODBC driver.
>>
>> James
>>
>> On 10/05/2018 03:41 PM, Jamal wrote:
>>> May be you can override the GetData() method and skip reading the 
>>> field when you encounter the 198 ASCII value.
>>>
>>> Jamal
>>>
>>> "James Martin"  wrote in message news:pp6078$m99$1@dont-email.me...
>>>
>>> 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