Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Linking Fox and Oracle
Message
De
11/06/1999 08:21:16
 
 
À
11/06/1999 07:46:38
Gregg Geeslin
Kwajalein Range Services
Apo, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00227943
Message ID:
00228694
Vues:
17
Oracle has its own extension of SQL called SQL/PL (PL = procedure
language). As far as I know, you can only use standard SQL when
utilizing VFP and Oracle via SQL Passthru.

You will find that Oralce SQL is not very compliant to the SQL-92
standard. This kind of surprised me. To see what I mean, compare
and contrast a LEFT OUTER JOIN between SQL Server and Fox versus
Oracle's (+) command.

A good book on Oracle for your purposes would be "Oracle SQL
High-Performance Tunning" by Guy Harrison. Check it out from
Amazon.com or better yet buybooks.com (always cheaper).

T.O.A.D. VI is a very good product to use when working with
Oracle. The boys from Redmond would be doing themselves a favor
by looking into the features of this tool. TOAD does things like
emulating a BROWSE window (pretty neat considering Oracle is an
SQL backend) from its Object browser. Lots of other things that
make this approximately $200 product well worth it.

You can get TOAD from www.quests.com.

>>Paul,
>>
>>I connect to an ORACLE database (read-only) and the only "gotcha" I ran into was formatting of dates. If I were doing a specific query on a date, I would need to use '... WHERE TheDate = "Jan-10-1999"'
>>
>>The alternative is to say dMyDate = {01/10/1999} and then say '... WHERE TheDate = dMyDate' and let Fox convert for you.
>>
>>I am developing an application in Foxpro that will need to be used with Oracle as the back end in the future and was looking for information on the subject. If anyone knows of websites, usefull books or applications that would help, I would appreciate the input.
>>
>>Thanks,
>>
>>Paul
>
>I do a lot of work with VFP 6.0 connected to an Oracle 7.3 database. When you're using ODBC into Oracle, your SQL statement has to be written using Oracle's "flavor" of SQL. Dates in Oracle are recorded and stored as numbers. Try this whenever you need to use a date in a WHERE clause (or just about anywhere else): TO_DATE('06/11/1998','MM/DD/YYYY')
>
>To help us get up and running in Oracle, we bought a product called TOAD. There is a demo version but I don't have the URL here at home. It is a nice graphical interface for PL/SQL programming in Oracle. I had the company buy me a copy of PL/SQL Knowledge Base from the folks at http:\\www.revealnet.com\. They've got a demo version that you might want to look at. Their full version is rather pricey but it has done me more good than going to classes.
>
>If I can be of any help, let me know.
>
>Gregg
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform