Wednesday, March 21, 2012
Got rows that I can't get rid of
clean up it correctly in the code. So usually in this case I just go to DB
and clean it myself by hand and lean my lesson. But this time some records I
just can't delete - it tells me that record doesn't exists because it was
modified by other user ?
I restarted machine - didn't help.
Any ideas?
Thanks,
Shimon.How are you trying to delete?
Is There a Primary Key on this table?
The message you describe sounds like an ADO or ODBC message. Can you just
go to query analyzer and do a Select and see if the row is in the database?
"Shimon Sim" wrote:
> I was working with my DB. I wrote some unit test it failed and I didn't
> clean up it correctly in the code. So usually in this case I just go to DB
> and clean it myself by hand and lean my lesson. But this time some records
I
> just can't delete - it tells me that record doesn't exists because it was
> modified by other user ?
> I restarted machine - didn't help.
> Any ideas?
> Thanks,
> Shimon.
>
>|||I delete from VS.NET from the list of records.
Everytime I refresh the query it returns me that record exists. II try to
delete dependent connected (with foreign rel) records that tells me that I
can't because there are related records.
"CBretana" <cbretana@.areteIndNOSPAM.com> wrote in message
news:5EB2C616-36C0-4EAE-AFFD-C088258A8B9F@.microsoft.com...
> How are you trying to delete?
> Is There a Primary Key on this table?
> The message you describe sounds like an ADO or ODBC message. Can you just
> go to query analyzer and do a Select and see if the row is in the
> database?
> "Shimon Sim" wrote:
>|||Sorry for troubles - I just pulled up QA and queries work. I guess something
wrong with VS.
Thanks,
Shimon.
"CBretana" <cbretana@.areteIndNOSPAM.com> wrote in message
news:5EB2C616-36C0-4EAE-AFFD-C088258A8B9F@.microsoft.com...
> How are you trying to delete?
> Is There a Primary Key on this table?
> The message you describe sounds like an ADO or ODBC message. Can you just
> go to query analyzer and do a Select and see if the row is in the
> database?
> "Shimon Sim" wrote:
>
Friday, March 9, 2012
good matrix tutorial
Hello,
I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:
http://msdn2.microsoft.com/en-us/library/ms157334.aspx
Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.
With regard to your Out of Memory error... how many rows are being returned from your DataSet?
If you have any specific questions, feel free to post them here.
-Chris
|||I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.
I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).
Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.
good matrix tutorial
Hello,
I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:
http://msdn2.microsoft.com/en-us/library/ms157334.aspx
Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.
With regard to your Out of Memory error... how many rows are being returned from your DataSet?
If you have any specific questions, feel free to post them here.
-Chris
|||I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.
I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).
Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.