Subject | Re: [IBO] Generation of dataset for inet download (?) |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-04-18T06:56:13Z |
Hi Claus! This reply is mainly to make the others on this list aware that
you've got no replies - don't think I know of anything that could solve
your problems!
correspond to some other users result set, do they get an old result set
from themselves or do they get a result set with missing or added records?
the JOIN syntax (translated into Norwegian for you ;o):
iboquery14.SQL.clear;
iboquery14.SQL.add('select distinct
KOMMUNE,FORVALTNING,STILLING,FENAVN,ADRES1,
PNR,BY,tlf,fax,mail from innkm');
iboquery14.sql.add('JOIN komnavn ON innkm.komnr = komnavn.komnr');
Apart from this I'm afraid I cannot be of much use. I guess your problem
could come from not creating a new instance of Request or Response for each
running instance, but I've never written a web module so I'll leave the
rest to others on this list.
Good luck solving your problem,
Set
you've got no replies - don't think I know of anything that could solve
your problems!
>This works OK. But sometimes the download does not correspond to theIn what way doesn't it correspond to the result set? Do the download
>resultset, when several users are working simultaneously.
correspond to some other users result set, do they get an old result set
from themselves or do they get a result set with missing or added records?
> iboquery14.SQL.clear;KOMMUNE,FORVALTNING,STILLING,FENAVN,ADRES1,
> iboquery14.SQL.add('select distinct
> PNR,CITY,tlf,fax,mail fromindkm,komnavn');
> iboquery14.sql.add('where (indkm.komkode = komnavn.komkode)');Oops, IBO doesn't like this unless you've filled in JoinLinks. Rather, use
the JOIN syntax (translated into Norwegian for you ;o):
iboquery14.SQL.clear;
iboquery14.SQL.add('select distinct
KOMMUNE,FORVALTNING,STILLING,FENAVN,ADRES1,
PNR,BY,tlf,fax,mail from innkm');
iboquery14.sql.add('JOIN komnavn ON innkm.komnr = komnavn.komnr');
Apart from this I'm afraid I cannot be of much use. I guess your problem
could come from not creating a new instance of Request or Response for each
running instance, but I've never written a web module so I'll leave the
rest to others on this list.
Good luck solving your problem,
Set