Hi CK
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
User Profile
Collapse
-
Kunal Desale replied to insert/update data in foxpro table field having datatype MEMO using linked serverin SQL Serverinsert/update data in foxpor table field having datatype memo
I trying to insert simple text data in field having datatype MEMO.
eg.
insert into nr...sm_srvrq(r eqdesc) values('abc')
nr = linked server name
sm_srvrq = foxpro table (.dbf)
reqdesc = field having type memo
'abc' = simple text dataLeave a comment:
-
Kunal Desale started a topic insert/update data in foxpro table field having datatype MEMO using linked serverin SQL Serverinsert/update data in foxpro table field having datatype MEMO using linked server
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... -
I am using Linked Server to fetch records in Access.
My Foxpro Tables are very big and contains to much columns ...
Instead of that I give you small example of same scenario.
Consider one table named "Test" which contains one column named "MyNum".Tab le contains 1,1,2,2,3,3,4,4 ,5,5 (10 Records.).In this table 1,2,3,4,5 are getting Repeated.
Now Query Using "DLookUp " and "INNER...Leave a comment:
-
Convert Access Dlookup into SQL Server Query
Hello,
I am migrating access queries to SQL Server 2005 Queries.
My Access Query Is:
SELECT qtrade.intordre ftrim AS Expr1, qtrade.extordre ftrim AS Expr2, qtrade.intinvre ftrim AS Expr3, DLookUp("[intinvref]","[trade]","[ledgerno] = " & 4 & "and [intordref] ='" & [intordreftrim] & "'") AS InvNoLookup, qtrade.invline AS Expr4, qtrade.accounti d AS...
No activity results to display
Show More
Leave a comment: