Stored Procedures


New Member
I have a stored procedure available to update a status in my data source. Since that stored procedure is a table and connect allows one table per session, I’m looking for help with how I should set up on the desktop side.

I have orders in my source and those orders have statuses. The order info is in one table and the stored procedure to update the status of that order is in a different table.

Do I need two desktop sessions? One that takes in order data from the source, and a second that is connected to the status update SP. Should I make a grid within the status update session that pulls order data from the order data session?

This is a pick list app, I want to display the pick lists on the app and allow the user to update the order status from the app (without going to a new session) once they have picked the items for an order.