Difference between revisions of "SQLERROR()"

From Lianjapedia
Jump to: navigation, search
m (Text replace - "Recital" to "Lianja")
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
−
Function to return the error message for the last remote data connection error
+
Function to return the error message for the last ODBC data connection error
−
 
+
  
 
==Syntax==
 
==Syntax==
 
SQLERROR(<nStatementHandle>)
 
SQLERROR(<nStatementHandle>)
−
 
  
 
==See Also==
 
==See Also==
−
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]]
+
[[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLDATASOURCES()]], [[SQLDRIVERS()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]], [[SQLTRANSACTION()]]
−
 
+
  
 
==Description==
 
==Description==
−
The SQLERROR() function is used to return the error message for the last remote data connection error.
+
The SQLERROR() function is used to return the error message for the last ODBC data connection error.
  
−
The SQLERROR() function operates on the data source specified by <nStatementHandle>, which must be an active remote data connection handle.
+
The SQLERROR() function operates on the ODBC connection specified by <nStatementHandle>, which must be an active remote data connection handle.
  
−
 
+
{| class="wikitable" width="100%"
−
{| class="wikitable"
+
!width="30%"|Keywords||width="70%"|Description
−
!Keywords||Description
+
 
|-
 
|-
−
|nStatementHandle||The workarea in which the gateway data source is open.
+
|nStatementHandle||Statement handle to the connection
 
|-
 
|-
 
|}
 
|}
−
 
  
 
====Return values:====
 
====Return values:====
 
The SQLERROR() function returns a character string containing the descriptive message for the last error.
 
The SQLERROR() function returns a character string containing the descriptive message for the last error.
−
 
  
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
−
nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-/usr/recital/uas/data/southwind.tcpip",.T.)
+
nStatHand = sqlconnect("awhr")
 
if nStatHand < 1
 
if nStatHand < 1
−
    messagebox("Cannot make connection", 16, "SQL Connect Error")
+
messagebox("Cannot make connection", 16, "SQL Connect Error")
 
else
 
else
−
    messagebox('Connection made', 48, 'SQL Connect Message')
+
messagebox("Connection made", 48, "SQL Connect Message")
−
    store "00010" to myVar
+
sqlexec(nStatHand,"create table doc1 (account_no char(5), lastname char(25), balance dec(10,2))")
−
    SQLEXEC(nStatHand, "SELECT * FROM example WHERE account_no = ?myVar", "restab")
+
messagebox("Table created")
−
    if used("restab")
+
m_accno =  "00699"
−
        browse
+
m_lastname = "Smith"
−
    else
+
m_balance = 12345.67
−
        messagebox(SQLERROR(nStatHand),16,"SQL Error")
+
sqlexec(nStatHand,"insert into dbo.doc1 (account_no,lastname,balance) VALUES ('&m_accno','&m_lastname',&m_balance)")
−
    endif
+
messagebox("Record inserted")
−
    SQLDISCONNECT(nStatHand)
+
nRet = sqlexec(nStatHand,"select * from dbo.doc1","mycursor")
 +
if nRet = -1
 +
messagebox(sqlerror(nstatHand))
 +
else
 +
messagebox("Record selected")
 +
list
 +
endif
 +
// Using prepared statement
 +
sqlprepare(nStatHand,"select * from dbo.doc1 where account_no = ?m_accno","mycursor")
 +
nRet = sqlexec(nStatHand)
 +
if nRet < 1
 +
messagebox(sqlerror(nstatHand))
 +
else
 +
messagebox("Record selected using prepared statement")
 +
list
 +
endif
 +
sqldisconnect(nStatHand)
 
endif
 
endif
 
</code>
 
</code>
  
−
==Products==
 
−
Lianja, Lianja Server
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:SQL]]
 
[[Category:SQL]]
−
[[Category:Remote Data Connectivity Functions]]
 
 
[[Category:ODBC Functions]]
 
[[Category:ODBC Functions]]
 
[[Category:SQL Functions]]
 
[[Category:SQL Functions]]

Latest revision as of 07:46, 4 March 2019

Purpose

Function to return the error message for the last ODBC data connection error

Syntax

SQLERROR(<nStatementHandle>)

See Also

SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLDATASOURCES(), SQLDRIVERS(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES(), SQLTRANSACTION()

Description

The SQLERROR() function is used to return the error message for the last ODBC data connection error.

The SQLERROR() function operates on the ODBC connection specified by <nStatementHandle>, which must be an active remote data connection handle.

Keywords Description
nStatementHandle Statement handle to the connection

Return values:

The SQLERROR() function returns a character string containing the descriptive message for the last error.

Example

nStatHand = sqlconnect("awhr")
if nStatHand < 1
	messagebox("Cannot make connection", 16, "SQL Connect Error")
else
	messagebox("Connection made", 48, "SQL Connect Message")
	sqlexec(nStatHand,"create table doc1 (account_no char(5), lastname char(25), balance dec(10,2))")
	messagebox("Table created")
	m_accno =  "00699"
	m_lastname = "Smith"
	m_balance = 12345.67
	sqlexec(nStatHand,"insert into dbo.doc1 (account_no,lastname,balance) VALUES ('&m_accno','&m_lastname',&m_balance)")
	messagebox("Record inserted")
	nRet = sqlexec(nStatHand,"select * from dbo.doc1","mycursor")
	if nRet = -1
		messagebox(sqlerror(nstatHand))
	else
		messagebox("Record selected")
		list
	endif
	// Using prepared statement
	sqlprepare(nStatHand,"select * from dbo.doc1 where account_no = ?m_accno","mycursor")
	nRet = sqlexec(nStatHand)
	if nRet < 1
		messagebox(sqlerror(nstatHand))
	else
		messagebox("Record selected using prepared statement")
		list
	endif
	sqldisconnect(nStatHand)
endif
Retrieved from "https://www.lianja.com/doc/index.php?title=SQLERROR()&oldid=21407"