Project...

[karim]

Hi All,
I am working on a project to develop a live form on the network.
Basically it's for comunications between the depts. What I'm trying to do is
have a form to enter what the depts. are producing now and a sub form that
would display the info. after it's been entered. it did work fine when I go
from the main form to the sub form, but then when I go back the the main form
to update info, it crashes.

I used stream reader in the sub form to display the info and stream writer
for the main form to enter info.

so the problem or question is can I have a file .txt on the network that
would be avaliable to more than one form and allow changes.

so, if we are producing product xx and it's showing on the sub form that is
reading the file on the network, can I use the main form from another
computer to update the product to xyx and save. Then I was thinking about
having the subform refresh every minute to update the info. but I tried this
and the refresh did not help either.

Any help or ideas that would make this work would be greatly appreciated...

Thanks.

 

[Patrice]

Hello,

"crashes" is not enough. Please never talk about an error without telling
the exact error message you get as this is your first diagnosis tool. From
your description my guess is that the file is locked.

I'm not sure how is your overall architecture (you don't have a DB to store
product info ?) but knowing if you are using a file for each product (?) ,
how much frequently is is supposed to change, what exactly changes.

For example when you order a product, you usually wen to check the stock. A
usual way to handle this is that when the change is commited, you check that
the value displayed to the user is still current. This way :
- you never need to refresh anything avoiding to disturbing a user while he
is entering something
- users will only see something to warn them when someone else ordered the
same product between the display of the product form and the actual
ordering...

 

[Simon Whale]

As far as i can tell from your description you would end up with locked file
issues.

why not use sql express? and install in a centeral location?

Simon