![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
![]() |
Tue, Sep 11 2007 9:11 AM | Permanent Link |
Andrej Bivic | I use dbIsam v2.12 and D4.
Have big problems with Vista!! - Query with two or more tables does not work. - master/detail doesn work Any suggestions? |
Tue, Sep 11 2007 10:02 AM | Permanent Link |
"Robert" | "Andrej Bivic" <andrej.bivic@abitrade.si> wrote in message news:1B5B2B64-0DEA-4030-A37E-DCDB1022B404@news.elevatesoft.com... >I use dbIsam v2.12 and D4. > Have big problems with Vista!! > - Query with two or more tables does not work. > - master/detail doesn work > > Any suggestions? > The two problems could be totally unrelated. I would try a simply two table query in DBSYS. You might have a rights issue in the temp folder, Vista is more finicky about that type of thing. If it works in DBSYS, there is something in your program that is causing trouble. My experience so far is that everything that works in XP works in Vista. Robert > > > |
Tue, Sep 11 2007 10:40 AM | Permanent Link |
Andrej Bivic | I tried query:
select p.DocNo, p.Code, p.Price, d.Date from TableofRows p, TablesOfHeads d where p.DocNo = d.DocNo and I get nothing but I get results from select * from TavlesofRows and from select * from TablesofHeads respectivly. And in my program I get results on query combining both tables on XP but not in Vista. Same tables, copied to Vista. |
Tue, Sep 11 2007 2:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Andrej,
<< I use dbIsam v2.12 and D4. Have big problems with Vista!! - Query with two or more tables does not work. - master/detail doesn work >> Vista shouldn't have anything to do with those two things. They are handled entirely inside of DBISAM and the OS has no bearing on their operation other than for reading the tables and writing out a temporary table for the query results. However, in both cases any failure to execute either would result in an exception, not just an empty result set. Have you confirmed that you're actually using the database tables that you think you're using ? -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 11 2007 2:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Andrej,
I forgot about locales. See this thread: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=5&msg=59479&page=1 What Language and Sort are you using for your table ? There have been some changes to the locales in Vista that could cause this type of issue. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 11 2007 3:41 PM | Permanent Link |
Andrej Bivic | The solution: check the
"XPSP2" checkbox under the executable properties, and all works again. THANKS TO EVERYONE! ps. Tim, I would still like to know if there will be done anything to make this "solution" "not needed"? |
Wed, Sep 12 2007 12:49 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Andrej,
<< ps. Tim, I would still like to know if there will be done anything to make this "solution" "not needed"? >> We aren't doing any more updates to 1.x, 2.x, or 3.x, so no, we won't be providing a fix for this. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 12 2007 4:29 PM | Permanent Link |
Andrej Bivic | Yes, I understand that, so I should upgrade to ver 4.x. Ok, but is this problem solved in 4.x? I mean, I can move to 4.x, but I would like to be sure I won't meet same problems?
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Andrej, << ps. Tim, I would still like to know if there will be done anything to make this "solution" "not needed"? >> We aren't doing any more updates to 1.x, 2.x, or 3.x, so no, we won't be providing a fix for this. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 13 2007 3:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Andrej,
<< Yes, I understand that, so I should upgrade to ver 4.x. Ok, but is this problem solved in 4.x? I mean, I can move to 4.x, but I would like to be sure I won't meet same problems? >> I can confirm this for you. Please send me the tables that you're using along with the SQL query with the joins, and I'll verify that they work correctly with DBISAM 4.x on Vista. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |