Pervasive
Sign in | Join | Help
in

stored procedure with a variable table

Last post 06-17-2008 10:24 PM by Mirtheil. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-17-2008 8:32 PM

    stored procedure with a variable table

    Is there a way to have a stored procedure using a variable table name in a select

    (ie)

     IN TableName char(20)

    select * from :TableName 

     

  • 06-17-2008 10:24 PM In reply to

    Re: stored procedure with a variable table

     Not using PSQL v8 (or v9, I think). In v10, you can use the Exec command (See docs here).

    Mirtheil
Page 1 of 1 (2 items)
© 2008 Pervasive Software Inc. All Rights Reserved.