John,
Is there anyway to make a PK so this is updateable?
Doyce
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Doyce-
Correct. The view will not be updatable because you have masked the Primary Key with an expression. No Primary Key = not updatable.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 17, 2014, at 3:15 PM, winberry.doyce@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:Hello Pros,
I need to link to an SQL table where the PK is a bigint type. As I am understanding from some research, I think I need to create a view of the table and use CAST as a VarChar to convert the datatype to something Access can use. So I need help with the syntax setting up the view in SQL management studio. The field name is MAXID. Here is my guess: Cast(MaxID as varchar) as MaxID. One comment I read on this approach says the view will not be updateable. How about it Pros? What do I need to do?
Doyce
__._,_.___
Posted by: winberry.doyce@roadsysinc.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar