Subject Re: Lookup doens't work any more
From Dirk <dirk@test.com>
Date Tue, 5 Nov 2019 09:48:36 +0100
Newsgroups dbase.getting-started


Goodday,

when open the programm as administrator it's working
strange being administrator always

regards

Dirk

Op 4/11/2019 om 15:09 schreef Dirk:
> Goodday,
 > since day and night use a datamodule in a programm,
 >
> now suddently got follow msg :: database Engine Error : Capablitity not
> supported c:\..QSQLOOO.DBF
 >
> when i click further :(ignore) no fields were found to process :
> mainstamm.DMD
 > after a while i get errors on *.WFM file
 >
> and finally i get the form can apppend, but don't get the lookup tables
> ( can not chose)
 >
> use 12.xx version
 >
> when i use the source everthing works normal
 >
> this parts of dmd gives error
 >   with (this.STAMMDAT1.rowset)
 >        with (fields["Province"])
 >           lookupSQL = "select area,area from euroregions order by area"
 >        endwith
 >        with (fields["Country"])
 >           lookupSQL = "select land,land from country order by land"
 >        endwith
 >        with (fields["soort"])
 >           lookupSQL = "select description,description from segm order by
> description"
 >        endwith
 >        with (fields["outside"])
 >           lookupSQL = "select name,name from employee order by name"
 >        endwith
 >        with (fields["TAAL"])
 >           lookupSQL = "select idtaal,naam from taal order by naam"
 >        endwith
 >        autoEdit = false
 >     endwith
 >
> but yesteray i had to give rights to some directories
 >
> what can be wrong
 > thanks
 > Dirk