Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 5 of 5 total |
DBISAM CS - inmemory tables error |
Wed, Nov 28 2018 4:49 PM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 > |
This web page was last updated on Thursday, April 18, 2024 at 10:42 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |