I figured it out. Easier than I thought. thanks, Angelo ________________________ Angelo Antonino Tanzanite Software Solutions M: 0403317772 E: [EMAIL PROTECTED] W: www.tanzanite.com.au
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Antonino Sent: Wednesday, October 19, 2005 10:40 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Stored Procedures - reading field values Hi, I have an ADP connected to SQL Server. I need to move a VBA process to a Stored Procedure (because it needs to activated by triggers). I'm trying to figure out how to read fields into variables all from within a stored procedure (SP). Rather than pass 7 variables to the SP (which will require some logic), I prefer to pass a record ID, and then have the SP retrieve the field values from the table. The field values are then used in some logic to update another table. >From the research I've done, I can't seem to find how to store field values into variables (from in a SP). Is this possible???? many thanks, Angelo Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
