Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 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: 155003 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Friday, December 21, 2007 12:38:35 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.

It's not a question of "ignoring" anything! It's a question of what back ends are used by VFP systems. For every one that uses Oracle, there are hundreds using SQL Server or MySQL. Very few people work, routinely, with VFP and Oracle and so there are not many people who have much expertise with this product combination.

> Each time I posed a question relating to the oracle backend, I end up not getting any response(s).

Excuse me! But I have replied to every one of your posts on Oracle. I regard that remark as grossly insulting. The fact that you don't like the answer you get does not mean that the answer is not valid.

> We cannot live in isolation.

Then I strongly suggest you try TAKING some of the advice you have been given and go and do some research on your own instead of demanding to be spoon-fed and complaining when you don't get what you want.

> The experts should assist.

I don't know if I am an "expert" or who these "experts" that you seem to think are withholding information from you are. But I know that I have tried on several occasions to help you, but you repeatedly demonstrate that you are not prepeared to help yourself in the slightest.

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

As I have told you at least half a dozen times. Go and talk to your DBA! The "issues" you have are to do with the way that your Oracle system is configured and the rights and permissions that your connection is granted. This is not a coding issue, it is a configuration issue and you need to have your DBA fix that for you.

I repeat that there are NO "issues" with VFP and Oracle!

There is no special technique for working with Oracle from VFP, I have been doing this since 1996 and have never encountered the problems you report UNLESS things are not configured correctly! The problem here is your apparent inability to take the advice you are offered.

If one table updates and another does not then there are only two possibilities (and I have said this before too)
[1] You do not have update permission on the table
[2] Your values or keys are incorrect and so no records meet the specified criteria

Finally, if I may say so, the tone and tenor of this, (and certain other messages you have posted), is rude, insulting and ungracious and, certainly as far as I am concerned, I am not going to waste any more of my precious time reading anything that you have to say here, or anywhere else.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

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