|
Home > Archive > Microsoft SQL Server Desktop Engine > May 2005 > Viewing table rows in Microsoft's Web Data Administrator for MSDE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Viewing table rows in Microsoft's Web Data Administrator for MSDE
|
|
|
| Hi
I'm using the Microsoft Web Data Administrator (WDA) to access MSDE.
I've created a table and inserted values into it. When I click on my
table with inserted values in WDA, I can see details on the attributes
of each column, but not the values.
If I osql into my MSDE, I can see the values have been inserted through
a "SELECT * from tablename".
Am I blind or does WDA not show you table values/rows?
--PLum
| |
| Andrea Montanari 2005-05-28, 11:23 am |
| hi,
plum wrote:
> Hi
>
> I'm using the Microsoft Web Data Administrator (WDA) to access MSDE.
> I've created a table and inserted values into it. When I click on my
> table with inserted values in WDA, I can see details on the attributes
> of each column, but not the values.
>
> If I osql into my MSDE, I can see the values have been inserted
> through a "SELECT * from tablename".
>
> Am I blind or does WDA not show you table values/rows?
I'm not used to WDA, but I do think it only allows to show you the result of
a specific "manual" SELECT statement..
that's to say you have to query your view in order to see it's result...
SELECT * FROM dbo.yourView
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
|
|
|
|
|