alykhan
|
| Posted: 05/08/2003, 11:51 AM |
|
For some strange reason Studio does not pickup all the fields in my tables. For example when I enable authentication, it only picks up 3 fields in my users table instead of the 6 I have in there. It also fails to pickup fields in other tables using the application builder.
For example my user table is
TABLE [dbo].[Users] (
[UserID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
[UserName] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Password] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Enabled] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AffiliateID] [int] NULL ,
[UserLevel] [int] NULL
When I pick the fields from the dropdown I only see
UserName
Enabled
UserLevel
The only thing I can think of is that i just installed the Office 2002 SP2 + Frontpage Sharepoint SP2 and that seems to have broken it. I reinstalled Studio with the 11 fix but still I'm having this problem.
Any ideas?
|
|
|
 |
derylb
|
| Posted: 05/09/2003, 6:45 AM |
|
Did you try refreshing the connection inside CodeCharge?
|
|
|
|
Guy
|
| Posted: 05/09/2003, 7:02 AM |
|
I have the same problem, some tables and some fields are not present when i use the application builder with a new project. I don't understand.
Thanks for your help
Guy
|
|
|
|
Alykhan
|
| Posted: 05/09/2003, 8:58 AM |
|
Yes I've tried refeshing the control. Its wierd how some fields show up and others don't. There is no consistency in the datatypes either of the missing fields. I'm using and OLE DB SQL Server connection.
|
|
|
|
GreggB
|
| Posted: 05/09/2003, 9:13 AM |
|
Have you tried building a second connection and tetsing it to see if all the fields appear?
GreggB
|
|
|
|
Headhunter
|
| Posted: 05/09/2003, 9:24 AM |
|
I once had the same problem and mailed about it to YesSoftware.
They answered this:
To overcome the problem with non displayed fields please open Connection properties, switch to Advanced tab and uncheck Show System Tables, Show System Views. If it won’t help, uncheck Show Aliases as well. It should help.
http://www.dbweaver.com
|
|
|
|
Guy
|
| Posted: 05/09/2003, 11:16 AM |
|
With all your solutions nothing work. It's the same
|
|
|
|
rclayh
|
| Posted: 05/09/2003, 12:12 PM |
|
Office SP2 may have installed the Security patch that other people have been posting about. Some of the other post give the patch number, but they have been reporting problems with dropdowns too.
|
|
|
|
Guy
|
| Posted: 05/10/2003, 3:20 PM |
|
How to uninstal just this patch ?
|
|
|
|
alykhan
|
| Posted: 05/13/2003, 12:27 AM |
|
Well I tried the second connection and the other changes in the advanced tab neither of them helped. I have a windows XP pro machine in which i installed CSS and also applied Office SP2, it worked fine. The machine I am working on is Win2K Pro. The only other thing I added was the Frontpage Extensions SP2 which may have changed some things also? I can't seem on unistall the patches so I'm partially hosed.
Damn service packs, can't live with them and can't live without them.
|
|
|
|
Guy
|
| Posted: 05/19/2003, 11:07 AM |
|
I uninstalled the cumulative patch Q813489 but CCS not work
Any other idea for this miising field ?
Thanks
|
|
|
|
alykhan
|
| Posted: 05/21/2003, 11:29 PM |
|
Just a bit more info.. Okay I tried the same thing with a MySQL database and had the same problem. Only 4 of my 8 tables showed up in the table drop down and when I selected a particular table, no fields showed up on the list which is kind of strange.
|
|
|
|
Alykhan
|
| Posted: 08/07/2003, 12:47 AM |
|
I started working on a new machine and the problem went away. I haven't used the tool in a while and now when I restart it (CCS 2.1), some of the fields and tables are missing and I haven't been able to find a solution to the problem other than to start with a fresh install of XP or 2000. I've got all the latest service packs from MS, and I know that sometimes they clobber CCS. Any ideas? I can't be the only one who has run into this I hope.
My machine Windows XP Pro with IIS and SQL 2000 developer on the same box.I also have VS.NET and some other Pocket PC development tools. I'm actually using MySQL that is hosted and I have the latest ODBC driver (MySQL ODBC 3.51 Driver 3/4/2003). What's wierd is I can see all the tables/columns when I connect with Access through the same ODBC driver so there is clearly something wrong with CCS.
|
|
|
|
thang doan
|
| Posted: 08/12/2003, 7:45 PM |
|
i have thge same problem today, did you find a solution?
-T
|
|
|
|
fco
|
| Posted: 09/13/2003, 1:58 AM |
|
Same issue for me.
Is there a workaround ?
Francois.
|
|
|
|
