Firstly, congratulation to the release of 1.6.1



Just got done installing 1.6.1 on Win2K machine. Everything went through fine.

Now as soon as I try to open any solution (including C# samples), I get the message the VS has encounter error and if I click "Don't Send" it closes VS and re-opens VS.



I rebooted the machine but no luck!



I also tried opening VB samples, same thing!



Thanks!

..ßen

OK guys....sorry for thetrouble.  I am working on thisight now.  I think a last minute change is causing the prblem. 

No sweat!

..ßen

Simple fix....simple problem Attached is a ZIP file that contains two assemblies.  Follow the steps below once the ZIP file has been extracted to your local machine.

1. Close Visual Studio
2. Drag the two MicroFour DLLs into c:\Windows\Assembly (GAC)
3. Re-open Visual Studio

That's it   Those darned last minute changes .... I knew better

... and I thought I would have a good excuse not to work this weekend!

LOL...sorry

Works great! Thanks...

..ßen

You Work???



Hey Ivan, I connected to your server last night. When are you going to change that 286 server to a 386. I have one 386 from 1985, if you want...

..ßen

Only on weekends...

Nah, no need for that. The software is so good that we thought of putting it on a PC XT, but then most of my games wouldn't run on an XT, so the 286 got in action...   (you very funny)

I haven't noticed any speed issues with the Brazilian database.  It sucked down 500 records in less than 2 seconds from my crummy internet connection at my house....I was impressed!

I'm just busting his chops. I know, I did some edit/save and you can't tell it's not local.



Trent, let me ask you something. Let's say I have to change the salesrep (foreign key) of 500 customer, and if I use transaction, will each customer "change" to remote server happen individually or do they get packaged up as on large transaction from client and then sent to the SE for processing?



Thanks!

..ßen

There are a couple of ways that you might do this. The first would be to loop through a BO and update each rep. I think the only transaction support you'd get would be for each individual update. However, this is almost always a bad idea.



The better way is to use a sql statement, which is usually infinitely faster and the entire change can be wrapped in a transaction. For this method to work, you'd need to be able to select the 500 customers that need changing some how, via sql. I.e. they all had another rep and now need a different one or maybe they are in certain zip codes and need to be assigned to a rep. The update is then trivial:







Now, where do you execute this sql. There are two main options: call a sproc that does this work, or execute the sql directly. In either case, I'd likely create a method on the customer BO and pass it the new repid and the old rep ID (or whatever data is needed to select the reps to update) and execute the sproc/sql using the ExecuteNonQuery() method. Then you could wrap this single statement into a transaction (still within the BO method). The transaction is thus the updating of ALL the customers (only a single sql statement). All the logic is encapsulated within the BO, the server does the work, life is good This works the same with or without SE.



This will be VERY fast (assuming appropriate indexes on the fields used in the where clause), compared to handling each customer on the client side individually (each update will be a call to the database...500 customers, 500 calls). If you are updating a gagillion customers, you can do it asynch, no problem...the work is actually being done on the server (assuming the server isn't on the same machine).



Hope this makes sense.

It takes 8-14 secs to retrieve 500 records at Malaysia

Ivan,

if you set up your server as PC XT, make sure it is 8086 AND has a math coprocessor installed -- much speedier that way.  Oh, and a 40MB drive would be nice, too, for enough storage for a lifetime (or so we thought back in 1985).

Pertti

I think the one that he has, is the 8088 with Seagate 20Meg full height. He is not so happy to give up his second 5 1/4 floppy drive, which he could store 320KB of data...

..ßen

Ivan has a server we can hack...er...mess with?

Trent, I downloaded the zip file and found the two dll's ok. However, the C:\windows\assembly folder on my system is protected and I am unable to drag the two files there. Looking at the folder there are no .dll files in it anyway. I did find microfour dll files in C:\ProgramFiles/CommonFiles/MicroFour/StrataFrame and I copied them there but no joy... SV still closes when I try to open a solution.



Robert

Have you tried to unhide protected operating system files?



In XP:

- In windows explorer, Tools|Folder Options...

- click on the "View" tab

- expand the Files And Folders node if it isn't already

- Uncheck the "Hide protected operating system files (Recommended)" option

- Click OK



See if that works.

Robert:

You can manually install the assemblies with gacutil....or just download the new install that is posted in the My Account area and it will take care of it.  To install with gacutil you will use the "-i" parameter.  The easiest thing though if you are not familiar with the command line tools and have permission issues is to just download the latest build....which was corrected the same time the zip file was posted out here...and it will fix your problem as well.

Correct.  The GAC always takes precedence.  Anytime that an assembly tries to load it ALWAYS looks in the GAC first....even if you manually call Assembly.LoadFile() and give it the direct path of an assembly.