Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12106
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Mem2String |
| Date | 2018-11-06 10:50 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <prsd8o$63l$1@dont-email.me> (permalink) |
| References | <pp6078$m99$1@dont-email.me> <prqh9h$9kr$1@dont-email.me> |
I had to do some work to read numbers. I think they were base 16 numbers and I had to make a custom SQLSelect:GetData() to read the numbers. To work with the databases I used a custom select statement that excluded the memo fields. To fix this right one would have to have the driver for the database which is accessed via ODBC and somehow interface with it. 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 | 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