VFP AND ORACLE 
Author Message
 VFP AND ORACLE
Hello,
 I want to know if somebody has connected a VFP application to an Oracle
Database.
I use ADO objects and VFPCOM.DLL but, I have some dificulties.
Can somebody help me?

 Thanks



Sun, 24 Mar 2002 03:00:00 GMT
 VFP AND ORACLE

I use ODBC.  This is enough for online applications to view/edit remote
data.
I do not use remote views, but connections and sqlexec only.

g

Quote:
> I want to know if somebody has connected a VFP application to an Oracle
>Database.
>I use ADO objects and VFPCOM.DLL but, I have some dificulties.



Sun, 24 Mar 2002 03:00:00 GMT
 VFP AND ORACLE
Hi,
we use ODBC with Oracle 7 and 8, using both SQL-Passthru and remote
views. This works very well indeed. You need to watch out for a few
pitfalls :
-in some international versions you should use the MS-ODBC driver for
Oracle. This one translates the numeric field formats correctly
(decimal points as commas) so you don't lose the values after the
decimal point.
-your date formats need to be set up correctly in Oracle with the
alter session set NLS_DATE_FORMAT='....' command so that the dates in
a cursor appear correctly.
-watch out for NULL values and empty strings. In Oracle an empty
string is a NULL value and selects on a table need to incorporate the
Oracle NVL function if you want to include empty strings in results
etc. This can be a bit confusing at first, as you don't always know
what the updatable cursor sends to the backend for an empty textbox.
-be careful with transactions. If you want to apply updates to the
database and have rollbacks work, you need to set the transaction
property of the session to manual, else each update will automatically
generate a transaction and commit it and then it's too late.

ADO is great but not as easy to use.

If you need further help, send me an EMail.

HTH Ted

On Wed, 6 Oct 1999 10:15:30 +0200, "news.alpes-net"

Quote:

>Hello,
> I want to know if somebody has connected a VFP application to an Oracle
>Database.
>I use ADO objects and VFPCOM.DLL but, I have some dificulties.
>Can somebody help me?

> Thanks




Wed, 27 Mar 2002 03:00:00 GMT
 VFP AND ORACLE

                                             Hi, lks !

        Tell me, please, how  you insert some records into table on your SQL
Server  if
   the quantity of columns of the table is near 100 (hundred) _without_
Remote View ?
         I use ODBC also, but don't know way to insert rows to table without
RV .

--
              Ravil M.Agliamov, senior programmer.

              FIDOnet : 2:5011/76.4



Quote:
> I use ODBC.  This is enough for online applications to view/edit remote
> data.
> I do not use remote views, but connections and sqlexec only.

> g

> > I want to know if somebody has connected a VFP application to an Oracle
> >Database.
> >I use ADO objects and VFPCOM.DLL but, I have some dificulties.



Sat, 13 Apr 2002 03:00:00 GMT
 VFP AND ORACLE
You could use SQLCONNECT() to establish a connection, and then write a loop
in which you use SQLEXEC() to pass query strings to the SQL Server.  The
strings would perform INSERTs.

Geoff


[greeting snipped]

Quote:
>         Tell me, please, how  you insert some records into table on your
SQL
> Server  if
>    the quantity of columns of the table is near 100 (hundred) _without_
> Remote View ?
>          I use ODBC also, but don't know way to insert rows to table
without
> RV .

[signatures and other posts/emails snipped]


Sat, 13 Apr 2002 03:00:00 GMT
 VFP AND ORACLE

                                            Hi, Geoffrey !

          Yes, of course, I know this opportunity.But the query string will
be _very_ long !
          IMHO, RemoteView is the simplest way :

                 use myRemoteView nodata
                 append from LocalResultTable

                                                Bye !
--
              Ravil M.Agliamov, senior programmer.

              FIDOnet : 2:5011/76.4



Quote:
> You could use SQLCONNECT() to establish a connection, and then write a
loop
> in which you use SQLEXEC() to pass query strings to the SQL Server.  The
> strings would perform INSERTs.

> Geoff



> [greeting snipped]
> >         Tell me, please, how  you insert some records into table on your
> SQL
> > Server  if
> >    the quantity of columns of the table is near 100 (hundred) _without_
> > Remote View ?
> >          I use ODBC also, but don't know way to insert rows to table
> without
> > RV .
> [signatures and other posts/emails snipped]



Sun, 14 Apr 2002 03:00:00 GMT
 VFP AND ORACLE
I thought you were asking how to do it _without_ remote views.

I also thought you said you didn't know how to do it without remote views -
it seems you did.

?

I'm confused.

Geoff


[greeting snipped]

Quote:
>           Yes, of course, I know this opportunity.But the query string
will
> be _very_ long !
>           IMHO, RemoteView is the simplest way :

>                  use myRemoteView nodata
>                  append from LocalResultTable

[signature and previous posts snipped]


Sun, 14 Apr 2002 03:00:00 GMT
 VFP AND ORACLE
                                            Hi, Geoffrey !

              O'k, o'k , excuse me ! I only wanted to say that creating
query
     string is more difficult than using RV.

                                                Bye !
--
              Ravil M.Agliamov, senior programmer.

              FIDOnet : 2:5011/76.4



Quote:
> I thought you were asking how to do it _without_ remote views.
> I also thought you said you didn't know how to do it without remote
views -
> it seems you did.
> I'm confused.

> Geoff
> [signature and previous posts snipped]



Mon, 15 Apr 2002 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. VFP and Oracle

2. Direct connection from VFP to ORACLE 8.x

3. VFP with ORACLE 7.3

4. VFP and Oracle

5. VFP and Oracle databases

6. FP 2.6 -> VFP+ODBC/Oracle

7. Migrating vfp to Oracle 8.05

8. VFP 3.0 + Oracle

9. Building VFP 5 project into VFP 6 executable

10. VFP 5 to VFP 7

11. VFP 5 to VFP 6


 
Powered by phpBB® Forum Software