Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12029
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Mem2String |
| Date | 2018-10-05 08:39 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <pp7m30$6t4$1@dont-email.me> (permalink) |
| References | <pp6078$m99$1@dont-email.me> <0535ea6d-b916-49ca-a424-c004ec55059d@googlegroups.com> |
I can open the DBF with a program called "DBF Manager" and it opens it as a Visual Foxpro file. Will this help? That program does not export the DBF as a VO compatible Foxpro file. It does not allow it to be exported in any other DBF format. DBAdmin does not open the DBF. DBV Smart DataViewer opens the DBF but does not fill in the memo fields. This would work for me at this time. I would have to copy the required DBF out of the working directory so as not to conflict with the operation of the program. Since I just wan t to make reports for now this would work. How does DBV open this database since it is written in VO? But what I really want to do eventually is to open it via the ODBC driver so my program works along with the other program through the server client architecture. James On 10/05/2018 02:43 AM, Mathias wrote: > Is it a one time conversion? Try Excel. > > /Mathias > > Den torsdag 4 oktober 2018 kl. 23:20:41 UTC+2 skrev James Martin: >> 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