hello,
first of all, im incorporating this in a Windows forms app, not sure if i am correct here. excuse me if i am wrong
i am looking for an easy and fast way to copy 2 collums from db1 (dbf file) to db2 (sdf)
i found out that you can use an insert and select in one query but that doesnt seem to work between 2 connections.
example:
INSERT Files (TiffName, TiffPath) SELECT namepart, pathpart FROM filetable
the reason i want to copy is performance, the foxpro file is slow when it reaches bigger sizes.
thanks in advance
first of all, im incorporating this in a Windows forms app, not sure if i am correct here. excuse me if i am wrong
i am looking for an easy and fast way to copy 2 collums from db1 (dbf file) to db2 (sdf)
i found out that you can use an insert and select in one query but that doesnt seem to work between 2 connections.
example:
INSERT Files (TiffName, TiffPath) SELECT namepart, pathpart FROM filetable
the reason i want to copy is performance, the foxpro file is slow when it reaches bigger sizes.
thanks in advance