Recent content by EdMacDonald

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