Search results
16 cze 2019 · Try the ODBC driver from Oracle {Oracle in OraClient12_home1} instead of the driver from Microsoft {Microsoft ODBC for Oracle} - The exact name of the driver could be slightly different. Check in ODBC Administrator (the 32-bit version!)
8 lip 2022 · If you are a user of Oracle’s Smart View Excel Add-in, you may find yourself wanting to automate some of its data retrieval capabilities with VBA Code. This article will show you how to call some of Smart View’s built-in functions with VBA code.
18 mar 2023 · I cannot use BFILE or create directory stuff as my oracle database resides on UNIX and my PDF file is on local c:\ drive. Powerbuilder has a datatype BLOB. I am storing that PDF files into BLOB using fileread (filepointer,blob) after opening the file in stream mode.
Using VBA Function Code Samples This guide provides examples for each VBA function. You can copy these code samples into a Visual Basic Editor Module; however Oracle recommends that you use smartview.bas imported into a module as the source of the function declarations.
This guide provides examples for each VBA function. You can copy these code samples into a Visual Basic Editor Module; however Oracle recommends that you use smartview.bas imported into a module as the source of the function declarations.
13 mar 2023 · This tutorial explains how to use IF NOT logic in VBA to test if some condition is not met, including examples.
This example explains how to use the VBA IF NOT statement to determine whether a particular Excel cell (cell A1) is empty or not. If it is, a message box will be used to display the appropriate message.
