Click or drag to resize

CGUIiImportTemplateSQLADO Method (CGXNETCore, String, String, String, String)

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

Namespace:  Geosoft.Desktop.GXNetX
Assembly:  geosoft.desktop.gxnetx (in geosoft.desktop.gxnetx.dll) Version: 2025.1.0.25
Syntax
public static int iImportTemplateSQLADO(
	CGXNETCore gxNetShared,
	string name,
	string temp,
	string sql,
	string line
)

public static int iImportTemplateSQLADO(
	CGXNETCore gxNetShared,
	string name,
	string temp,
	string sql,
	string line
)

Parameters

gxNetShared
Type: GeoEngine.Core.GXNetXCGXNETCore
A shared CGXNETCore
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).
See Also