Stored Procedure as Form Record source (1 Viewer)

1DMF

Registered User.
Local time
Today, 15:55
Joined
Oct 20, 2011
Messages
14
How do I set my stored procedure as the record source to a form?

Where is my stored procedure listed so I can select it as the source?

Thanks,

1DMF.
 

1DMF

Registered User.
Local time
Today, 15:55
Joined
Oct 20, 2011
Messages
14
ok, found you need to create a passthrough query with an embeded connection string.

In the query you write
Code:
EXEC sp_stored_procedure

And then it will grind your application to a halt, even just trying to navigate around in 'develop' mode will have your db locking up, egg timing and basically stopping you from being able to work.

I don't understand, i was told SP's were fast and much better, why has it killed my application?
 

Users who are viewing this thread

Top Bottom