Search results for query: *

Hi all, I use access for my database and tyr to create a report in Excel with pivot tables and pivot charts.My problem is th pivot table does not resfresh to reflect the changes in the data source ,even after I ticked refresh on open in the data options tab in the table options. The flow is...

Hi all, I have a query like this sqlq = "SELECT Customers.CompanyName, Category.CategoryName, Customers.Area, Employees.FirstName, [Order Details].Quantity*[Order Details].UnitPrice, Orders.InvoiceNumber, [Payment Methods].PaymentMethod, Payments.PaymentAmount, Payments.PaymentDate...

sqlq = "SELECT Customers.CompanyName, Category.CategoryName, Customers.Area, Employees.FirstName, [Order Details].Quantity*[Order Details].UnitPrice, Orders.InvoiceNumber, [Payment Methods].PaymentMethod, Payments.PaymentAmount, Payments.PaymentDate, Products.ProductName...

Hi all, I am using Access database and through VBA Coding I retrieve results of a SQL query into Excel.My problem is when I use a SQL Query with GROUP BY claus I get an error similar to [Microsoft][ODBC Microsoft Access Driver]You tried to execute a query that does not include the...

Hi all, I am using Access database and through VBA Coding I retrieve results of a SQL query into Excel.My problem is when I use a SQL Query with GROUP BY claus I get an error similar to [Microsoft][ODBC Microsoft Access Driver]You tried to execute a query that does not include the...

I get an error Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Oracle][ODBC][Ora]ORA-24334: no descriptor for this position /aspproc.asp, line 27 if I use it

No commit ....dosent solve my problem. If my code is Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "DSN=****; UID=***; PWD=***" Set Comm = Server.CreateObject("ADODB.Command") Set comm.ActiveConnection = Conn comm.commandtype...

I tried it but that too dosent work .!!

Hi codestrom, The variable 'a' contains the result from the query which can be obtained later using recordsets (if in ASP) or called directly (if inside other procedures or within the same).

Hi, what exactly is ur problem??

Hi ros, An INTO a is necessary while querying a db within stored proc.

Hi barkingfrog, yes, I query the db before and after executing the stored proc.

Hi cmmrfrds, rs.state gives 0 that is, no recrdset. But if I use a delete or update Query inside the stored proc. it works .

Hi ros, In msmql it is SET NOCOUNT ON but for oracle what command supports this option? Any help appreciated.

Hi, What is the error u get?Can u send the code?

Hi desktophero, I call my stored proc.(test) through the command object as comm.commandtext = "test" So, I need not have a statement with the parens in set rs=comm.execute() Thanx

Hi ros, Thanx.But I still have a problem. My stored proc is as follows: create or replace PROCEDURE TEST AS a number(4); BEGIN SELECT empno into a from emp WHERE sal=1950; END; / This is just a simple proc to check how it works.As u said I removed the print statement.How to proceed...

Hi ros, My stored proc is as follows: create or replace PROCEDURE TEST AS a number(4); BEGIN SELECT empno into a from emp WHERE sal=1950; END; / This is just a simple proc to check how it works.As u said I removed the print statement.How to proceed next?. Where should I use SET NOCOUNT ON?.

Hi all, Can someone help me with this?

Hi, Can ue the following javascript code <SCRIPT language=&quot;javascript&quot;> window.open(&quot;windowname.asp&quot;,&quot;a name for the window&quot;, [toolbar=yes/no,statusbar=yes/no,scrollbar=yes/no&quot;]) </SCRIPT>...