SQLSETPROP( ) Function Example

SQLSETPROP( ) is used to set the packet size for the current connection.

* Clear environment
CLOSE ALL
CLEAR ALL
CLEAR

* Display the Select Connection or Datasource dialog box
* to choose a connection
nHandle=SQLCONNECT()

* Test connection, report results
IF nHandle > 0
   * Set PacketSize
   nSet=SQLSETPROP(nHandle, "PacketSize", 2048 )
   * Test setting and display results
   IF nSet > 0
      =MESSAGEBOX("PacketSize was set to 2048",0,"Connection Results")
   ELSE
      =MESSAGEBOX("Error setting PacketSize",0,"Connection Results")
   ENDIF
ELSE
   =MESSAGEBOX("No Connection",0,"Connection Results")
ENDIF
=SQLDISCONNECT(nHandle)