Can I do it? RDA method. 
Author Message
 Can I do it? RDA method.

But now i have a new problem of it, i can use this RDA method to insert and
update the table of remote sql server, it's smoothly.
but i found i have no method to return the record set of remote sql server,
the means if i use this sentence:
ceRDA.SubmitSQL "SELECT * FROM MyCustomers","Provider=sqloledb;Data
Source=192.168.1.98;Initial Catalog=ePPC;user id=sa;password="

(because i want to get some special records from remote sqlserver to do some
action in sql ce, what can i do ?

I have a idea, that i use PULL method to select the special records into a
sql CE table, and compare the records between this table and the table which
already existed in the CE, I don't know wether this's correct, how about
your suggestion?

Sign DocumentBest Regards, Benny Ng Kenfil Hong Kong Ltd. Shenzhen Office

http://www.*-*-*.com/



Mon, 19 Jan 2004 10:58:56 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. RDA - Pul method

2. Problems with RDA Pull method for SQLCE

3. What is AddNew method doing

4. How do I create a canned form?

5. Canned AcctReceivable Module needed!

6. Canned pages....

7. Cans access2.0 engine access btrieve files?

8. Crystal Reports Canned Code

9. Canned objects and/or images

10. Switching from inhouse software to canned package.

11. line graph in vb (canned routine)

12. 'Canned' data in VB program

 

 
Powered by phpBB® Forum Software