Click here to Skip to main content
       

Database

 
Questionsql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:23 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 18:35 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:40 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 18:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 19:05 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:08 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 19:15 
Try just running the select portion of it and see if you return results.
 
Your insert will need to use a field list though, not *. eg: insert into table1 (field1, field2) select field1, field2 from table2
 
Also, you would need to clear the data from your local table first if you are wanting to replace it with the data from your server.

QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 2:40 
AnswerRe: sql server table records to sqlite PinmvpEddy Vluggen28-Feb-13 9:25 
QuestionRe: sql server table records to sqlite Pinmemberjojoba20111-Mar-13 20:23 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pinmembergavindon27-Feb-13 15:57 
AnswerRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pinmembergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 19:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 11 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid