Home » Developer & Programmer » Forms » big problem face me
big problem face me [message #290034] Thu, 27 December 2007 03:48 Go to next message
mohamed99
Messages: 8
Registered: December 2007
Location: united arab emirates
Junior Member

Dear Friends,

now i desigin to do one project for barcode system ,i complete my desigin here but i have one problem facing me this problem is Updation (how can i do updation to our branches and we have 11 branches and decide to do updatiion for all branches offline ,please desccribe how can i solve this problem....???
Re: big problem face me [message #290039 is a reply to message #290034] Thu, 27 December 2007 03:55 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
All I can say is that I didn't understand what you are talking about. What branches? What is "offline update for all branches"? Where does barcode come into the story?

Could you explain it once again, but this time try to use proper punctuation (so that we could see where a sentence begins and where it ends), perhaps even create a simple example.
Re: big problem face me [message #290122 is a reply to message #290039] Thu, 27 December 2007 10:12 Go to previous messageGo to next message
mohamed99
Messages: 8
Registered: December 2007
Location: united arab emirates
Junior Member

Dear Littlefoot,
i am very sorry to that sentence is not clear, i want say i complete design for barcode system in my company . and the company it have 11 point of sale in different area and must be take daily sales report from this point of sales and i want to take my sales daily offline without join to internet by (PC Anywhere ) can you describe way how can i get this.... please replay for me


Thanks
Re: big problem face me [message #290125 is a reply to message #290122] Thu, 27 December 2007 10:29 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, the main problem is how to get data from remote areas to your place. Right?

Does it mean that every point of sale runs its own Oracle database? How do you communicate with them? Dial-up, not at all, or something different?

As I understood it, there's no connection between you and those 11 POSes. The only way I can think of is to make an export of desired tables and mail them to you. If your database version supports it, you might try with a conditional export (using the WHERE clause, for example EXP un/pw@db tables=sale query="where date_column > trunc(sysdate)"). Once you have those exports, import them into your database and run the report.

On the other hand, if there IS a connection there, you might create materialized views which would refresh periodically (or on demand) and get data to you. Or, you might even directly access data via a database link.
Re: big problem face me [message #290502 is a reply to message #290125] Sat, 29 December 2007 03:15 Go to previous message
mohamed99
Messages: 8
Registered: December 2007
Location: united arab emirates
Junior Member

Dear Littlefoot,
Thank you very much about this information and i hope to help you later....
Thanks
Previous Topic: getting message for every record while pressing down arrow
Next Topic: How to Create Both Vertical & Horizontal Scrollbars for a data block
Goto Forum:
  


Current Time: Fri Dec 09 01:57:51 CST 2016

Total time taken to generate the page: 0.09466 seconds