hi guys
i am trying to convert my clarion files (tps) to pervasive sql v8
can any clarion and pervasive sql user help me on how
1) pass parameters to my pervasive sql server
2) use the parameters passed to call my stored procedures

1. WHat parameters do you want to pass to the Pervasive server?
2. Stored Procedures are only available through a relational interface. You would need to use ODBC, OLEDB, PvQUery (in PDAC through Delphi or C++ Builder), or the ADO.NET Managed Provider. You cannot call a stored procedure from a Btrieve (transactional) application.

The syntax to execute a Stored Procedure is: call spName(<parameters>)

the ff is an example of my procedure

create procedure Balance(In :Codeno integer);
begin
insert into multistatment ( dated, code, debit, credit, narration)
select (dated, code, 0, deposit, narration )
from receeipt as REC
where REC.code = :Codeno
end
my question is how do i pass a memory variable from clarion to the above stored procedure?

That would be a Clarion syntax question. As far as how you would do it in say VB it would be something like:
I didn't test this code, it's pulled from an exisiting code base I have with modifications for your case.