Yep, your right. Just saw another error in my statement, so here I go again...

I use the Convert function, taking a type to format as yymmdd. You can choose any...

Another, maybe simpler solution, is to put the event_date in your select in an Aggregate function (e.g. min). This will not change results, since you're grouping on the column anyway.

One of my previous employers also used the SQLPrepare method. Gives a huge performance boost in comparison to direct execution.

However, as is described in the (very long

Does it really 'hang', or is there just no page coming up?

Depending on the technology you are using, it might be necessary to install the CR ActiveX on the client...

System Error 33 :

The process cannot access the file because another process has locked a portion of the file. ERROR_LOCK_VIOLATION

I'm not sure if you can put a backup on...

Something like this should work :

SELECT

   IsNULL(M.Title, U.Title),

   IsNull(M.Artist, U.Artist),

   M.DiscNo,

   M.TrackNo

FROM    Master M

 ...

You can start off with the tutorial that is included with AS. This will give you at least a good overview of the user interface and the most important (basic)...

I'm afraid your out of luck. I don't believe there is any 'easy' option for getting this done.

The only solution I see is to remove the FK's, do the DELETE...

Does it also run slow in CR or Access?

Can you give us the query?

Maybe post an execution plan too.

I'm certainly no Oracle expert, but from your explanation, I think a user defined datatype is the solution.

If you use a user-defined datatype consistently throughout your database (in table definitions,...

Ok, now it gets difficult...

You could built a table holding all of the relationships. It would just contain the ItemId of the source and of the destination row.

Eg. (could be...

I'm not sure I get your question?

To use this kind of technique, there has to be a clear one to one relationship between the record you want to update and...