Inconsistent database behaviour using RealBasic and Valentinaon WinXP, MacOS, MacOSX

[Richard Bundock]

Cindy, Ruslan

Ive tried deleting the ind file and letting Valentina rebuild it - this
didnt work.

Below is a breakdown of my database (-> denotes pointers):

  Company            [70,111 records]
  Film               [356,350 records]
  FilmName           [519,955 records]
    -> Film
  Join_Company       [338,896 records]
    -> Company
    -> Film
  Join_Person        [2,052,408 records]
    -> Film
    -> Person
  JoinLit            [41,450 records]
    -> LitSource
    -> Person
  JoinName_Company   [523,719 records]
    -> Company
    -> FilmName
  JoinName_Person    [4,527,493 records]
    -> FilmName
    -> PersonName
  LitSource          [37,125 records]
    -> Film
  Origin             [371,827 records]
    -> Film
  Person             [439,897 records]
  PersonName         [464,337 records]
    -> Person
  Reference          [303,191 records]
    -> Film

It seems that some tables are fine, however others when queried even with
something simple like

  SELECT COUNT(*) FROM Person

Cause the database to fail on the Mac OS9 build only. One guess is that
something is wrong with the pointers between my Person table and the Join
tables - although what that might be is proving elusive. Another guess is
that I may have reached some kind of limit somewhere in terms of size. The
database works fine on Mac OS9 if I only use a small subset of the data (eg.
10,000 records max in each table).

Any help is really appreciated.

Rich

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Cindy Brown
Sent: 01 July 2004 22:03
To: Valentina Developers
Subject: Re: Inconsistent database behaviour using RealBasic and
Valentinaon WinXP, MacOS, MacOSX


Have you tried removing the indexes from your database? Sometimes between
platforms you need to remove the indexes for it to work correctly.

Cindy

> on 12/10/03 9:03 PM, Richard Bundock at rbundock at bluementor.com wrote:
>
>> Hi all
>>
>> Im hoping I can get some help on the following headache - My application
is
>> built in RealBasic using Valentina. Everything tests ok on my development
>> box (WinXP). The application builds and works very well on both WinXP and
>> MacOSX,
>
>> however the MacOS9 build has problems with some queries against the
>> database. Has anyone else come across this problem ? If so, what could be
a
>> resolution ?
>
> Hi Richard,
>
> What exactly queries and what exactly problems?


--

Cindy Brown
Programmer
SchoolMaster

Kowhai Programming Systems
PO Box 198, Invercargill
81 Marama Avenue South, 9RD Invercargill
Phone (03) 213 1243
Fax (03) 213 1248
Mobile (021) 354 930
<http://www.kowhaiprogramming.com/>


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003