Click here to Skip to main content
12,458,155 members (53,248 online)
   

Database

 
Questionsql server table records to sqlite Pin
jojoba201127-Feb-13 18:23
memberjojoba201127-Feb-13 18:23 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:35
member_Damian S_27-Feb-13 18:35 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:40
memberjojoba201127-Feb-13 18:40 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 18:51
member_Damian S_27-Feb-13 18:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:05
member_Damian S_27-Feb-13 19:05 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:08
memberjojoba201127-Feb-13 19:08 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:15
member_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 Pin
jojoba201128-Feb-13 2:40
memberjojoba201128-Feb-13 2:40 
AnswerRe: sql server table records to sqlite Pin
Eddy Vluggen28-Feb-13 9:25
mvpEddy Vluggen28-Feb-13 9:25 
QuestionRe: sql server table records to sqlite Pin
jojoba20111-Mar-13 20:23
memberjojoba20111-Mar-13 20:23 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 18:50
memberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:28
memberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:43
memberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:51
memberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:41
memberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 11:34
memberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 15:57
membergavindon27-Feb-13 15:57 
AnswerRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 16:11
member_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 17:14
membergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:34
member_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 18:45
memberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:53
member_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:26
memberMycroft Holmes27-Feb-13 19:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160826.1 | Last Updated 31 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid