New Posts New Posts RSS Feed: The Refresh attempt has failed
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

The Refresh attempt has failed
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
BillG View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 05-Dec-2007
Location: Monroe, MI
Posts: 233 		Post Options Post Options   Quote BillG Quote  Post ReplyReply Direct Link To This Post Topic: The Refresh attempt has failed
    Posted: 04-Aug-2013 at 10:25pm
I am getting this error message when saving a record to the batches table.
 
I have a table called batches. It's key is made up of 3 fields:
 
Office nvarchar(2)       it is always 2 characters.   Should i change this to nchar(2)
BatchDate DateTime
BatchNo int
 
how can i fix my key so as not to get this message?
 
Bill
 
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 06-Aug-2013 at 6:17pm
The DateTime field in your key might be causing the problem.  See the last post in this thread - http://www.ideablade.com/forum/forum_posts.asp?TID=1842.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down