
December 11th, 2003, 08:02 AM
|
|
Junior Member
|
|
Join Date: Dec 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
accessing stored procedure in access xp
Hey guys!!, i have writen some stored procedures in access that will take one parameter. NOw i'm trying to access them from a simple java application. I can easily reach procedures that does'nt take inparameters like this
String query = "SELECT name,ename,tele FROM test";
but when i try
String query = "myprocedure' 'parameter'; i get this responce
DELETE', 'INSERT', 'PROCEDURE', 'SELECT' eller 'UPDATE is expected, i know my syntax is probably wrong, can u help?
my stored procedure looks like this
PARAMETERS inname Text ( 255 );
INSERT INTO test ( namn )
VALUES (inname);
|