Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > SQL Language
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 7th, 2011, 10:25 AM
Authorized User
Points: 169, Level: 3
Points: 169, Level: 3 Points: 169, Level: 3 Points: 169, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2008
Location: Northampton, , United Kingdom.
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default Tables not listed in intellisense...

I have created a basic schema structure with 10 tables in it. In creating each table, I simply right-clicked on the TABLE and selected "New Table..." and tapped in the details, setting the primary keys. When completed, I created the database diagram and used that to create the foreign keys.

Next step, creating first stored procedure, in which the procedure takes in two sets of data ... let's say DRIVER and VEHICLE with the idea that some data is checked for presence in a table, added if needed and then a second insert complete.

So, if the car exists in the VEHICLE table, there's no need to add it - just pull the ROWID which is added as a value to the DRIVER table. If the car isn't there, add it ... then pull the ROWID.

When I added the code for INSERT INTO VEHICLE... it was fine

When I added the code for SELECT @CAR_ID = ID FROM VEHICLE... that was fine, too

Problem...

INSERT INTO ... intellisense pops up at this point, but only the VEHICLE table is listed (other than the system tables) and I can't navigate to my table, whether direct by name, through dbo.<name> or by <schema>.dbo.<name>

Apologies for all the "bumpf" in this, but thought I would offer as much information as I could provide ... and/all help appreciated.

Sean
__________________
Regards,

Sean
Reply With Quote
  #2 (permalink)  
Old April 7th, 2011, 10:31 AM
Authorized User
Points: 169, Level: 3
Points: 169, Level: 3 Points: 169, Level: 3 Points: 169, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2008
Location: Northampton, , United Kingdom.
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Further to this in a simple query window, I have just typed "SELECT * FROM DRIVER" and it's put the red squiggle under "DRIVER", which tips to "Invalid object name 'DRIVER'" ... as the tables were created the same way, I am confused why I can only see the one table, which happens to be the first one I created.
__________________
Regards,

Sean
Reply With Quote
  #3 (permalink)  
Old April 7th, 2011, 10:33 AM
Authorized User
Points: 169, Level: 3
Points: 169, Level: 3 Points: 169, Level: 3 Points: 169, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2008
Location: Northampton, , United Kingdom.
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Grrrr!!

Looks like it has the error ... but does execute.
__________________
Regards,

Sean
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sites not listed after creation stokerfed SharePoint Admin 1 June 5th, 2007 02:29 PM
i looked at apress.com, its not listed kender All Other Wrox Books 9 January 6th, 2007 11:43 AM
SqlDataAdapter does not have its properties listed thaopham215 ADO.NET 0 December 5th, 2006 04:33 PM
Un-listed Source code mikea All Other Wrox Books 1 August 29th, 2005 09:16 AM
Table not listed in DTS jgprentice SQL Server DTS 4 January 30th, 2004 04:53 PM



All times are GMT -4. The time now is 03:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.