PdcDatabase.OpenExternalTable
Declaration
OpenExternalTable(DBPath as String,UserName as String,Password as String,TablePath as String,IndexName as String,ClientServer as Boolean,Exclusive as Boolean) as PdcDBTable
Description
Open a table outside the data dictionary
Notes
This method opens a table that is not added to the datadictonary.
The input parameters are:
- Databasepath as string, can be an empty string.
- Username as string, can be an empty string.
- Password as string, can be an empty string.
- Tablepath as string, this paramater is mandatory, aways use the table extention .ADT.
- Indexname as string
- ClientServer as boolean
- Exclusive as boolean
Code example
dim objTable
dim tablepath
dim hoogte
tablepath = pdc.Options.GetFilePath(pdcApplicationPath) & "\Scripter\Settings"
set objTable = pdc.Database.OpenExternalTable("","","",tablepath & "\Settings.ADT","SET_ID",False,False)
if IsValid(objTable) then
if objTable.Locate("SET_ID","HOOGTE") then
hoogte = objTable.GetField("VALUE")
end if
end if
Availability
Available since June 2008 (from version 3.8)