>I'm trying to build a method in my bizobj that returns the primary key of a SQL table. The code below is what I'm using to call the sp_pkeys stored proc to get the info I need. The problem is that this returns no records back, even though I can execute the same command with the same parameters from Query Analyzer and get back the expected results. Can someone tell me what might be wrong with this code - or is there a better approach?
What does sp_pkeys stored proc do? Can you post the sproc code?
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com