Custom Queries in FP 2003

[scmiles]

I solved my own problem if anyone is interested.

When entering in your custom query, you have to include
the database information in the select statement as wel
as the table, unlike working in SQL Query Analyzer where
you would say

Select * from Events (for a table called events in a db
called Calendar which you where conencted to)

In FP2003 Custom Query editor you would enter
(Select * from Calendar.dbo.events)

Also you do need to enable the update query option in the
data retrieval services section of the admin pages.

 

[John Clark]

Excellent!

That should have been obvious to both of us; I wish there was an easier way
to troubleshoot this feature. Better error messages should would help.

-John

 

[John Clark]

Additional information:

It seems that if your DEFAULT database in SQL is the Database you use in
your query, you don't need to include the database information in your
string. You only need to if you are querying against your NON default
database (which I would imagine would be the norm).

-John