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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mimi2012

    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...
  2. Mimi2012

    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...
  3. Mimi2012

    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...

Part and Inventory Search

Back
Top