Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12040
| From | Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Mem2String |
| Date | 2018-10-09 17:18 +0200 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <ppigrm$1g38$1@gioia.aioe.org> (permalink) |
| References | (2 earlier) <pp8jk7$d4g$1@dont-email.me> <pp8meh$4gd$1@news.albasani.net> <ppa8n6$o7t$1@dont-email.me> <ppadp4$pdm$1@dont-email.me> <ppaogl$rc7$1@dont-email.me> |
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
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