Search results for query: *

I'm trying to display the contents of an ADODB.RecordSet object on a form - read only.<br><br>I've tried to use a DataGrid but can't figure out how to add rows to the grid.&nbsp;&nbsp;Columns.Add works to add all the fields, but I can't figure out how to insert.<br><br>I tried accessing a row...

<br>'**************************************************<br>' This script will install CPS COM components<br>' Be sure the Setup variables in this section<br>' are correct.<br>'<br>'<br>' Ed MacDonald<br>' <A...

I want to trap certain errors (e.g. unique constraint violations for insert) in my SQL procedures and handle them gracefully by returning a user defined error code to the caller.<br><br>Using @@Error lets me view the error code, but still upsets the client by raising a nasty exception.<br><br>In...

I would like to perform the equivalent of an MS Access cross tab query in SQL server 7 where the values of a chosen field become fields of the the result set.&nbsp;&nbsp;And I'd rather not use MS Jet as an intermediary.<br><br>I'm thinking there ought to be a stored proc floating around for this...

I'm creating a users table in my app and don't want the PK of the user to be predictable.&nbsp;&nbsp;I was thinking along the lines of the SID behind an NT user account.<br><br>This seems like a standard type of issue.&nbsp;&nbsp;Is there a standard approach?&nbsp;&nbsp;Anyone have an...

I would like to perform the equivalent of an MS Access cross tab query in SQL server 7 where the values of a chosen field become fields of the the result set.<br><br>Is this in anyone's bag 'o tricks?<br><br>Thanks,<br><br>Ed<br><br>

Is there a way to call a stored proc and reference the parameters by name instead of by position?<br>------<br>I am using the following syntax to add parameters to a command object that executes a SQL 7 stored proc:<br>&nbsp;&nbsp;&nbsp;<FONT FACE=monospace>cmd.Parameters.Append...