PETableDifferenceInfo
Read-Only Struct PETableDifferenceInfo contains database table information that is used by PECheckNthTableDifferences.
C Syntax
typedef struct PETableDifferenceInfo {
WORD StructSize;
DWORD tableDifferences;
DWORD reserved1;
DWORD reserved2;
} PETableDifferenceInfo;
Members
StructSize
| Specifies the size of the PETableLocation structure. Initialize this member to PE_SIZEOF_TABLE_DIFFERENCE_INFO.
|
tableDifferences
| Read-Only. Returns any combination of the following PE_TCD_XXX TableDifference Constants.
|
| Constant
| Value
|
| PE_TCD_OKAY
| 0x00000000
|
| PE_TCD_DATABASENOTFOUND
| 0x00000001
|
| PE_TCD_SERVERNOTFOUND
| 0x00000002
|
| PE_TCD_SERVERNOTOPENED
| 0x00000004
|
| PE_TCD_ALIASCHANGED
| 0x00000008
|
| PE_TCD_INDEXESCHANGED
| 0x00000010
|
| PE_TCD_DRIVERCHANGED
| 0x00000020
|
| PE_TCD_DICTIONARYCHANGED
| 0x00000040
|
| PE_TCD_FILETYPECHANGED
| 0x00000080
|
| PE_TCD_RECORDSIZECHANGED
| 0x00000100
|
| PE_TCD_ACCESSCHANGED
| 0x00000200
|
| PE_TCD_PARAMETERSCHANGED
| 0x00000400
|
| PE_TCD_LOCATIONCHANGED
| 0x00000800
|
| PE_TCD_DATABASEOTHER
| 0x00001000
|
| PE_TCD_NUMFIELDSCHANGED
| 0x00010000
|
| PE_TCD_FIELDOTHER
| 0x00020000
|
| PE_TCD_FIELDNAMECHANGED
| 0x00040000
|
| PE_TCD_FIELDDESCCHANGED
| 0x00080000
|
| PE_TCD_FIELDTYPECHANGED
| 0x00100000
|
| PE_TCD_FIELDSIZECHANGED
| 0x00200000
|
| PE_TCD_NATIVEFIELDTYPECHANGED
| 0x00400000
|
| PE_TCD_NATIVEFIELDOFFSETCHANGED
| 0x00800000
|
| PE_TCD_NATIVEFIELDSIZECHANGED
| 0x01000000
|
| PE_TCD_FIELDDECPLACESCHANGED
| 0x02000000
|
reserved1
| Reserved. Do not use.
|
reserved2
| Reserved. Do not use.
|
VB Type Listing
Type PETableDifferenceInfo
StructSize As Integer
tableDifferences As Long
reserved1 As Long
reserved2 As Long
End Type
Delphi Record Listing
type
PETableDifferenceInfo = record
StructSize : Word;
tableDifferences : DWord;
reserved1 : DWord;
reserved2 : DWord;
end;
PETableLocation
PETableLocation contains database location information that is used with the PEGetNthTableLocation to gather current location information and PESetNthTableLocation to pass new location information.
C Syntax
typedef struct PETableLocation {
WORD StructSize;
char Location [PE_TABLE_LOCATION_LEN];
char SubLocation[PE_TABLE_LOCATION_LEN];
char ConnectBuffer[PE_CONNECTION_BUFFER_LEN];
} PETableLocation;
Members
StructSize
| Specifies the size of the PETableLocation structure. Initialize this member to PE_SIZEOF_TABLE_LOCATION.
|
Location
| Specifies the database location (of length PE_TABLE_LOCATION_LEN = 256, NULL-terminated). This member is database dependent and must be formatted correctly for the expected database. The following table lists some examples.
|
| Database Location Examples
|
| xBASE (Natively): <drive>:\<path>\<file>
|
| xBASE (ODBC): <datasource name>
|
| Paradox (Natively): <drive>:\<path>\<file>
|
| Paradox (ODBC): <datasource name>
|
| Btrieve (Natively): <drive>:\<path>\<file>
|
| Btrieve (ODBC): <datasource name>
|
| Oracle (Natively): <database>.<table>
|
| Oracle (ODBC): <database>.<table>
|
| SQL Server (Natively): <database>.<owner>.<table>
|
| SQL Server (ODBC): <database>.<owner>.<table>
|
SubLocation
| Specifies the database sublocation (of length PE_TABLE_LOCATION_LEN = 256, NULL-terminated).
|
ConnectBuffer
| Specifies the connection buffer (of length PE_CONNECTION_BUFFER_LEN = 512, NULL-terminated) containing connection information for attached tables.
|
VB Type Listing
Type PETableLocation
StructSize As Integer
Location As String * PE_TABLE_LOCATION_LEN
SubLocation As String * PE_TABLE_LOCATION_LEN
ConnectBuffer As String * PE_CONNECTION_BUFFER_LEN
End Type
Delphi Record Listing
type
PETableLocType = array [0..PE_TABLE_LOCATION_LEN - 1] of Char;
PEConnectBufferType = array [0..PE_CONNECTION_BUFFER_LEN - 1] of Char;
PETableLocation = record
StructSize : Word;
Location : PETableLocType;
SubLocation : PETableLocType; { For MS Access Table Names }
ConnectBuffer : PEConnectBufferType;
end;