PdcDBQuery.GetBlobToFile - Revision history

TC at 16:22, 14 January 2021

2021-01-14T16:22:01Z

← Older revision		Revision as of 16:22, 14 January 2021
Line 1:		Line 1:
	== Declaration ==		== Declaration ==
	~~GetField~~(FieldName as String) as ~~Variant~~		GetBlobToFile(FieldName as String, FilePath as string) as boolean

	== Description ==		== Description ==
	Returns the ~~value of the supplied fieldname for the current record~~		This method stores file in a specific record to a file on disk in an applied location.
			Returns true if the file save proceed correctly.

	== Notes ==		== Notes ==
	This method ~~will return~~ a ~~field from~~ a ~~record~~.		This method stores file in a specific record to a file on disk in an applied location.

	== Code example ==		== Code example ==
	This code example executes a SQL statement and ~~returns the customer name of~~ the first record.		This code example executes a SQL statement and stores a file on disk the first record.

	<source lang="vb">		<source lang="vb">
Line 17:		Line 18:

	set objQuery = pdc.Database.OpenQuery(pdcConData)		set objQuery = pdc.Database.OpenQuery(pdcConData)
	objQuery.SQL = "SELECT * FROM ~~LK_KLANT~~"		objQuery.SQL = "SELECT * FROM ATTACH"

	if objQuery.Execute then		if objQuery.Execute then
	objQuery.FirstRecord		objQuery.FirstRecord
	msgbox objQuery.~~GetField~~("~~KL_NAAM~~")		msgbox objQuery.GetBlobToFile("at_file", "c:\temp\Filename.pdf")
	else		else
	msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & ~~qryCustomer~~.SQL		msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & objQuery.SQL
	end if		end if
	End Sub		End Sub
Line 29:		Line 30:

	== Availability ==		== Availability ==
	Available since ~~September 2008~~ (~~from~~ version 3.8)		Available since Mai 2019 (version 5.5 onwards)

TC at 16:15, 14 January 2021

2021-01-14T16:15:43Z

@@ Line 1: / Line 1: @@
-== Methods ==
+== Declaration ==
-[[PdcDBQuery.AffectedRows]]<br />
+GetField(FieldName as String) as Variant
-== Properties ==
+== Description ==
-[[PdcDBQuery.BoF]]<br />
+Returns the value of the supplied fieldname for the current record
 == Notes ==
-This property represents the query object. It makes it possible to execute SQL-statements on the database.
+This method will return a field from a record.
-== Availability ==
+== Code example ==
 Available since September 2008 (from version 3.8)

TC at 16:14, 14 January 2021

2021-01-14T16:14:51Z

← Older revision		Revision as of 16:14, 14 January 2021
Line 3:		Line 3:
	[[PdcDBQuery.Execute]]<br />		[[PdcDBQuery.Execute]]<br />
	[[PdcDBQuery.FirstRecord]]<br />		[[PdcDBQuery.FirstRecord]]<br />
	~~[[PdcDBQuery.GetBlobToFile]]<br />~~
	[[PdcDBQuery.GetField]]<br />		[[PdcDBQuery.GetField]]<br />
	[[PdcDBQuery.LastAutoIncValue]]<br />		[[PdcDBQuery.LastAutoIncValue]]<br />

TC: Created page with "== Methods == PdcDBQuery.AffectedRows
PdcDBQuery.Execute
PdcDBQuery.FirstRecord
PdcDBQuery.GetBlobToFile
PdcDBQuery.GetField
..."

2021-01-14T15:52:29Z

Created page with "== Methods == PdcDBQuery.AffectedRows PdcDBQuery.Execute PdcDBQuery.FirstRecord PdcDBQuery.GetBlobToFile PdcDBQuery.GetField ..."

New page

== Methods ==
[[PdcDBQuery.AffectedRows]] 
[[PdcDBQuery.Execute]] 
[[PdcDBQuery.FirstRecord]] 
[[PdcDBQuery.GetBlobToFile]] 
[[PdcDBQuery.GetField]] 
[[PdcDBQuery.LastAutoIncValue]] 
[[PdcDBQuery.LastRecord]] 
[[PdcDBQuery.NextRecord]] 
[[PdcDBQuery.PriorRecord]] 
[[PdcDBQuery.RecordCount]] 
[[PdcDBQuery.SetParamBool]] 
[[PdcDBQuery.SetParamStr]] 

== Properties ==
[[PdcDBQuery.BoF]] 
[[PdcDBQuery.EoF]] 
[[PdcDBQuery.FieldNames]] 
[[PdcDBQuery.SQL]]

== Notes ==
This property represents the query object. It makes it possible to execute SQL-statements on the database.

== Availability ==
Available since September 2008 (from version 3.8)

PdcDBQuery.GetBlobToFile - Revision history

TC at 16:22, 14 January 2021

TC at 16:15, 14 January 2021

TC at 16:14, 14 January 2021

TC: Created page with "== Methods == PdcDBQuery.AffectedRows PdcDBQuery.Execute PdcDBQuery.FirstRecord PdcDBQuery.GetBlobToFile PdcDBQuery.GetField ..."

TC: Created page with "== Methods == PdcDBQuery.AffectedRows
PdcDBQuery.Execute
PdcDBQuery.FirstRecord
PdcDBQuery.GetBlobToFile
PdcDBQuery.GetField
..."