Querying a Table in Visual Basic 2010 from the organization
Hello, I am making a query to a table and did not return information, instruction before you step as the number of the organization, could help solve the Why?
Thanks!
Thanks!
Schedule the code
Dim oCon As OracleConnection = New OracleConnection(sCadenaConexion)
oCon.Open()
Dim command As OracleCommand = New OracleCommand("begin apps.fnd_client_info.set_org_context(102); end;", oCon)
command.ExecuteNonQuery()
Dim reader As OracleDataReader
Dim sql As String = "SELECT COUNT(trx.trx_number) facturas" & _
" FROM ra_customer_trx_all trx," & _
" ar_customers cu," & _
" fnd_lookup_values lkv," & _
" hr_organization_units_v org," & _
" ra_cust_trx_types_all trt," & _
" ra_salesreps_all sr" & _
0