 | CGUIiImportDatabaseSQLADO Method (IWin32Window, String, String, String, String, Int32) |
Create template to import an external database table,
created using SQL (New ADO Version).
Namespace:
Geosoft.Desktop.GXNet
Assembly:
geosoft.desktop.gxnet (in geosoft.desktop.gxnet.dll) Version: 2024.2.0.25
Syntaxpublic static int iImportDatabaseSQLADO(
IWin32Window owner,
string connect,
string sql,
string temp,
ref string line,
int size
)
public static int iImportDatabaseSQLADO(
IWin32Window owner,
string connect,
string sql,
string temp,
ref string line,
int size
)
Public Shared Function iImportDatabaseSQLADO (
owner As IWin32Window,
connect As String,
sql As String,
temp As String,
ByRef line As String,
size As Integer
) As Integer
Public Shared Function iImportDatabaseSQLADO (
owner As IWin32Window,
connect As String,
sql As String,
temp As String,
ByRef line As String,
size As Integer
) As Integer
public:
static int iImportDatabaseSQLADO(
IWin32Window^ owner,
String^ connect,
String^ sql,
String^ temp,
String^% line,
int size
)
public:
static int iImportDatabaseSQLADO(
IWin32Window^ owner,
String^ connect,
String^ sql,
String^ temp,
String^% line,
int size
)
static member iImportDatabaseSQLADO :
owner : IWin32Window *
connect : string *
sql : string *
temp : string *
line : string byref *
size : int -> int
static member iImportDatabaseSQLADO :
owner : IWin32Window *
connect : string *
sql : string *
temp : string *
line : string byref *
size : int -> int
Parameters
- owner
- Type: System.Windows.FormsIWin32Window
The IWin32Window the message box will display in front of. - connect
- Type: SystemString
External database connection string (Blank for OLEDB Wizard) - sql
- Type: SystemString
Text file with SQL queries to use, ("" - get from database) - temp
- Type: SystemString
Import template to make - line
- Type: SystemString
Name of table imported (returned) - size
- Type: SystemInt32
Size of table string
Return Value
Type:
Int32
0 - OK
-1 Cancel
Remarks
This is used to build an Oasis montaj group (line) from
one or more database tables and fields, by selecting from
one or more SQL selection queries. The list of queries
is read from a text file with the following syntax:
Query_Name_1
Query...
Query... (continued)
...
...
END_QUERY
Query_Name_2
etc.
Each query has a title line, the query itself, then the
"END_QUERY" line to finish. The title of a subsequent query
is on the line after an "END_QUERY" line.
If the text file parameter is left blank (""), then
selection queries in the database itself are listed.
In addition to the pre-defined queries, there is a
"User Defined" query which may be filled in by the user.
This function DOES NOT import the table itself, but
creates an import template which may be used to import
the data (see ImportDAO_DU).
See Also