How to use MSDE(SQL Server) as GBPVR Database

[sub]

I believe I have tracked down to a possible typo in a delete function, this appears when I try and delete a source, it never succeeds and I am left with multiple sources, and a program table for of data. The line in question is:

delete from PROGRAMME p where channel_oid not in (select c.oid from CHANNEL c, SOURCE_CHANNEL_MAPPING scm where c.oid = scm.channel_oid)

I dont see any typo there, but I could be missing some. As far as I'm aware, this is work in the GBPVR Access database. Is it something in particular you think is wrong with this?

I dont test against MSDE, so I cant confirm whether or not it works.

[RonCS]

Hi Sub,

thanks for getting back so quickly. It seems that the syntax in access sql can cope with 'delete from PROGRAMME p ', but msde can not cope with the 'p' at within the 'delete from programme p', probbly a bug with msde. Going to try a SQL4 service pack see if that works.

Ron

[sub]

That looks ok to me. I'm fairly sure it would cope with the 'p'.

If you've got a tool which allows you to execute SQL, try executing that statement and see if it gives you an error.

[RonCS]

Hi Sub,

Well as ever having a few problems installing SP4 for sql on my system! The error I get from SQL Query Analyzer is Incorrect syntax near 'p'.

Ron.

[sub]

Ok, I've removed the p from the next release.

[RonCS]

Cool Thanks Sub. If only M$ had suck a quick development path.

[sub]

Hopefully its the only non-sql server compatible sql statement...probably not though.

[KingArgyle]

I suspect that MSDE is expecting an AS statement to be between PROGRAMME and the P so something like:

delete from PROGRAMME AS P where...

But even then P is never used or referenced so doesn't even need to be there, it' just cleaner to remove the P as Sub is doing.

[Darryl]

Hi,

Its been 6 months since the post in this forum indicating the fix would be in the next version.. I would hope there has been a new release since July 2005, but I can't find any release information to tell me what version(s) or when.

Is there a list of which versions contains which fixes?

I'm getting the same error trying to use the MSDE database and the current version (09516) and importing the EPG from an xmltv file.

Cheers,
Darryl

[sub]

These posts were a long time ago. I vaguely remember making some changes that were requested here, but I couldnt tell you what exactly.

The truth is, I dont develop or test GB-PVR against MSDE, so couldnt tell you whether it works or doesnt work with it. Try it by all means, but if it doenst work, then you're probably out of luck.