Valentina Studio Crashing on XP and MacOS X - URGENT!

[Ruslan Zasukhin]

On 22/11/07 7:17 PM, "Dave" <dave at looktowindward.com> wrote:

Hi Dave,

It is so big, and bad formatted in email that I cannot see easy what syntax
can cause problem here.

You mean form

  INSERT () ... SELECT ()   ????
  CASE ? 
  LEFT OUTER JOIN ?
  NOT EXISTS ?

        We support it.


    !=    btw is not Standard SQL, must be <>
          and we support != also.

Only last query -- Subquery kind which we really not have implement yet.


> It doesn't support this for instance:
> 
> insert    MusicBaseC (_GenXUniqueID,
> 
> AlbumName,AlbumRating,AlbumRatingKind,ArtistName,BitRate,BPM,DateAdded,
> 
> Duration,FileLocation,FileSizeBytes,Genre,ModDate,PlayedCount,PlayedDate
> ,
> 
> SampleRate,TrackName,TrackRating,TrackRatingKind,TrackSkippedCount,Track
> SkippedDate,
> UnplayedFlag,
> _GenXAction)
> select    t2.[_GenXUniqueID],
>          case when t2.AlbumName = t1.AlbumName then null else
> t2.AlbumName end,
>          case when t2.AlbumRating = t1.AlbumRating then null else
> t2.AlbumRating end,
>          case when t2.AlbumRatingKind = t1.AlbumRatingKind then null
> else t2.AlbumRatingKind end,
>          case when t2.ArtistName = t1.ArtistName then null else
> t2.ArtistName end,
>          case when t2.BitRate = t1.BitRate then null else t2.BitRate
> end,
>          case when t2.BPM = t1.BPM then null else t2.BPM end,
>          case when t2.DateAdded = t1.DateAdded then null else
> t2.DateAdded end,
>          case when t2.Duration = t1.Duration then null else
> t2.Duration end,
>          case when t2.Genre = t1.Genre then null else t2.Genre end,
>          case when t2.FileLocation = t1.FileLocation then null else
> t2.FileLocation end,
>          case when t2.ModDate = t1.ModDate then null else t2.ModDate
> end,
>          case when t2.TrackName = t1.TrackName then null else
> t2.TrackName end,
>          case when t2.PlayedCount = t1.PlayedCount then null else
> t2.PlayedCount end,
>          case when t2.PlayedDate = t1.PlayedDate then null else
> t2.PlayedDate end,
>          case when t2.TrackRating = t1.TrackRating then null else
> t2.TrackRating end,
>          case when t2.TrackRatingKind = t1.TrackRatingKind then null
> else t2.TrackRatingKind end,
>          case when t2.SampleRate = t1.SampleRate then null else
> t2.SampleRate end,
>          case when t2.FileSizeBytes = t1.FileSizeBytes then null else
> t2.FileSizeBytes end,
>          case when t2.TrackSkippedCount = t1.TrackSkippedCount then
> null else t2.TrackSkippedCount end,
>          case when t2.TrackSkippedDate = t1.TrackSkippedDate then
> null else t2.TrackSkippedDate end,
>          case when t2.UnplayedFlag = t1.UnplayedFlag then null else
> t2.UnplayedFlag end,
>          case when t1.[_GenXUniqueID] is null then 'I' else 'U' end
> from    MusicBaseB t2
>              left outer join MusicBaseA t1 on t1.[_GenXUniqueID] = t2.
> [_GenXUniqueID]
> where    (t1.[_GenXUniqueID] is null
>          or    (
>              t1.AlbumName != t2.AlbumName
>              or t1.AlbumRating != t2.AlbumRating
>              or t1.AlbumRatingKind != t2.AlbumRatingKind
>              or t1.Duration != t2.Duration
>              or t1.Genre != t2.Genre
>              or t1.TrackName != t2.TrackName
>              or t1.PlayedCount != t2.PlayedCount
>              or t1.TrackRating != t2.TrackRating
>              or t1.TrackRatingKind != t2.TrackRatingKind
>              or t1.TrackSkippedCount != t2.TrackSkippedCount
>              or t1.TrackSkippedDate != t2.TrackSkippedDate
>                )
>          )

-------
> insert    MusicBaseC (_GenXUniqueID, _GenXAction)
> select    t1.[_GenXUniqueID],
>          'D'
> from    MusicBaseA t1
> where    not exists (select * from MusicBaseB where [_GenXUniqueID] =
> t1.[_GenXUniqueID])

-- 
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]