PdcDatabase.OpenExternalQuery - Revision history

Arjan: /* Notes */

2020-02-24T10:47:02Z

Notes

← Older revision		Revision as of 10:47, 24 February 2020
Line 7:		Line 7:
	== Notes ==		== Notes ==
	This method opens a query for a specified SQL statement to another PdC environment.		This method opens a query for a specified SQL statement to another PdC environment.

			Please pay attention!
			Parameters are case sensitive

	== Code example ==		== Code example ==

Arjan: /* Code example */

2020-02-24T10:45:07Z

Code example

← Older revision		Revision as of 10:45, 24 February 2020
Line 11:		Line 11:

	<source lang="vb">		<source lang="vb">

			Dim qryRemote As PDCEXT.IDBQuery = PDC.App.Database.OpenExternalQuery("127.0.0.1", 5432, "pdc55")

			If Not IsNothing(qryRemote) Then
			qryRemote.SQL = $"select * from lk_klant where kl_debnr = '000028'"
			If qryRemote.Execute Then
			MsgBox(qryRemote.GetStr("kl_naam"))
			Else
			MsgBox(PDC.App.LastError)
			End If
			End If

	</source>		</source>

	== Availability ==		== Availability ==
	Available from version 5.5		Available from version 5.5

Mike: Created page with "== Declaration == OpenExternalQuery(ServerIP as String, Port as Integer, DBName as String) as PdcDBQuery == Description == Return a IDBQuery for execution == Notes == T..."

2020-01-24T08:50:58Z

Created page with "== Declaration == OpenExternalQuery(ServerIP as String, Port as Integer, DBName as String) as PdcDBQuery == Description == Return a IDBQuery for execution == Notes == T..."

New page

== Declaration ==
OpenExternalQuery(ServerIP as String, Port as Integer, DBName as String) as [[PdcDBQuery]]

== Description ==
Return a IDBQuery for execution

== Notes ==
This method opens a query for a specified SQL statement to another PdC environment.

== Code example ==

<source lang="vb">
</source>

== Availability ==
Available from version 5.5