At 04:42 PM 4/3/2009, Charles Parks wrote:
When I try to do a multi table select with a SQL Server table
and R:Base table I get an error. [Microsoft][ODBC SQL Server
Driver]Operation invalid at this time.
If I just browse from the table it shows data just fine.
This is my select statement: select * from dbo.vwBGProject
InfoTopLevel t1, ValidStates t2 where t1.state = t2.st
This select statement returns result but goes s..l..o..w..l...
y...: select * from dbo.vwBGProjectInfoTopLevel where state
in (select st from validstates)
This goes quickly but is limited" select * from dbo.
vwBGProjectInfoTopLevel where state = .fminst
Charlie,
Once the server table is SATTACHed successfully, there is no
need to add the "dbo." option to your sattached server table.
Try the SELECT command as you would for a native R:BASE table
and see what you get.
Hope that helps!
Very Best R:egards,
Razzak.
