Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create a procedure with PSQL 8
Hi, I'm trying to create a stored procedure that seeks a string (eg '0099 ') in a column of type 50 times PIC 9(4) COMPANIES column is as follows: 0099006901610169000000000000000000000000000000000000000000000000000000000 Here is my sp: CREATE PROCEDURE usp_GetCompanyInfo (in: CompanyID char...- Mimi2012
- Thread
- Replies: 0
- Forum: Pervasive: Pervasive.SQL
-
Stored procedure in Pervasive.SQL V8, using one of table column of "50 TIMES PIC 9(4)" typ
Hi, I try to create a stored procedure which takes a parameter i.e. :CompanyId char(4) and to get some info about the company. I tried this SELECT statement into the PERVASIVE.SQL DATA MANAGER (a sort of SQL Analyzer) and it works fine. SELECT GROUP, NAME FROM MYTABLE WHERE (COMPAGNIES...- Mimi2012
- Thread
- Replies: 1
- Forum: Pervasive: Btrieve
-
Stored procedure in Pervasive.SQL V8, using one of table column of 50 TIMES PIC 9(4).
Hi, What I try to do is to create a stored procedure which takes a parameter i.e. :CompanyId char(4) and to get some info about the company. I tried this SELECT statement into the PERVASIVE.SQL DATA MANAGER (a sort of Analyzer) and it works fine. SELECT GROUP, NAME FROM MYTABLE WHERE...- Mimi2012
- Thread
- Replies: 0
- Forum: Pervasive: Pervasive.SQL
