RE: Aggg, please check this query to see why it doesn't work

From: Amy Yuan [MS] (amyy_at_online.microsoft.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 23:49:06 GMT

Hi Brian,

SQL CE is not a server and hence doesn't support different logins and roles
like SQL Server. No owner for tables. That's why it will not recognize
dbo.verbs as a table name.

Try this and it should work:
SELECT Verbs.Verb, Pronouns.Pronoun FROM Verbs INNER JOIN
Tenses ON Verbs.Verb_Tense = Tenses.Tense_ID INNER JOIN
Infinitives ON Verbs.Verb_Infinitive =
Infinitives.Infinitive_ID INNER JOIN Pronouns ON
Verbs.Verb_Pronoun = Pronouns.Pronoun_ID

Thanks,
Amy

--------------------
| From: brian@norman.org (Brian Norman)
| Newsgroups: microsoft.public.sqlserver.ce
| Subject: Aggg, please check this query to see why it doesn't work
| Date: 23 Feb 2004 14:50:43 -0800
| Organization: http://groups.google.com
| Lines: 27
| Message-ID: <9ddde0d9.0402231450.1e2b2e0f@posting.google.com>
| NNTP-Posting-Host: 62.252.64.8
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1077576644 12030 127.0.0.1 (23 Feb 2004
22:50:44 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Mon, 23 Feb 2004 22:50:44 +0000 (UTC)
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!newsfeed.wirehub.nl!news2.euro.net!in.100proofnews.com!in.100proofnews.
com!news-out.visi.com!petbe.visi.com!news.octanews.net!newsfeed2.dallas1.lev
el3.net!news.level3.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:11416
| X-Tomcat-NG: microsoft.public.sqlserver.ce
|
| Hello
|
| Can someone tell me why
|
| SELECT dbo.Verbs.Verb, dbo.Pronouns.Pronoun FROM dbo.Verbs INNER JOIN
| dbo.Tenses ON dbo.Verbs.Verb_Tense = dbo.Tenses.Tense_ID INNER JOIN
| dbo.Infinitives ON dbo.Verbs.Verb_Infinitive =
| dbo.Infinitives.Infinitive_ID INNER JOIN dbo.Pronouns ON
| dbo.Verbs.Verb_Pronoun = dbo.Pronouns.Pronoun_ID
|
| will not work in sqlce
|
| I get
|
| Native Error: 25501
|
| Param 0: 1
| Param 1: 17
| Param 2: 0
| Param 3: Verbs
|
| This query works fine in SQL Query Analyiser but not in sqlce
|
| Any help would be great as im loosing hair over using sqlce
|
| Thanks
| Brian
|

Relevant Pages
Loading