Query ony showing *(All Columns) no columns are shown 
Author Message
 Query ony showing *(All Columns) no columns are shown

Hi,

I'm trying to design a query in the data enviroment conneted to a sql
server 2000 database from VB6 sp5.

Every time I drag a table into the query designer the table only show
*(all columns). It does not show the rest of the column names in the
table. I have tried other databases, they appear to be fine. Can
anyone help me with this ?

Thank you



Sat, 02 Jul 2005 20:18:06 GMT  
 Query ony showing *(All Columns) no columns are shown
Hi,

Can you be more specific about the steps you are following to produce this
problem?

Thanks,
VBdotNET [MSFT]

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Quote:
> Hi,

> I'm trying to design a query in the data enviroment conneted to a sql
> server 2000 database from VB6 sp5.

> Every time I drag a table into the query designer the table only show
> *(all columns). It does not show the rest of the column names in the
> table. I have tried other databases, they appear to be fine. Can
> anyone help me with this ?

> Thank you



Sat, 30 Jul 2005 06:00:27 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. REQ: Show picture in column B, depending value in column A

2. User defined column to show task progress...

3. How do I show a hidden column again?

4. Break Word Table columns and show in next page

5. Resizing Excel Inline Shape to show more rows / columns

6. listview columns don't show

7. Datagrid containing a column showing an icon

8. SQL statement - SHOW TABLE (COLUMNS) LOCATIONS

9. DBGrid...Limit number of columns shown

10. show more columns in a listbox

11. DBListBox "Show 2 Columns??"

12. Combo Box multiple columns, show description

 

 
Powered by phpBB® Forum Software