>>Hi there, here I am once again with the same question...
>>I don't know how to get a value sent back from a stored procedure via ASP.
>>I red some examples and tried them but without success.
>>
>>I tried this program in VFP and it works :
>>
>>Local NPROC,oConnection,Istr
>>oConnection = CreateObject("adodb.connection")
>>NPROC = "Mystoredproc(param)"
>>With oConnection
>> .ConnectionString = [Provider=VFPOLEDB.1;Data Source=MYDATABASE.DBC;]
>> .Open
>> istr = .execute(oproc)
>>Endwith
>>? "return value : " + istr.fields(0).value
>>istr.close()
>>oconnection.close()
>>
>>
>>The fact is that it doesn't work in ASP...please help me before it's too late
>>
>>Thank u so much
>>Alessio
>What ASP code are you using? I am assuming you are trying to access the data directly from an asp script without calling a VFP dll otherwise you would not have any real use for VFP tables in ado.
>
>Is the database on the local PC or the network. The default asp user will not have access to a network file.

It isn't a matter of database location...i can call the procedure but i cannot get the value it gives me back. I know the procedure is called because it updates a value in a record table.