Search results for query: *

Thanks,<br><br>I've already written a VB cross-tab function for my data access module, but I'll try to get a look at the book too.<br><br>Ed

I managed to do it with the FlexGrid instead, by looping through all fields of all records and setting .text property.&nbsp;&nbsp;There's gotta be a better way.<br><br>Is there a way to bind the flexGrid to a <i>disconnected</i> ADO Recordset, so that modifications in the grid are reflected in...

Try something like this:<br><FONT FACE=monospace><br>&nbsp;&nbsp;&nbsp;&nbsp;rsSchema = conn.OpenSchema(adSchemaTables)<br>&nbsp;&nbsp;&nbsp;&nbsp;Do While Not rsSchema.EOF<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If rsSchema.Fields(&quot;TABLE_TYPE&quot;) = &quot;TABLE&quot...

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...

It's for a web based enterprise application so Excel is not an option.<br><br>I could stick JET in the middle, by creating an Access DB with a linked table, but that's kind of hokey.<br><br>I'll probably do it the hard way by manipulating ADO recordsets in VB in the middle tier.<br><br>Ed

If you want to post your code, errors, and a lot more detail, we'll have a look.&nbsp;&nbsp;There is something missing from the story that we're not getting here.<br><br>Ed<br><br>

Try:<br>&quot;Select * From Grocerys Where Description Like 'b%' Order By Description&quot;<br><br>The &quot;*&quot; character will not work in any of the &quot;real&quot; DBMS systems as a you have used it.&nbsp;&nbsp;The &quot;%&quot; character is the proper wildcard.&nbsp;&nbsp;The double...

<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'll post a script for you in a new thread as a &quot;helpful tip&quot;<br><br>Ed

<br>Select ...<br>Where logTime BETWEEN '20000403' AND '20000410'<br>And DATEPART(hh,logTime) BETWEEN 15 AND 23<br><br>You'll have to fool with your date format but this should be what you are looking for.

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...

Thanks,<br><br>I ran across that over the weekend.&nbsp;&nbsp;I feel kinda silly that it was right there staring me in face :-o

Did you actually install Access on your server?<br>Are you running IIS 4 or later?

If you are accessing the DB from ASP, then MS Jet is probably the data provider.&nbsp;&nbsp;You should make sure your server has the latest drivers because TOP does work with ASP/Jet/Access as posted here.<br><br>Ed

What I really want to do is the equivalent of:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;<FONT FACE=monospace>execute myStoredProc @p2='val2', @p1='val1'</font><br>or<br>&nbsp;&nbsp;&nbsp;&nbsp;<FONT FACE=monospace>myVBfunction p1:='val1', p2:='val2'</font><br><br>When working with a DB person, I'd rather...

Since it looks like you're using VB and maybe ADO, You could avoid the whole mess if you can use stored procs.&nbsp;&nbsp;And it will be much faster having a pre-compiled execution plan.<br><FONT FACE=monospace><br>&nbsp;&nbsp;&nbsp;&nbsp;CREATE PROCEDURE myStoredProc_p...

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...