Using Look-up Table, how can I make a select like?

SELECTED ANSWER

replied on September 10, 2018

To use your own custom select statments you will want to create a stored procedure in SQL. Then call the stored procedure from forms instead of a direct lookup to a table for view.

1 0

View 4 previous replies

replied on September 10, 2018

Hi Chad Saar, Thank you for your help.

Do you have a tuto? Or a doc?

0 0

replied on September 10, 2018

https://www.w3schools.com/sql/sql_stored_procedures.asp

0 0

replied on September 10, 2018

Hi Chad, ok understood but how do you call your procedure form LFForm?

0 0

replied on September 10, 2018

Change the selection from Table/View to procedure. Any new procedures,tables, or views will not show until you refresh the database connection from the admin tools.

0 0

replied on September 10, 2018

This is what I did but I still don't have the procedure... this is my procedure

/****** Script for SelectTopNRows command from SSMS  ******/
CREATE PROCEDURE myprocedure
AS

SELECT * 
  FROM [SP3E].[dbo].[produits]
  GO;

0 0

replied on September 10, 2018

Olivier,

After you add the stored procedure to the database, you need to go into Forms Administration and refresh the data source so it will pick up on the changes immediately.

0 0

replied on September 10, 2018

Chad, Jason

It's ok. I didn't save the procedure on the right table.

I got it thank very much.

0 0

Question

Question

Using Look-up Table, how can I make a select like?

Answer

Replies

Sign in to reply to this post.