CGUIiImportTemplateSQLADO Method (IWin32Window, String, String, String, String)

Create template to import an external database table; provide query.

Namespace: Geosoft.Desktop.GXNet
Assembly: geosoft.desktop.gxnet (in geosoft.desktop.gxnet.dll) Version: 2024.2.0.25

Syntax

C++

Copy

public static int iImportTemplateSQLADO(
	IWin32Window owner,
	string name,
	string temp,
	string sql,
	string line
)

public static int iImportTemplateSQLADO(
	IWin32Window owner,
	string name,
	string temp,
	string sql,
	string line
)

Public Shared Function iImportTemplateSQLADO ( 
	owner As IWin32Window,
	name As String,
	temp As String,
	sql As String,
	line As String
) As Integer

Public Shared Function iImportTemplateSQLADO ( 
	owner As IWin32Window,
	name As String,
	temp As String,
	sql As String,
	line As String
) As Integer

public:
static int iImportTemplateSQLADO(
	IWin32Window^ owner, 
	String^ name, 
	String^ temp, 
	String^ sql, 
	String^ line
)

public:
static int iImportTemplateSQLADO(
	IWin32Window^ owner, 
	String^ name, 
	String^ temp, 
	String^ sql, 
	String^ line
)

static member iImportTemplateSQLADO : 
        owner : IWin32Window * 
        name : string * 
        temp : string * 
        sql : string * 
        line : string -> int 


static member iImportTemplateSQLADO : 
        owner : IWin32Window * 
        name : string * 
        temp : string * 
        sql : string * 
        line : string -> int

Parameters

owner: Type: System.Windows.FormsIWin32Window
The IWin32Window the message box will display in front of.
name: Type: SystemString
External database connection string (Blank for OLEDB Wizard)
temp: Type: SystemString
Import template to make
sql: Type: SystemString
SQL selection query to run on database
line: Type: SystemString
Name of Oasis table to create

Return Value

Type: Int32
0 - OK -1 - Cancel terminates on error

Remarks

This is similar to iImportDatabaseSQL_GUI, but dispenses with the dialog offering a selection of queries. Instead, the user supplies the query as a string. This function DOES NOT import the table itself, but creates an import template which may be used to import the data (see ImportADO_DU).

Reference

CGUI Class

iImportTemplateSQLADO Overload

Geosoft.Desktop.GXNet Namespace

CGUIAddLanguageSpecificTextSet("LSTFCB873E0_0?cpp=::|nu=.");iImportTemplateSQLADO Method (IWin32Window, String, String, String, String)

Parameters

Return Value

Reference

CGUIiImportTemplateSQLADO Method (IWin32Window, String, String, String, String)