By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

insert/update data in foxpro table field having datatype MEMO using linked server

P: 5
Hi,

How to insert/update data in foxpro table field having datatype MEMO using Linked Server?

I have written sql insert queries in which i have used linked server to insert data into foxpro tables. Some fields have datatype Memo and in these fields my data is not getting inserted/updated.

My queries contains local tables & dbf tables (Both).

I try simple insert query which insert data into one memo field in foxpro editor
and sql editor.

It is getting inserted when execute directly on fox pro but not getting inserted/updated from sql server (using linked server)

So How to resolve this problem?
Nov 26 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
What value are you trying to insert to?

Will http://blogs.msdn.com/sqlcat/archive/2008/01/25/foxpro-to-sql-server-migration-experience.aspx help?

-- CK
Nov 27 '08 #2

P: 5
I trying to insert simple text data in field having datatype MEMO.

eg.

insert into nr...sm_srvrq(reqdesc) values('abc')

nr = linked server name
sm_srvrq = foxpro table (.dbf)
reqdesc = field having type memo
'abc' = simple text data
Nov 27 '08 #3

P: 5
Hi CK

I need your help reagrding insert/udate issue of data in foxpro table memo field.
I didn't get any help from link posted by you.

Please try to send solution as early as possible.
I have added detail description already.

-Kunal
Nov 28 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.