472,364 Members | 2,047 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,364 software developers and data experts.

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 9204
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

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

Similar topics

by: Rob | last post by:
Hey, I'm pretty new to MySQL and have a question. I've built a database locally and have inputed some information. I need to go back and update some records, specifically by taking long pieces...
by: Martin Hayer | last post by:
Hi, how can i update the data in a field like that: \organization\name\surename\zip\city I want to update the content from "\organization" into "\neworganization" followed by...
by: markydev | last post by:
Hi, I'm using sql server 2000 sp4. I've 2 databases linked, an instance and my local. I'm getting two different errors when trying to update the remote table (local server) from the instance....
by: hafeez | last post by:
Hi , My requirement is to read and write the data from remote SQL SERVER. Locally i have SQL SERVER and i want read and write the data from remote SQL SERVER. I am able to read the data from...
by: Subrat Das | last post by:
Hi, I have a java application which calls a stored procedure to insert data into a table.Multiple threads of java call the same procedure at the same time. Sometimes it happens that few threads send...
by: hafeez | last post by:
Hi, I have two mssql databases. I am able to create a linked server. I want to delete some of the rows using this linked server. Here HAFEEZ is one mssql database and DPVSQSL is another.So, i...
by: mrajanikrishna | last post by:
Hi, I am importing external data(oracle) to local sql server DB thru linked server. This is actual replica of the external data(not normalized). I need to run this import for every 2 minutes....
by: harshadd | last post by:
can some one explain me, how to update foxpro table (.dbf file) using clien side coading in DHTML or ay client side code like java?
by: cathycros | last post by:
Hi, I'm trying to take data from varchar fields in one table and copy it to Nvarchar fields in another table. (Long story - now dealing with multiple languages, not enough space in row in current...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.