Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction in Visual Foxpro
Message
De
03/01/2002 08:24:35
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00600175
Message ID:
00600210
Vues:
26
So this was tho have transactions over the novell this no longer exist in VFP now you have this functions built in as log as you use database.
It's always fun to learn new info.

Thanks.

>>Are you talkin about the FP connectivity kit? if so this has to connect to sqlserver/oracle/etc..
>
>As far as I can recall I tested it back then, and we didn't have any Oracle etc.; I even would say there wasn't any Oracle for PC's yet (it started with some Novell NLM). But let me check ...
>
>Ah ! found. It's from netware and it was delivered with FoxPro 2.5 (I think earlier too). The library is NETWARE.PLB, and it contains the functions BEGINTRAN, COMMIT, RLLBACK, TTSATTRIB, TTSAVAIL. Looking at the last two, it needed Novell's TransAction Tracking System, which wasn't standard back then.
>
>So I was sort of wrong, and the commands are different, but the working (I guess) the same.
>As I see, this library is from 1993 ...
>
>... Found some help too. Just for fun, here it is (partly):
>
>
> FoxPro supports transaction processing on networks running
> Novell NetWare through the use of NETWARE.PLB, an external
> API library included with FoxPro.  NETWARE.PLB accesses
> Novell's Transactional Tracking System (TTS).
>
> A transaction is a set of changes made to a database and any
> related files (indexes, memo files, etc.).  Transaction
> processing protects a database and its related files from
> corruption and maintains their integrity by restoring the
> file(s) to their pre-transaction state when interruptions
> occur.  Interruptions can occur when a work station fails,
> the file server fails or a program error occurs before the
> database and its related files are properly updated.
>
> Opening NETWARE.PLB
>     Before you can access the transaction processing provided
>     by the external NETWARE.PLB API library, you must load
>     NETWARE.PLB with the FoxPro SET LIBRARY command.  If
>     NETWARE.PLB is located in the same directory as FoxPro,
> use this command to open the library:
>
> SET LIBRARY TO netware
>
> NETWARE.PLB provides these functions:
>
> ► TTSAVAIL() -- Checks for the presence of Novell
> Netware's TTS (Transactional Tracking System).
>
> ► TTSATTRIB() -- Specifies that a file be included in a
> transaction.
>
> ► BEGINTRAN() -- Specifies the beginning of a
> transaction.
>
> ► COMMIT() -- Writes changes to the files included in the
> transaction.
>
> ► RLLBACK() -- Backs out changes made to the files
> included in the transaction.
>
> NETWARE.PLB is installed into the same directory as
>    FoxPro by default.  If the NETWARE.PLB file is located in
>    another directory or on another drive, include the
>    directory or drive with the NETWARE.PLB file name.  You
>    do not have to include the library extension unless you
>    have changed the .PLB extension to a different extension.
>
>    If other API libraries are open when you open the
>    NETWARE.PLB library, include the ADDITIVE key word with
>    the SET LIBRARY command to keep the other API libraries
>    open.  If you do not include the ADDITIVE key word, other
>    open libraries will be closed.
>
>Checking For Novell's Transactional Tracking System
>    The NETWARE API library requires services provided by
>    TTS, Novell's Transactional Tracking System.  TTS must
>    first be loaded from the file server for the NETWARE API
>    library to provide transaction processing.  Consult your
>    Novell documentation for further information on how TTS
>    is loaded on your Novell network.
>
>    After you open the NETWARE API library with SET LIBRARY,
>    you can use TTSAVAIL() to determine if Novell's TTS
>
>and so on ...
>
>Peter
Alexandre Palma
Senior Application Architect
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform