Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 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: 155254 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Friday, December 28, 2007 2:20:06 PM         
   


> It's quite obvious that for some reason memebers of foxite have limited themselves to vfp sql server connectivity, whilst conspiciously ignoring the oracle backend and its attendant issues.
>
> Each time I posed a question relating to the oracle backend, I end up not getting any response(s).
>
>
> We cannot live in isolation.
>
> The experts should assist.
>
> If there are additional fees required we are ready.
>
>
>
>
> The question I have is got to do with updates.
>
>
>
> 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?
>
>
> I'm using spt connection.
>
>
> Thanks


Hi,
Compatibility between VFP and Oracle is dependant upon what version of
Oracle you are running with what version of VFP.
I have personally found that the majority of update failure issues are
due to varchar() fields in Oracle. In older versions of VFP such as
VFP 6.0 prior to the introduction of the varchar() field type in VFP you
definatly had an issue and the update required a RTRIM() on each and
every character field in VFP that was updating into an Oracle Varchar
field type.
I think in your identified issue you need to post code showing your
connection string and your update code.
You may also have fallen into a trap that the account your are connect
with in your connection string does not have full update, insert and delete
capabilities on all tables.
You may wish to download Toad for Oracle which is freeware so you can more
easily go into tables and verify field types and permissions. Oracle also
has a Visual Studio Manager starting with Oracle version 8.1.7, and this will work
with version 8.1.5 also.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

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