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.
13 mar 2023 · This tutorial explains how to use IF NOT logic in VBA to test if some condition is not met, including examples.
30 paź 2023 · This article will demonstrate how to use the VBA If statement with And, Or and Not. When we us an IF statement in Excel VBA, the statement will execute a line of code if the condition you are testing is true.
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.
If a boolean_expression is evaluated and its value is TRUE, the statements after the corresponding THEN run. The succeeding expressions are not evaluated, and the statements associated with them do not run.
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.
