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


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

Re: SQL long field names

Path csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: SQL long field names
Date Sun, 4 Jul 2021 15:30:01 +0200
Lines 27
Message-ID <ikdreqFu46iU1@mid.individual.net> (permalink)
References <b2294a19-f5b8-44e8-b474-416249d349c7n@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=utf-8
X-Trace individual.net WIAk/SPxjcd89w3IcWUWfwsoXts7uFZxvHBHkikkzLQOsV3ys=
Cancel-Lock sha1:sncLGrR/S0NPJ4zAA7vLpVxdgjk=
User-Agent XanaNews/1.18.1.6
Xref csiph.com comp.lang.clipper.visual-objects:13369

Show key headers only | View raw


Hi Henry,

> I try to connect, via SQL objects, to an external internet host
> MySQL, and build from it local dbf files.  The external MySQL has
> file names longer then 10, so DbCreate() truncate them.  Any idea how
> to solve the problem?

if you are using your own dbServer subclass you could maintain an
internal array of mapped fieldnames.

I would use the first 8 characters of every fieldname and than add a 2
characters numeric suffix, and store that in some external
configuration file.
Then, when opening the DBF, read the aliases from your configuration
file and map that in a subclassed
FieldGet()/FieldPut()/IVarGet()/IVarPut() method.

But there is also something like this already built in: please look at
the DBFieldInfo() function or the DBServer:FieldInfo() method, using
the constant DBS_ALIAS should do what you need (I have not tested that,
so you have to try it yourself).

Wolfgang


-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

SQL long field names Henry Fidler <zodcomag@gmail.com> - 2021-07-04 02:39 -0700
  Re: SQL long field names "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-04 15:30 +0200
    Re: SQL long field names Henry Fidler <zodcomag@gmail.com> - 2021-07-12 03:52 -0700
      Re: SQL long field names "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-12 16:23 +0200

csiph-web