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
--
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)