Emily C Graham 7.Apr.08 06:07 AM a Web browser LC LSX LC LSX - All Releases Windows
I'm trying to learn how to use LC LSX in Domino after years of using the ODBC connector, as the little bits I've learned seem to have a big advantage in terms of performance. However, I'm finding the documentation which comes with Domino a little sparse for what I want to do, so my first question is can anyone suggest any good documentation which covers connecting to and manipulating Microsoft SQL-style databases?
My more specific question is this: I need to insert a row into a table in a MS SQL database and then read back the value which has been generated in the primary key column by the sql server itself so that I can use that value to go on and do something else. I've got the code for inserting the row (create an LCfieldList, use Append to define each column/LCField I am inserting and set the Value property for each LCField), but can't figure out a way of getting the value I need after the row has been created. Is this even possible without going back and doing a SELECT? I've tried creating an LCField in my field list for the primary key column as a placeholder, hoping that it would get automatically filled in when i perfom the Insert, but this throws an 'Invalid input parameter values' error.
As I said, I'm new to LC LSX so apologies if my terminology is incorrect.