MyGeneration Support

On line 705(ish, I've added some debugging code) of BusinessEntity.vb : Adapter.Update(_dataTable) I get a null reference exception. After looking a bit deeper I see the problem is that Adapter.InsertCommand isn't set and produced an exception message of \"Unable to cast object of type...

So I added mono.security as a reference and it took care of that problem, despite never having to do that before. Now it's a new one. ON a MyClass.Save() line I get this : System.NullReferenceException was unhandled Message=\"Object reference not set to an instance of an object.\"...

I'm trying to get d00dads working with PostgreSQL but on my call to MyObject.AddNew() I'm getting a puzzling error : ystem.IO.FileNotFoundException was unhandled Message=\"Could not load file or assembly 'Mono.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' o...

I just ran into this myself when converting a project to .NET 2.0 - any words of wisdom?

VERY cool how you can do that. The entire project was switching over in just a few hours (and it only took that long because I was fussing with Access!).

Thanks Mike!

Of course it was because when I recompiled MyGen to include the OLE adapters I didn't update the reference in the project. Doh!

After having some disappointing bugs surface in VistaDB I'm thinking about taking my latest application to Access. It seems to offer all of what I need in a single-file database structure so I'm going to give it a go. The only problem is that I've designed the entire application around the VistaD...

The man as always Mike - THANKS!

Well, it's a bit more complicated than the subject says. I'm offering a template editor which is really just an report designer. The problem is that I need the datatable structures from my customer object so that the user can have the proper data fields to bind to. If I could load a customer that wo...

After going back to VistaDB 2.1.1 the problem mysteriously disappears.... I've reported this to VistaDB but since I can't send this project to them I doubt they'll do much testing with it. I think I remember you saying that you knew some of the developers over there so if you could, please bend thei...

One thing I noticed just now is that the 1.1.5.1 version of MyGen reports itself to be 1.1.5.0 in the About box. Download.com is serving up mygenv115.exe - so I'm not sure if the version number is just off or if that is the .0 version.. I don't know that it has anything to do with my issue but it...

Well, I wanted to ask just in case I was missing something. I'm scurrying around trying to figure out what the heck broke and seeing \"VistaDB 2.0.16\" in the About dialog of MyGen was the first thought that crossed my mind.

Thanks Mike - I'll continue looking!

A new one in a different part : Unhandled Exception: VistaDB.VistaDBException: Error code: 610 OpenSQL: Access violation at address 04832440 in module 'VistaDb20.dll'. Read of address 049CB2CC Crazy, though, since I just realized that I was already using VistaDB 2.1 for a while, I just mo...

I upgraded to the latest VistaDB a few minutes ago and wow - lots of broken d00dads! An unhandled exception of type 'VistaDB.VistaDBException' occurred in mygeneration.doodads.dll Additional information: Error code: 610 OpenSQL: Invalid pointer operation Unhandled Exception: VistaDB.VistaDBE...

Yea, you're right. I'll just re-do the thing and use LoadFromRawSQL instead. More powerful in the long run!

Thanks Mike!

Mike, obviously you have some insight as you've already partially answered my newest question.. I just realized that users will want to search on the same field more than once (and they would for certain since I've thought about not adding that). You suggested using LoadFromRawSQL. Is that becaus...

Ok, one more question then I promise to leave you alone :-) Do I add the newly created where parameter like this : ? _TheInvoiceList.Query.AddWhereParemeter(MyWhere1) Because this is the SQL it's generating and I'm getting a \"parameter not found\" error, which makes sen...

That was it! It was an issue of case.

Thanks Mike, awesome support as always!

Oh yes, the method is in the concrete class. I'm using your exact code, copy and pasted. Calling it like this : Dim MyWhere1 As MyGeneration.dOOdads.WhereParameter = _TheInvoiceList.GetWhereParameter(WhereParam1) WhereParam1 is a string representing the column name. ...

I just copy/pasted your code and still get the NullRef Exception on : Dim MyWhere As WhereParameter = CType(PropInfo.GetGetMethod(True).Invoke(Me.Where, Nothing), WhereParameter) So I'm obviously not doing something right! I am calling AddResultColumn...