Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread vista & dbisam v2.12
Tue, Sep 11 2007 9:11 AMPermanent 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 AMPermanent 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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

Image