Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: suhas hegde
  Where is suhas hegde?
 sirsi
 India
 suhas hegde
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: VFP-SQLSERVER vrs VFP-ORACLE
Thread ID: 154909 Message ID: 154943 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Thursday, December 20, 2007 6:35:03 PM         
   


>
> I have this program which works well with sql server backend.
>
> However after migrating the backend from sqlserver to oracle,
> I'm having a situation where in a straight forward update involving 3 datafiles, the first datafile updates and the rest don't.
>
> What are the tips and techniques to overcomes this problem and other techniques needed?
>

The problem as i have read with oracle is it is not version Compatible .... New syntax new behaviour with each version ...
(Not really sure , never worked with ... Just couldnt get hold of a free version)

As for the problem ... try with 3 seperate connections ..... to each datatable ( thats if i recollect right of what i have read)

Suhashegde

ENTIRE THREAD

VFP-SQLSERVER vrs VFP-ORACLE Posted by DEREK DODOO @ 12/20/2007 3:51:06 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Ken Murphy @ 12/20/2007 3:56:11 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Maurizio Zazzi @ 12/20/2007 3:58:43 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Cetin Basoz @ 12/20/2007 4:29:53 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Ken Murphy @ 12/20/2007 5:12:36 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Frank Cazabon @ 12/20/2007 11:37:46 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Ken Murphy @ 12/21/2007 1:12:17 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Frank Cazabon @ 12/21/2007 7:42:16 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by suhas hegde @ 12/21/2007 8:11:46 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Bernard Bout @ 12/22/2007 4:53:03 AM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Bernard Bout @ 12/22/2007 4:48:47 AM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Frank Cazabon @ 12/22/2007 1:35:17 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Cetin Basoz @ 12/28/2007 2:47:54 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by suhas hegde @ 12/20/2007 6:35:03 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Bernard Bout @ 12/21/2007 4:58:33 AM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Andy Kramek @ 12/21/2007 12:38:35 PM
RE: VFP-SQLSERVER vrs VFP-ORACLE Posted by Pete Sass @ 12/28/2007 2:20:06 PM