469,935 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

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


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
3 9001
2,878 Expert 2GB
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
I trying to insert simple text data in field having datatype MEMO.


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

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.

Nov 28 '08 #4

Post your reply

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

Similar topics

4 posts views Thread by Rob | last post: by
1 post views Thread by Martin Hayer | last post: by
2 posts views Thread by mrajanikrishna | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.