Search results for query: *

Hi, Not sure if I fully understood your question, but if the problem is that you can't find the data you want because your datagrid doesn't have primary key information, consider using a DataSet object if you're not already. If you are using DataSet, and you still don't have primary key info...

My company uses EnterpriseArchitect. We have reverse engineered a very large web-based application (several million lines of code) and were very impressed with the accuracy of the resulting diagrams. I'm not sure of the cost but I do know it was much cheaper than Rose. There is also a 30 day...

Thank you to both sunila7 and SQLSister. Your replies were extremely helpful, you have my appreciation. Phin

Edited to add a couple of things: In the SQL statement, I forgot the "fetch next" before the end loop. But either way, I do not seem to be able to create the view using the cursor. Any other ideas?? Thank you very much, Phin

Hi, I'm trying to create particular view to help me with some reporting. My main table looks like this: ID, DateUpdated, Status. Status can have a value of 1, 2, 3 or 4. I want to create a view that will show me what the state of the database was on each date. It should look like this...

IdoMillet: Thanks for the reply. Just want to be sure I got you clearly: For the saving of snapshot info (which I'm not currently doing) are you suggesting something like setting up a job in the db (MSSQL) to write the snapshot info to another table or db each day, from which I could get the...

Let me start by saying thanks once again to synapsevampire who answered my last question. Unfortunately, I'm back for more help on the same topic: My project has switched over to Crystal after I had everything the way I wanted it in Excel. It seemed so easy in Excel, now it seems impossible...

synapsvampire: Thank you for your response. I realize that what I described was a crosstab, I was using it to collect the data for my line chart. Is it adviseable to simply create the chart without the crosstab? As I said, I'm new to Crystal, and I was under the impression that the crosstab...

Hello, Please excuse my ignorance, I am completely new to Crystal. I did not seet this addressed in the FAQ area, so here goes: I'm trying to create a very simple line chart, showing the state of my data on each day over a period of time (say one month). Each record has a status, say...