Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread DBISAM CS - inmemory tables error
Wed, Nov 28 2018 4:49 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi All,

After change to CS following code returns an error (same code works with
session stLocal):

with MultipleRegQuery do begin

if active then close;

sql.Clear;

sql.add('select dato,min(starttid) as mintid, ressource, max(sluttid) as
makstid, ((max(sluttid) - min(starttid)) / 4) as totaltimer, min(start)
as minstart,beregnet');

sql.add(',max(slut) as maksslut, count(*) as antalreg');

sql.Add('into "memory\multiregdato"');

sql.add('from "kundtimer.dat"');

sql.add('where ressource = :ressourcenum');

sql.Add('and dato between :fradato and :tildato');

sql.add('group by dato');

sql.add('having (antalreg > 1)');

sql.add('order by dato asc;');

unprepare;

prepare;

paramByName('ressourcenum').AsInteger := Res_tableid.Value;

paramByName('fradato').Asdate := FraDato.date;

paramByName('tildato').Asdate := TilDato.date;

open;

end;

MultipleRegQuery.Close;

MultipleRegQuery.Unprepare;

The Error code is # 11010 Table og backup file 'multiregdato' does not
exists.


Every query/table in my application has the same session set to
stRemote. Should I change the code so inmemory tables has its own
session pointing to a local session or?


Thanks in advance,

Regards,

Hüseyin

Thu, Nov 29 2018 10:22 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com



<< The Error code is # 11010 Table og backup file 'multiregdato' does not exists. >>

This error indicates that you're trying to *open* that table, not create it (INTO).  Are you sure that the error is coming from *this* query and not some other query ?

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Nov 29 2018 11:03 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Tim,

Same code works when sessiontype changed to stLocal, the problem is when
it's stRemote.

Regards,
Hüseyin

Den 29-11-2018 kl. 16:22 skrev Tim Young [Elevate Software]:
> << The Error code is # 11010 Table og backup file 'multiregdato' does not exists. >>
>
> This error indicates that you're trying to *open* that table, not create it (INTO).  Are you sure that the error is coming from *this* query and not some other query ?
>
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Mon, Dec 10 2018 3:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Huseyin,

<< Same code works when sessiontype changed to stLocal, the problem is when it's stRemote. >>

Please break the issue down into a sample project that reproduces the issue, and email it to me.  I suspect that you'll find the issue during that process, but if not, I can tell you what's going on.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Dec 10 2018 4:22 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi Tim,

OK, i will try to see if i can get you a sample that reproduces the
issue. Thanks.

Regards,
Hüseyin

Den 10-12-2018 kl. 21:21 skrev Tim Young [Elevate Software]:
> Huseyin,
>
> << Same code works when sessiontype changed to stLocal, the problem is when it's stRemote. >>
>
> Please break the issue down into a sample project that reproduces the issue, and email it to me.  I suspect that you'll find the issue during that process, but if not, I can tell you what's going on.
>
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Image