Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1824 > unrolled thread
| Started by | dlzc <dlzc1@cox.net> |
|---|---|
| First post | 2011-08-16 11:58 -0700 |
| Last post | 2011-08-18 16:11 +0100 |
| Articles | 15 — 8 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by
below is the oldest one visible, not the original post.
Re: Attention Clipper Programmers dlzc <dlzc1@cox.net> - 2011-08-16 11:58 -0700
Re: Attention Clipper Programmers Joe Wright <joewwright@comcast.net> - 2011-08-16 16:46 -0400
Re: Attention Clipper Programmers dlzc <dlzc1@cox.net> - 2011-08-16 14:36 -0700
Re: Attention Clipper Programmers Joe Wright <joewwright@comcast.net> - 2011-08-16 21:46 -0400
Re: Attention Clipper Programmers dlzc <dlzc1@cox.net> - 2011-08-16 21:30 -0700
Re: Attention Clipper Programmers Johan Nel <johan.nel@xsinet.co.za> - 2011-08-17 03:36 -0700
Re: Attention Clipper Programmers Joe Wright <joewwright@comcast.net> - 2011-08-17 07:03 -0400
Re: Attention Clipper Programmers Navin Mehta <navinmehta@gmail.com> - 2011-08-17 07:28 -0700
Re: Attention Clipper Programmers Navin Mehta <navinmehta@gmail.com> - 2011-08-17 08:53 -0700
Re: Attention Clipper Programmers dlzc <dlzc1@cox.net> - 2011-08-17 10:13 -0700
Re: Attention Clipper Programmers Navin Mehta <navinmehta@gmail.com> - 2011-08-18 06:38 -0700
Re: Attention Clipper Programmers Mike Pitcher <mike_no_spam_please_@pamuk.demon.co.uk> - 2011-08-17 08:51 -0700
Re: Attention Clipper Programmers pete@nospam.demon.co.uk - 2011-08-17 04:31 +0000
Moving from xBase to SQL "Jayadev" <Jayadevu_@_rediffmail.com> - 2011-08-17 11:27 +0530
Re: Attention Clipper Programmers Martin <spam@spam.spam> - 2011-08-18 16:11 +0100
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-08-16 11:58 -0700 |
| Subject | Re: Attention Clipper Programmers |
| Message-ID | <417b66b3-94e8-45f8-bea5-76a7de986ab7@w22g2000prj.googlegroups.com> |
Dear John Ward: On Aug 16, 9:07 am, John Ward <net4w...@gmail.com> wrote: > Is there a recommended resource to find legacy > Clipper Programmers/Consultants? Some knock around here. Some have migrated to Clipper Visual-Objects, (x)Harbour, and more. > Over 3 years ago I supported a slew of legacy > Clipper apps, most of which have been migrated > off to other platforms. I moved out of > development into QA. Our single Clipper > Consultant resource supporting the remaining > legacy application is leaving the company. > There is no way I am getting pulled back into > supporting the application (though I am sure I > will "have to" support it until a new resource > is identified). You *know* it won't end then. You will still be questioned as to why something was done a certain way, or the like. > Our offshore resources are currently not able > to and have yet to locate a Clipper programmer > and are hopefully going to find training (which > I am sure is non-existant). Mostly correct. There are still some training materials available for Clipper, but they may have to look in used bookshops. Certainly the Norton Guides for Clipper are online now... > These are Clipper 5.01/5.2 apps we are > maintaining. No plans to upgrade - other than > migrate the data to another system (if that ever > happens). Once that decision is made... With small revisions to code, you can usually migrate into Harbour / xHarbour with minimal changes if the code does not rely on 3rd party applications. From there it is a small step to SQL, and probably then into some other language (that you can get support for). > We are large financial services company in the > NorthEast USA, just outside of Philadelphia. We > are looking for a part-time Clipper consultant. I'm in the wrong end of the country. I have added two other apporpriate newsgroups to your post. David A. Smith
[toc] | [next] | [standalone]
| From | Joe Wright <joewwright@comcast.net> |
|---|---|
| Date | 2011-08-16 16:46 -0400 |
| Message-ID | <XdGdne1UG7-GStfTnZ2dnUVZ_tCdnZ2d@giganews.com> |
| In reply to | #1824 |
On 8/16/2011 14:58, dlzc wrote: > Dear John Ward: > > On Aug 16, 9:07 am, John Ward<net4w...@gmail.com> wrote: >> Is there a recommended resource to find legacy >> Clipper Programmers/Consultants? > > Some knock around here. Some have migrated to Clipper Visual-Objects, > (x)Harbour, and more. > >> Over 3 years ago I supported a slew of legacy >> Clipper apps, most of which have been migrated >> off to other platforms. I moved out of >> development into QA. Our single Clipper >> Consultant resource supporting the remaining >> legacy application is leaving the company. >> There is no way I am getting pulled back into >> supporting the application (though I am sure I >> will "have to" support it until a new resource >> is identified). > > You *know* it won't end then. You will still be questioned as to why > something was done a certain way, or the like. > >> Our offshore resources are currently not able >> to and have yet to locate a Clipper programmer >> and are hopefully going to find training (which >> I am sure is non-existant). > > Mostly correct. There are still some training materials available for > Clipper, but they may have to look in used bookshops. Certainly the > Norton Guides for Clipper are online now... > >> These are Clipper 5.01/5.2 apps we are >> maintaining. No plans to upgrade - other than >> migrate the data to another system (if that ever >> happens). > > Once that decision is made... > > With small revisions to code, you can usually migrate into Harbour / > xHarbour with minimal changes if the code does not rely on 3rd party > applications. From there it is a small step to SQL, and probably then > into some other language (that you can get support for). > >> We are large financial services company in the >> NorthEast USA, just outside of Philadelphia. We >> are looking for a part-time Clipper consultant. > > I'm in the wrong end of the country. I have added two other > apporpriate newsgroups to your post. > > David A. Smith Hi David Can you expand on the "small step to SQL" thing? I'm facing a massive xBASE to SQL move and I don't have a clue. TIA -- Joe Wright "If you rob Peter to pay Paul you can depend on the support of Paul."
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-08-16 14:36 -0700 |
| Message-ID | <3cca4449-dec5-495a-8c59-654d39c16e9c@o9g2000vbo.googlegroups.com> |
| In reply to | #1825 |
Dear Joe Wright On Aug 16, 1:46 pm, Joe Wright <joewwri...@comcast.net> wrote: > On 8/16/2011 14:58, dlzc wrote: ... > > Once that decision is made... > > > With small revisions to code, you can usually > > migrate into Harbour / xHarbour with minimal > > changes if the code does not rely on 3rd party > > applications. From there it is a small step > > to SQL, and probably then into some other > > language (that you can get support for). ... > Can you expand on the "small step to SQL" thing? > I'm facing a massive xBASE to SQL move and I > don't have a clue. A couple of ways to do this: #1 you could just move to ADS which is SQL-like, low entry fee, but another major blow to get to full SQL, or #2 SQLRDD http://www.xharbour.com/products/addons.php ... which will let you use SQL with minimal changes, then optimize to productive and SQL-efficent code as it is running. As I understand it. David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | Joe Wright <joewwright@comcast.net> |
|---|---|
| Date | 2011-08-16 21:46 -0400 |
| Message-ID | <qLCdnby9ZrnpgNbTnZ2dnUVZ_tidnZ2d@giganews.com> |
| In reply to | #1826 |
On 8/16/2011 17:36, dlzc wrote: > Dear Joe Wright > > On Aug 16, 1:46 pm, Joe Wright<joewwri...@comcast.net> wrote: >> On 8/16/2011 14:58, dlzc wrote: > ... [ snip ] > ... >> Can you expand on the "small step to SQL" thing? >> I'm facing a massive xBASE to SQL move and I >> don't have a clue. > > A couple of ways to do this: > #1 you could just move to ADS which is SQL-like, low entry fee, but > another major blow to get to full SQL, or > #2 SQLRDD > http://www.xharbour.com/products/addons.php > ... which will let you use SQL with minimal changes, then optimize to > productive and SQL-efficent code as it is running. As I understand > it. > > David A. Smith I am tasked with moving twelve years of work with Clipper, FoxPro and xHarbour to VB.NET and SQL Server. I had a four-day introduction course to .NET a couple of months ago. Where to start? -- Joe Wright "If you rob Peter to pay Paul you can depend on the support of Paul."
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-08-16 21:30 -0700 |
| Message-ID | <0915d308-0d8e-4e68-9732-9cb48acc96ad@bl1g2000vbb.googlegroups.com> |
| In reply to | #1827 |
Dear Joe Wright: On Aug 16, 6:46 pm, Joe Wright <joewwri...@comcast.net> wrote: > On 8/16/2011 17:36, dlzc wrote: > > On Aug 16, 1:46 pm, Joe Wright<joewwri...@comcast.net> wrote: > >> On 8/16/2011 14:58, dlzc wrote: > > ... > [ snip ] > > ... > >> Can you expand on the "small step to SQL" thing? > >> I'm facing a massive xBASE to SQL move and I > >> don't have a clue. > > > A couple of ways to do this: > > #1 you could just move to ADS which is SQL-like, low > > entry fee, but another major blow to get to full SQL, or > > #2 SQLRDD > >http://www.xharbour.com/products/addons.php > > ... which will let you use SQL with minimal changes, then > > optimize to productive and SQL-efficent code as it is > > running. As I understand it. > > I am tasked with moving twelve years of work with Clipper, > FoxPro and xHarbour to VB.NET and SQL Server. I had a > four-day introduction course to .NET a couple of months > ago. Where to start? First, stay away form copious amounts of alcohol or handguns. Next, capture the business logic, comb it out of the code. Last, turn the project over to pros, and you lead the team. I am not a pro. There is someone on the c.l.Clipper.Visual-Objects newsgroup that is really good at .NET. Hopefully they will chime in... David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-08-17 03:36 -0700 |
| Message-ID | <2145844f-b282-4267-8fb7-b27090f3feae@p19g2000yqa.googlegroups.com> |
| In reply to | #1828 |
Hi Joe, Would not say I am an expert, but have been a Clipper S87, 5.0-5.3 developer, then moved onto VO and now for last 3 years using Vulcan.NET. Just my few cents: 1. Moving to .NET will be a great effort since you need to rewrite most of your UI and data interfaces. 2. It might be a good idea to look at Vulcan for your business logic, since most (99%+) of the code will run with some tweaking e.g. typed variables etc straight from Clipper. You might want to look at OO'ing your code though in this step, but it will be the smallest component of your conversion from my experience. 3. Again, depending the programming style followed encapsulating into classes for re-usability would be the way I would go. Some work that I did in streamlining my processes. 1. Create base classes in .NET that you can inherit from that does all of the "standard" work normally found e.g. on Forms View/Update/ Insert/Delete. 2. Re-use of code with generic methods that might automate some of the "business specific" features in a generic way. 3. Use some standards of how you do your databinding between database and controls. 4. Another big one might be that you would like to relook the database design moving DBF to SQL. My experience was that a lot of "Clipper/VO DBF" code was not necessary anymore since I could implement with referential integrity straight in the DB and also lots done with triggers. Although the above might be easier said than done, I followed even in the Clipper days this generic approach of base "Functions" and by creating a class in VO I was able to quite quickly move my code from Clipper to VO, same happened from VO to Vulcan although it was less of an effort. Hope this give some ideas. Regards, Johan Nel Pretoria, South Africa. > > First, stay away form copious amounts of alcohol or handguns. > > Next, capture the business logic, comb it out of the code. > > Last, turn the project over to pros, and you lead the team. I am not > a pro. There is someone on the c.l.Clipper.Visual-Objects newsgroup > that is really good at .NET. Hopefully they will chime in... > > David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | Joe Wright <joewwright@comcast.net> |
|---|---|
| Date | 2011-08-17 07:03 -0400 |
| Message-ID | <JIKdnQjn8eeNPdbTnZ2dnUVZ_vidnZ2d@giganews.com> |
| In reply to | #1831 |
On 8/17/2011 06:36, Johan Nel wrote: > Hi Joe, > > Would not say I am an expert, but have been a Clipper S87, 5.0-5.3 > developer, then moved onto VO and now for last 3 years using > Vulcan.NET. > > Just my few cents: > > 1. Moving to .NET will be a great effort since you need to rewrite > most of your UI and data interfaces. > 2. It might be a good idea to look at Vulcan for your business logic, > since most (99%+) of the code will run with some tweaking e.g. typed > variables etc straight from Clipper. You might want to look at OO'ing > your code though in this step, but it will be the smallest component > of your conversion from my experience. > 3. Again, depending the programming style followed encapsulating into > classes for re-usability would be the way I would go. > > Some work that I did in streamlining my processes. > > 1. Create base classes in .NET that you can inherit from that does > all of the "standard" work normally found e.g. on Forms View/Update/ > Insert/Delete. > 2. Re-use of code with generic methods that might automate some of > the "business specific" features in a generic way. > 3. Use some standards of how you do your databinding between database > and controls. > 4. Another big one might be that you would like to relook the > database design moving DBF to SQL. My experience was that a lot of > "Clipper/VO DBF" code was not necessary anymore since I could > implement with referential integrity straight in the DB and also lots > done with triggers. > > Although the above might be easier said than done, I followed even in > the Clipper days this generic approach of base "Functions" and by > creating a class in VO I was able to quite quickly move my code from > Clipper to VO, same happened from VO to Vulcan although it was less of > an effort. > > Hope this give some ideas. > > Regards, > > Johan Nel > Pretoria, South Africa. > >> >> First, stay away form copious amounts of alcohol or handguns. >> >> Next, capture the business logic, comb it out of the code. >> >> Last, turn the project over to pros, and you lead the team. I am not >> a pro. There is someone on the c.l.Clipper.Visual-Objects newsgroup >> that is really good at .NET. Hopefully they will chime in... >> >> David A. Smith > Thanks Johan, and you David, for the good advice. I'm sure I'll be back. -- Joe Wright "If you rob Peter to pay Paul you can depend on the support of Paul."
[toc] | [prev] | [next] | [standalone]
| From | Navin Mehta <navinmehta@gmail.com> |
|---|---|
| Date | 2011-08-17 07:28 -0700 |
| Message-ID | <a40d6726-8086-47ca-b21f-fd38b06b0477@h14g2000yqd.googlegroups.com> |
| In reply to | #1832 |
Dear John Ward, I have done some large projects in Clipper using clipper 5.1 and 5.2. I live in Toronto Canada If you need my services, please contact me at mainmod@gmx.com
[toc] | [prev] | [next] | [standalone]
| From | Navin Mehta <navinmehta@gmail.com> |
|---|---|
| Date | 2011-08-17 08:53 -0700 |
| Message-ID | <2c8da397-8408-419a-9185-c1e95e694a71@bl1g2000vbb.googlegroups.com> |
| In reply to | #1833 |
On Aug 17, 10:28 am, Navin Mehta <navinme...@gmail.com> wrote: > Dear John Ward, > I have done some large projects in Clipper using clipper 5.1 and 5.2. > I live in Toronto Canada > If you need my services, please contact me at > main...@gmx.com Apparently the email address is not allowed in this forum. Add the "mod" after "main"
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-08-17 10:13 -0700 |
| Message-ID | <bddfd2bf-61e5-4d5a-99e7-2c2feef31854@gz5g2000vbb.googlegroups.com> |
| In reply to | #1835 |
Dear Navin Mehta: On Aug 17, 8:53 am, Navin Mehta <navinme...@gmail.com> wrote: > On Aug 17, 10:28 am, Navin Mehta <navinme...@gmail.com> wrote: > > > Dear John Ward, > > I have done some large projects in Clipper using > > clipper 5.1 and 5.2. I live in Toronto Canada > > If you need my services, please contact me at > > main...@gmx.com > > Apparently the email address is not allowed in this > forum. Add the "mod" after "main" Google.Groups "munges" display of email addresses in an attempt to protect you from spam. As if spammers would manually copy an email address out of a Google.Groups message display. If someone wants to see your email address, they can click on the "elipsis" (the three dots that G.G places over the last three characters), validates that they are not a bot by entering the charactes displayed, and the valid email address is displayed. David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | Navin Mehta <navinmehta@gmail.com> |
|---|---|
| Date | 2011-08-18 06:38 -0700 |
| Message-ID | <eb65b9d9-5812-4e45-8de3-d55c6c5f8c92@o11g2000yql.googlegroups.com> |
| In reply to | #1840 |
> > Apparently the email address is not allowed in this > > forum. Add the "mod" after "main" > > Google.Groups "munges" display of email addresses in an attempt to > protect you from spam. As if spammers would manually copy an email > address out of a Google.Groups message display. > > If someone wants to see your email address, they can click on the > "elipsis" (the three dots that G.G places over the last three > characters), validates that they are not a bot by entering the > charactes displayed, and the valid email address is displayed. > > David A. Smith Thanks for the explanation.
[toc] | [prev] | [next] | [standalone]
| From | Mike Pitcher <mike_no_spam_please_@pamuk.demon.co.uk> |
|---|---|
| Date | 2011-08-17 08:51 -0700 |
| Message-ID | <8d851478-8c0c-4308-9e0a-53b97eebdce2@a27g2000yqc.googlegroups.com> |
| In reply to | #1833 |
John ... There is some very good advice above. However I would strongly advise you to understand what SQL Server can do for you before you start worrying about the conversion. Many people use Geoff Schaller's SQLMaster (which incidentally is a superb and free product) to convert their DBFs to SQL tables. But that is as far as they go. If you plan how you can use referential integrity, stored procedures, views, triggers and the immensely powerful and free SQL Server Reporting Services particularly in 2008 R2 you will often find that much if not most of the Clipper code can be thrown away. If you get really brave and use Entity Framework Code First together with LINQ (which works as well with VB as it does with c#) you'll wonder why you bothered to retain any Clipper code! Bite the bullet, learn about SQL and .NET, then try a simple conversion to your target environment. Then decide how much Clipper help you need. HTH Mike
[toc] | [prev] | [next] | [standalone]
| From | pete@nospam.demon.co.uk |
|---|---|
| Date | 2011-08-17 04:31 +0000 |
| Message-ID | <1313555519snz@nospam.demon.co.uk> |
| In reply to | #1826 |
In article <3cca4449-dec5-495a-8c59-654d39c16e9c@o9g2000vbo.googlegroups.com>
dlzc1@cox.net "dlzc" writes:
> Dear Joe Wright
>
> On Aug 16, 1:46 pm, Joe Wright <joewwri...@comcast.net> wrote:
> > On 8/16/2011 14:58, dlzc wrote:
> ...
> > > Once that decision is made...
> >
> > > With small revisions to code, you can usually
> > > migrate into Harbour / xHarbour with minimal
> > > changes if the code does not rely on 3rd party
> > > applications. From there it is a small step
> > > to SQL, and probably then into some other
> > > language (that you can get support for).
> ...
> > Can you expand on the "small step to SQL" thing?
> > I'm facing a massive xBASE to SQL move and I
> > don't have a clue.
>
> A couple of ways to do this:
> #1 you could just move to ADS which is SQL-like, low entry fee, but
> another major blow to get to full SQL, or
> #2 SQLRDD
> http://www.xharbour.com/products/addons.php
> ... which will let you use SQL with minimal changes, then optimize to
> productive and SQL-efficent code as it is running. As I understand
> it.
>
> David A. Smith
There is another way (and maybe many more) if you are comfortable
using SQL:
#3 Write a small Clipper prog (or series of progs) to create a SQL
script containing your DBF data to be inserted into the new SQL table,
then just run that script using SQLTools or whatever you have at your
disposal. E.g. your prg might be something like
fh = FCREATE("myscript.sql")
FWRITE(fh, "CREATE TABLE whatever columns/types/etc" + crlf)
USE (yourDBF)
FOR-EACH record in DBF
{
convert_each_field_to_correct_format, join_as_csv_string
FWRITE(fh, "INSERT INTO whatever VALUES(" + string + ");" + crlf)
}
FWRITE(fh, "COMMIT" + crlf)
This approach might not be suitable for you if you have hundreds of
DBFs to convert, but it will work -- I've had to do it myself!
Pete
--
"We have not inherited the earth from our ancestors,
we have borrowed it from our descendants."
[toc] | [prev] | [next] | [standalone]
| From | "Jayadev" <Jayadevu_@_rediffmail.com> |
|---|---|
| Date | 2011-08-17 11:27 +0530 |
| Subject | Moving from xBase to SQL |
| Message-ID | <j2fl8i$ij8$1@dont-email.me> |
| In reply to | #1825 |
Dear Mr. Joe Wright, You could try the free Mediator software available from http://www.otc.pl/download/default.aspx?l=2 . All your .dbfs can be converted into sql tables, you could access the .dbfs thru clipper like syntax using their library thru xHarbour / Harbour programs and your other .NET/VB programs could access the sql databases directly thru odbc connections. Folks at OTC are very helpful. HTH, Warm regards, Jayadev "Joe Wright" <joewwright@comcast.net> wrote in message news:XdGdne1UG7-GStfTnZ2dnUVZ_tCdnZ2d@giganews.com... > On 8/16/2011 14:58, dlzc wrote: >> Dear John Ward: >> >> On Aug 16, 9:07 am, John Ward<net4w...@gmail.com> wrote: >>> Is there a recommended resource to find legacy >>> Clipper Programmers/Consultants? >> >> Some knock around here. Some have migrated to Clipper Visual-Objects, >> (x)Harbour, and more. >> >>> Over 3 years ago I supported a slew of legacy >>> Clipper apps, most of which have been migrated >>> off to other platforms. I moved out of >>> development into QA. Our single Clipper >>> Consultant resource supporting the remaining >>> legacy application is leaving the company. >>> There is no way I am getting pulled back into >>> supporting the application (though I am sure I >>> will "have to" support it until a new resource >>> is identified). >> >> You *know* it won't end then. You will still be questioned as to why >> something was done a certain way, or the like. >> >>> Our offshore resources are currently not able >>> to and have yet to locate a Clipper programmer >>> and are hopefully going to find training (which >>> I am sure is non-existant). >> >> Mostly correct. There are still some training materials available for >> Clipper, but they may have to look in used bookshops. Certainly the >> Norton Guides for Clipper are online now... >> >>> These are Clipper 5.01/5.2 apps we are >>> maintaining. No plans to upgrade - other than >>> migrate the data to another system (if that ever >>> happens). >> >> Once that decision is made... >> >> With small revisions to code, you can usually migrate into Harbour / >> xHarbour with minimal changes if the code does not rely on 3rd party >> applications. From there it is a small step to SQL, and probably then >> into some other language (that you can get support for). >> >>> We are large financial services company in the >>> NorthEast USA, just outside of Philadelphia. We >>> are looking for a part-time Clipper consultant. >> >> I'm in the wrong end of the country. I have added two other >> apporpriate newsgroups to your post. >> >> David A. Smith > > Hi David > Can you expand on the "small step to SQL" thing? I'm facing a massive > xBASE to SQL move and I don't have a clue. > TIA > > -- > Joe Wright > "If you rob Peter to pay Paul you can depend on the support of Paul."
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2011-08-18 16:11 +0100 |
| Message-ID | <MY93q.135252$T85.104602@newsfe19.ams2> |
| In reply to | #1824 |
To be honest we tried Alaska Xbase++ OK but not easy for large projects - no interactive form design. Settled with VO, stable, easy for Clipper programmers to pick up, familiar in a lot of concepts. Data. Nothing wrong with Advantage Database Server, this allows both ISAM (Clipper VO style) and SQL access, is also one of the quicker engines and one of the data formats is DBF FPT CDX so no conversion of data actually needed.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web