Is this possible in RR?

[Andre Garzia]

Paul,

Your app can be done in Rev. I would advise you to use some SQL 
database to store your data. You could use Valentina for your local 
solution and MySQL for your internet solution, since they both share 
the RevDB api, you build your code only once and just tell what DB your 
using when you open them.

I think you need SQL for you'll be cross searching data, and SQL is 
great at that, if you're using Arrays or XML, then you need to build 
your own cross searching routines and thats a science on it's own.

I know nothing of report producing in Rev, but I am learning much of 
the Rev net features features, so if you need any assistance on the 
net, I can try to help you. I would go like this.

On the application startup (not the handler but the time when it 
starts), I would check for net connection, it I've got net connection, 
then I would connect to main server and fetch data I need and push it 
inside the valentina local db, only after that I would allow the user 
to interact with the system. One trick part is synchronization. If 
you've got multiple connections using the same DB you must take care 
for them not to overwrite each other modfications. Imagine this 
scenario where:

1) Client A, fetches Data from main DB.
2) Client B, fetches Data from main DB.
3) They both fiddle with the Data and change same records.
4) Client A uploads back it's data.
5) Client B uploads back it's data.

In this hellish case, client A data modifications are lost due to 
client B overwrite. If all clients are working with the same tables and 
records accross the net, you must build your software in a way to 
prevent this from happening. MySQL got some locking mechanisms on it's 
own, I don't know how to use them, but someone here sure know and there 
are very good skilled DB programmers here and they will sure point you 
to the right location.

Andre


On Aug 15, 2004, at 10:43 PM, Paul wrote:

> Dear list,
> As a complete programming newbie, first I should say, that I'm glad to 
> be in a community that actually welcomes us newbies, even try to 
> attract us, thanks!!!.
> I haven't bought a Rev license yet as I'm not (100%) sure the 
> application I'm planning is possible in Revolution, so I have a few 
> questions that I hope someone will help with!!!
> The company I'm looking to design the application for, is a vertically 
> integrated cattle company, meaning they have breeding properties, 
> feedlots and an abattoir (slaughterhouse)
>
> Requirements
>
> 1.What I'm hoping to do is build a system where each of the breeding 
> properties can record enter cattle weight (and other) details,and have 
> the application work out an individual's daily weight gain and 
> forecast future weights.
>
> Question: These records would typically be over 5000 animals with 
> possibly 20 to 30 records each. Would I use a SQL database, XML, 
> Arrays, or cards to store the data? (sorry, I've still a lot to learn, 
> obviously!!!)
>
> 2.This info needs to be accessable over the web by the feedlot, so 
> that the manager can forecast his feed requirements well in advance of 
> the cattle arriving, similarly the slaughterhouse needs access so they 
> can 'forward sell' the resulting meat. They would also be inputting 
> weight and carcass and price data for feedback to the breeders. (who 
> also need access)
>
> 3. Web access can be flaky in the more remote areas, so I don't want a 
> typical 'web application', rather something more along the lines of 
> the excellent GoRevnet. That is, I would need the program to be able 
> to operate as a local application, then by clicking a button, connect 
> to a server, synchronise with the database, and upload 'new' 
> information and download 'new' information, automatically
>
> 4. The info would need to be segregated by password so that indiviual 
> breeders would only have access to their own info, but head office 
> would have access to everything. Similarly the feedlot could access 
> the breeder records but not slaughterhouse records.
>
> 5. It would also need some fairly flexible reporting functionality
>
> I know the first thing ppl will say is to 'try something less 
> complicated first and work up to a project like this', which is what I 
> will do, but although I think this can be done in Rev, I don't want to 
> buy a license, without knowing that it can eventually done.
> Thanks in advance
> Paul
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
-- 
Andre Alves Garzia ð 2004
Soap Dog Studios - BRAZIL
http://studio.soapdog.org