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


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

Re: Mem2String

From James Martin <james@northwoodlumber.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Mem2String
Date 2018-10-11 15:21 -0400
Organization A noiseless patient Spider
Message-ID <ppo7so$toq$1@dont-email.me> (permalink)
References (3 earlier) <pp8meh$4gd$1@news.albasani.net> <ppa8n6$o7t$1@dont-email.me> <ppadp4$pdm$1@dont-email.me> <ppaogl$rc7$1@dont-email.me> <ppigrm$1g38$1@gioia.aioe.org>

Show all headers | View raw


This ODBC driver works in the accounting program, and the memo field is 
not last. I was busy the last day or two, but I am searching where I can 
see the actual raw record and then I may be able to bypass the memo 
field characters. Otherwise I will need to modify the SQL statement to 
not ask for them. Does anyone know where I can have access to the raw 
ODBC record before parsing?

James

On 10/09/2018 11:18 AM, Arne Ortlinghaus wrote:
> I think that it is not the Mem2String. It can be also something 
> different: Some ODBC drivers allow data reading correctly on a record 
> only once and some ODBC drivers need the memo fields only as the last 
> fields before all other.
> 
> Arne Ortlinghaus
> 
> 
> James Martin wrote:
>> I've done it with a second file and it works with the memo fields 
>> removed. So I need to verify that Windows indeed gives the whole 
>> record to VO. To do that...
>>
>> James
>>
>> On 10/06/2018 09:36 AM, James Martin wrote:
>>> 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