Wired Errors from Valentina Studio

[Dave]

Yes, it works sometimes, but it randomly crashes all over the place.

Dave

On 22 Nov 2007, at 17:14, Ruslan Zasukhin wrote:

> On 22/11/07 2:02 PM, "Dave" <dave at looktowindward.com> wrote:
>
>> Hi All,
>>
>> I have created a database using RunRev, however when I open it with
>> VStudio for Mac I get the following error on the open:
>>
>> "Kernal error 0x71000 line 1:56 unexpected token"
>>
>> When I look at the DB with a select * from <table> all the records
>> seem to be there ok.
>>
>> And when I execute this:
>>
>> CREATE TABLE MusicBaseB(_GenXLibraryID TEXT
>> NULL,_GenXSentToServerFlag TEXT NULL,_GenXUniqueID TEXT PRIMARY KEY
>> NULL,AlbumName TEXT NULL,AlbumRating TEXT NULL,AlbumRatingKind TEXT
>> NULL,ArtistName TEXT NULL,BitRate TEXT NULL,BPM TEXT NULL,DateAdded
>> TEXT NULL,Duration TEXT NULL,FileLocation TEXT NULL,FileSizeBytes
>> TEXT NULL,Genre TEXT NULL,ModDate TEXT NULL,PlayedCount TEXT
>> NULL,PlayedDate TEXT NULL,SampleRate TEXT NULL,TrackName TEXT
>> NULL,TrackRating TEXT NULL,TrackRatingKind TEXT
>> NULL,TrackSkippedCount TEXT NULL,TrackSkippedDate TEXT
>> NULL,UnplayedFlag TEXT NULL)
>>
>> I get the same error.
>>
>> I have two tables MusicBaseA and MusicBaseB which are identical
>> expect for the table names.
>
> I have made in Vstudio 3.5b7 new db
> And execute this YOUR query:
>
> CREATE TABLE MusicBaseB(
> _GenXLibraryID TEXT  NULL,
> _GenXSentToServerFlag
> TEXT NULL,
> _GenXUniqueID TEXT PRIMARY KEY  NULL,
> AlbumName TEXT
> NULL,
> AlbumRating TEXT NULL,
> AlbumRatingKind TEXT NULL,
> ArtistName TEXT
> NULL,
> BitRate TEXT NULL,
> BPM TEXT NULL,
> DateAdded TEXT NULL,
> Duration TEXT
> NULL,
> FileLocation TEXT NULL,
> FileSizeBytes TEXT NULL,
> Genre TEXT
> NULL,
> ModDate TEXT NULL,
> PlayedCount TEXT NULL,
> PlayedDate TEXT
> NULL,
> SampleRate TEXT NULL,
> TrackName TEXT NULL,
> TrackRating TEXT
> NULL,
> TrackRatingKind TEXT NULL,
> TrackSkippedCount TEXT
> NULL,
> TrackSkippedDate TEXT NULL,
> UnplayedFlag TEXT NULL)
>
> Works fine. I can try with Vstudio 3.4 also.
>
>
> -----------------------
> But Dave, this is good for SQL Lite may be, but not for Valentina.
>
> Valentina have
>     Fixed String field
>     VarChar field
>     Text field
>
> And many other field types.
>
> -------
> So Why
>
>     PlayedCount TEXT NULL
>
> Or why
>
>     PlayedDate TEXT
>
> ???
>
> This should be ULONG and DATE fields in ideal.
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina