AccSys for Paradox Functions
Discontinued

AccSys Functions for Tables:

1. Pempty - Empties a table and all indexes
2. Perrmsg - Obtains an error message string
3. Popen - Opens a table and its index
4. PtoPD - Obtains access forPD functions
5. PtoPK - Obtains access forPK functions
6. PtoPS - Obtains access forPS functions
7. Pencrypt/Pdecrypt - Encrypts/decrypts a table
8. Ppasswd - Establishes an active password
9. Pdelete - Deletes a table and its index files
10. Pclose - Closes a table and indexes by HTABLEreference
11. Pchkcrypt - Checks if a table is password-protected

AccSys Functions for Non-Keyed Tables:

1. PDcreat - Creates an empty table file from user application
2. PDcopy - Creates an empty table file from an existing table file (copy structure)
3. PDbuffs - Calculates memory size to be used for table file
4. PDopen - Opens non-keyed table file
5. PDclose - Closes table file
6. PDgetrec - Reads a table record by record number
7. PDseek - Sets the current record in a non-keyed table
8. PDcurrec - Reads the current record from a non-keyed table
9. PDcurrno - Reads the current record number in a non-keyed table
10. PDnxtrec - Reads the next record from a non-keyed table
11. PDprvrec - Reads the previous record from a non-keyed table
12. PDputrec - Insets a table record by record number
13. PDapprec - Appends a table record
14. PDupdrec - Updates a table record by record number
15. PDdelrec - Deletes a table record by record number
16. PDflush - Flushes the current record buffers
17. PDsize - Gets the number of records in table
18. PDreclen - Gets the record number
19. PDfields - Gets the number of fields in the record
20. PDfldnm - Gets the field information by name (name, length, type, displacement)
21. PDfldno - Gets the field information by field number (name. length, type, displacement)
22. PDsort - Sorts the table file
23. PDapart - Converts a keyed table to a non-keyed table
24. PDmode - Checks the mode of a table; i.e., keyed/non-keyed, write-protected, passwork-protected
25. PDchmod - Changes the table mode

AccSys Functions for Keyed Tables:

1. PKcreat - Creates an empty table and empty primary index
2. PKcopy - Creates an empty table and empty primary index from an existing keyed table.
3. PPbuffs - Calculates memory size used for primary index
4. PKopen - Opens primary index and its table
5. PKclose - Closes primary index and its table
6. PKputrec - Puts the record into the table and updates the primary index
7. PKgetrec - Reads a record by primary key
8. PKdelrec - Deletes the record, removes the key from the primary index
9. PKupdrec - Updates the record by primary key
10. PKrewind - Rewinds primary index to Beginning-Of-File (BOF)
11. PKforwrd - Positions primary index to End-Of-File (EOF)
12. PKnxtrec - Gets record by next primary key
13. PKprvrec - Gets record by previous primary key
14. PKcurrec - Gets record using the current primary key
15. PKcurkey - Gets the current primary key
16. PKflush - Flushes the primary index to disk
17. PKkeylen - Gets the primary key length
18. PKkyflds - Gets the number of fields that make up primary index
19. PKindex - Generates a new primary index from an existing table
20. PKtoPD - Obtains PD pointer for use with the PD functions

AccSys Functions for Secondary Index Files:

1. PScreat - Creates an empty secondary index
2. PXbuffs - Calculates memory size used for X index file
3. PYbuffs - Calculates emeory size used for Y index file
4. PSkopen - Opens incremental secondary index files
5. PStopen - Opens non-incremental secondary index files
6. PSclose - Closes secondary index
7. PSnincix - Formats the key for secondary index for non-incremental index
8. PSincrix - Formats the key for secondary key for incremental secondary index
9. PSputkey - Puts secondary key into secondary index
10. PSsetkey - Sets the current secondary key
11. PSnxtkey - Gets the next secondary key
12. PSprvkey - Gets the previous secondary key
13. PScurkey - Gets the current key
14. PSrewind - Rewinds secondary index to BOF
15. PSforwrd - Positions the secondary index to EOF
16. PSgetrec - Reads a record using the secondary key
17. PSnxtrec - Gets the next record by secondary key
18. PSprvrec - Gets the previous record by secondary key
19. PScurrec - Gets the record by current secondary key
20. PSkeylen - Gets the secondary key length
21. PSkeytyp - Gets the secondary key type
22. PSflush - Flushes secondary index (useful only for incremental secondary index files)
23. PStype - Reports the secondary index type: incremental or non-incremental
24. PSindex - Generates an entire secondary index from the table
25. PStindex - Generates complete non-incremental secondary index from the table
26. PSkindex - Generates complete incremental secondary index from the table
27. PSukeylen - Gets the 'user' secondary key length
28. PSfirst/PSnext - Obtains the first and the following secondary indexes
29. PSkeycount - Tells the number of keys in secondary index
30. PScreatC - Creates composite or case-insensitive secondary index
31. PSindexC - Generates composite or case-insensitive secondary index from table
32. PSkindexC - Generates composite or case-insensitive incremental secondary index from table
33. PStindexC - Generates composite or case-insensitive secondary index from table
34. PSnincixC/PSincrixC - Format keys for composite or case-insensitive secondary index
35. PStypeC - Returns information information about a composite secondary index

Note: Secondary index without keyed tables are used for read-only purposes.

Utility Functions:

1. PUdblton - Converts a double numeric field
2. PUntodbl - Converts a numeric field to double
3. PUitosn - Converts integer to short numeric field
4. PUsntoi - Converts a short numeric field to integer
5. PUfmdate - Formats a date field to month, day and year
6. PUmmddyy - Converts a date field to month, day and year
7. PUalphan - Formats a string to alphanumeric field format with padded zeros.
8. PUatostr - Converts a Paradox alphanumeric field to a C string format
9. PUleap - Tests if a year is a leap year
10. PUexpnm - Expands a base name to a specific file name
11. PUsetso - Sets the character set and its sort order
12. PUgetso - Sets the sort order to the Paradox sort order file
13. PUfindso - Finds sort order specified in the table and its index
14. PUtmpdir - Sets a directory for temporary files 15. PUntod - Converts numeric field to 'double' of C

BLOB Functions:

1. PBBlobClear - Clears a BLOB in a record buffer
2. PBBlobClone - Clones (creates) private BLOBS from public BLOBS
3. PBBlobClose - Closes BLOB that was opened for reading or writing
4. PBBlobDrop - Drops a private BLOB
5. PBBlobGet - Reads data from BLOB opened for reading or writing
6. PBBlobOpenRead - Opens public BLOB for reading
7. PBBlobOpenWrite - Opens public BLOB for reading and writing
8. PBBlobPut - Writes data to BLOB opened for writing
9. PBBlobQuickGet - Reads BLOB leader data
10. PBBlobGetSize - Gets size of BLOB opened for reading or writing

Network Capabilities:

Network capabilities automatically handle network control and file locking. The following functions could be listed in the above sections since the multi-user functions also follow the same naming conventions (for example, PKgrbrec starts with PK and it handles a keyed-table).

These functions are specifically designed to handle network specific tasks.

1. Plogin - Logs into a multi-user database
2. Pbecome - Becomes another user already logged into a multi-user database
3. Plogout - Logs out from a multi-user (network) database
4. Pwholist - Lists users logged into the multi-user (network) database
5. Pwhotbl - Lists users who locked a table along with the lock types
6. Pgetlong - Obtains a record number in long integer from a 4-bytes array set by Pwhotbl
7. PDtbllck - Locks or unlocks a non-keyed table with one of the following: Full Lock, Prevent Full Lock, Write Lock, or Prevent Write Lock
8. PKtbllck - Locks or unlocks a non-keyed table with one of the following: Full Lock, Prevent Full Lock, Write Lock, or Prevent Write Lock
9. PDreclck - Locks, unlocks and tests a record in a non-keyed table
10. PDcurlck - Locks, unlocks and tests a current record in a non-keyed table
11. PKreclck - Locks, unlocks and tests a record in a keyed table
12. PDlkstat - Tells locks placed by the current program in a non-keyed table
13. PKlkstat - Tells locks placed by the current program in a keyed table
14. PDelock - Provides an exclusive lock in a non-keyed table
15. PKelock - Provides an exclusive lock in a keyed table
16. PDgrbrec - Grabs and reads a record from a non-keyed table even if the table is full locked
17. PKgrbrec - Grabs and reads a record from a keyed table even if the table is full locked
18. PDlckget - Locks and reads a record from a non-keyed table
19. PKlckget - Locks and reads a record from a keyed table
20. PDchange - Checks if a non-keyed table has been changed by another user
21. PKchange - Checks of a keyed table has been changed by another user
22. Pflock - Locks or unlocks a file with one of the following: Full Lock, Prevent Full Lock, Write Lock, or Prevent Write Lock

Request a demonstration version of the CopiaFacts Suite!

Read a few recent articles on Copia's line of products!

Get pricing from a reseller in your area or direct from Copia