Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4291 > unrolled thread
| Started by | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| First post | 2012-10-15 09:53 -0700 |
| Last post | 2014-09-05 17:51 +0000 |
| Articles | 17 — 7 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: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-10-15 09:53 -0700
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-15 17:01 +0000
Re: Windows 7 corruption network igsofterror@gmail.com - 2012-10-16 23:38 -0700
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-17 07:30 +0000
Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-07 07:20 -0800
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-09 15:59 +0000
Re: Windows 7 corruption network "Ginny Caughey" <gcaughey@online.hotmail.com> - 2012-12-10 07:05 -0500
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-10 14:56 +0000
Re: Windows 7 corruption network "Ginny Caughey" <gcaughey@online.hotmail.com> - 2012-12-11 07:01 -0500
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-11 15:51 +0000
Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 06:22 -0800
Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 14:01 -0800
Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-18 07:12 +0000
Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 06:27 -0800
Re: Windows 7 corruption network "Rene J. Pajaron" <rjpajaron@gmail.com> - 2012-12-18 03:41 -0800
Re: Windows 7 corruption network Jean-Luc Stassen <jls@igsoft.be> - 2013-02-02 07:23 -0800
Win XP Pro vs Win 7 Pro "Jose F Zouain" <jfzouain@zetaconcepts.com> - 2014-09-05 17:51 +0000
| From | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| Date | 2012-10-15 09:53 -0700 |
| Subject | Re: Windows 7 corruption network |
| Message-ID | <cc364fd2-2bfe-4b77-b21c-63597f10b194@googlegroups.com> |
Hello Geoff, I only see this reply two years later... <g> I agree with you, the code is not really a problem... we can work on it to make it working with SQL. Altrought, how can I in the same code manage DBF or SQL ? If it's possible, I will be instersting with this mechanism. My actual difficulties are: - convert all the personalised reports (reportpro 2.16) of each customers (+/- 500) - install and configure Mysql or something else on the server of my customers These two points cannot automatically done via standard software update. I need to go to the customer or connect his network with teamviwer to configure anything... If you show me the basics to use the same code for dbf or sql, it will be very kind... Jean-Luc Le lundi 3 janvier 2011 00:10:22 UTC+1, Geoff Schaller a écrit : > J-L, > > Everyone claims their app is big <g>. I genuinely suspect yours is about > the same size as most other people's. However the point about class > libraries like mine is that you can convert to SQL without rewriting > your code base. > > Let me take the average VO application: > > * say around 250,000 lines of generated and written code > * say around 20 main lookup browsers > * say around 120 edit windows and dialogs (forget popups) > * perhaps 80-120 reports > * around 50-60 business processes (no GUI) > > I can have your first cut in SQL in 2-3 weeks, sometime half that, > depends on the quality of your original VO code. Data conversion to SQL > included. And the code will run alternately DBF and SQL to prove > business logic is the same. Very little code manipulation save for the > replacement of SetSelectiveRelation with joins and SetRelation with > dynamic scopes. > > The refinements then take a while. Perhaps 2-3 hrs per report (to > convert to reporting services) and 1-2 hours per browser/process. But > let's make it clear. Your DBF style code remains the same until such > time as you want to take advantage of SQL-only functionality and > performance benefits. Your app will run faster and be many times more > stable. > > Of course there is effort and I would probably allocate a 6 month time > frame to do it carefully but at least the process can be undertaken > along side your existing maintenance program. The user won't know until > the day you cut over. > > Cheers, > > Geoff > > > > "Jean-Luc Stassen" <jls@igsoft.be> wrote in message > news:5831fa1f-bd70-4909-b167-121be4991e00@v12g2000vbx.googlegroups.com: > > > Geoff, > > > > The reason is that my app is very very big and it is not possible to > > change it right now... > > For sure, I want in the future go to SQL, but I have to rewrite > > everything and... I don't have time (month !) to do that now... > > > > Thank you everyone for your support and help ! > > > > Jean-Luc
[toc] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-10-15 17:01 +0000 |
| Message-ID | <ae2tqkFj7fuU1@mid.individual.net> |
| In reply to | #4291 |
Hi Jean-Luc, PMFJI, I had a similar problem and I solved it by using ADS. ADS can be used like a DBF, for SQL do work properly you need a complete redesign of the application. Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | igsofterror@gmail.com |
|---|---|
| Date | 2012-10-16 23:38 -0700 |
| Message-ID | <31b0f031-3ba3-4911-a73a-c33dffa88717@googlegroups.com> |
| In reply to | #4293 |
Hello Wolfgang, By "ADS" do you mean Advantage Database Server ? Ok, I tried that some years ago (with the driver AXDBFCDX that I was loading in the start function) but I never really make it working... on the server, ADS didn't use my dbf... I think, make the code good for the 2 database is maybe the best solution... Jean-Luc Le lundi 15 octobre 2012 19:01:10 UTC+2, Wolfgang Riedmann a écrit : > Hi Jean-Luc, > > > > PMFJI, > > > > I had a similar problem and I solved it by using ADS. ADS can be used > > like a DBF, for SQL do work properly you need a complete redesign of > > the application. > > > > Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-10-17 07:30 +0000 |
| Message-ID | <ae754cFiiojU1@mid.individual.net> |
| In reply to | #4299 |
Hi Jean-Luc, > By "ADS" do you mean Advantage Database Server ? Ok, I tried that > some years ago (with the driver AXDBFCDX that I was loading in the > start function) but I never really make it working... on the server, > ADS didn't use my dbf... yes, I mean Advantage Database Server. It is not 100% compatible to DBFs (you cannot use own function in index expressions, filter expressions cannot used functions from your program, ANSI needs to be set to false), but it took a day or so to adapt my software to ADS. It is very fast and absolutely stable, and does not takes too much resources on the server. Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| Date | 2012-12-07 07:20 -0800 |
| Message-ID | <cc25d292-5bfd-45d0-9085-a8bc4e0a4924@googlegroups.com> |
| In reply to | #4301 |
Hi Wolfgang, IS ADS free ? I think it's exmpansive for the customer, isn't it ? Jean-Luc Le mercredi 17 octobre 2012 09:30:22 UTC+2, Wolfgang Riedmann a écrit : > Hi Jean-Luc, > > > > > By "ADS" do you mean Advantage Database Server ? Ok, I tried that > > > some years ago (with the driver AXDBFCDX that I was loading in the > > > start function) but I never really make it working... on the server, > > > ADS didn't use my dbf... > > > > > > yes, I mean Advantage Database Server. > > > > It is not 100% compatible to DBFs (you cannot use own function in index > > expressions, filter expressions cannot used functions from your > > program, ANSI needs to be set to false), but it took a day or so to > > adapt my software to ADS. > > It is very fast and absolutely stable, and does not takes too much > > resources on the server. > > > > Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-12-09 15:59 +0000 |
| Message-ID | <aijqrfFmohlU1@mid.individual.net> |
| In reply to | #4439 |
Hi Jean-Luc, > IS ADS free ? until 5 users You can use the local server > I think it's exmpansive for the customer, isn't it ? yes, it costs some money, but it costs far less than any other SQL database (except MySQL or other open source SQL servers like Postgres or Firebird). And if you compare the expenses to a complete rewrite on a complex app for a SQL interface, they are very low. With ADS you can use both approaches, positional access with incremental search and the other goodies from DBF, and relational access with SQL. I have moved one customer to Advantage and I'm very happy with it. Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Ginny Caughey" <gcaughey@online.hotmail.com> |
|---|---|
| Date | 2012-12-10 07:05 -0500 |
| Message-ID | <50c5d012$0$47703$c3e8da3$5e5e430d@news.astraweb.com> |
| In reply to | #4442 |
You may be unaware that SQL Server Express is also free. Ginny "Wolfgang Riedmann" wrote in message news:aijqrfFmohlU1@mid.individual.net... Hi Jean-Luc, > IS ADS free ? until 5 users You can use the local server > I think it's exmpansive for the customer, isn't it ? yes, it costs some money, but it costs far less than any other SQL database (except MySQL or other open source SQL servers like Postgres or Firebird). And if you compare the expenses to a complete rewrite on a complex app for a SQL interface, they are very low. With ADS you can use both approaches, positional access with incremental search and the other goodies from DBF, and relational access with SQL. I have moved one customer to Advantage and I'm very happy with it. Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-12-10 14:56 +0000 |
| Message-ID | <aimbh9F9mc5U1@mid.individual.net> |
| In reply to | #4448 |
Hi Ginny, > You may be unaware that SQL Server Express is also free. I know that, but moving a DBF based application to SQL is more work than buying ADS. And SQL is a major impact on the user interface - most of my customers are using incremental searches on bBrowser controls. Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Ginny Caughey" <gcaughey@online.hotmail.com> |
|---|---|
| Date | 2012-12-11 07:01 -0500 |
| Message-ID | <50c72080$0$34943$c3e8da3$460562f1@news.astraweb.com> |
| In reply to | #4453 |
Yes I agree it's a lot more work. For my company it was clearly worth it - we'd probably be out of business by now if I hadn't done that - but each situation is different. You do have to perform searches somewhat differently with SQL, but it is certainly possible to give users the ability to quickly find the data they want with a SQL database. Ginny "Wolfgang Riedmann" wrote in message news:aimbh9F9mc5U1@mid.individual.net... Hi Ginny, > You may be unaware that SQL Server Express is also free. I know that, but moving a DBF based application to SQL is more work than buying ADS. And SQL is a major impact on the user interface - most of my customers are using incremental searches on bBrowser controls. Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-12-11 15:51 +0000 |
| Message-ID | <aip343Fsnq2U1@mid.individual.net> |
| In reply to | #4461 |
Hi Ginny, > Yes I agree it's a lot more work. For my company it was clearly worth > it - we'd probably be out of business by now if I hadn't done that - > but each situation is different. yes, that's true. I work regularly also with Oracle, MySQL and MS Sql, but IMHO positional databases like DBF permit more userfriendly software > You do have to perform searches somewhat differently with SQL, but it > is certainly possible to give users the ability to quickly find the > data they want with a SQL database. yes, with SQL the user need to think first what he needs. With DBF the user can open a databrowser, and if he not sees what he needs, he can begin to search. Obviously with very large databases SQL is the only choice.... Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| Date | 2012-12-17 06:22 -0800 |
| Message-ID | <16c096b9-056c-4e90-b056-c963b32acd63@googlegroups.com> |
| In reply to | #4462 |
Hi Wolfgang,
Ok, I just want to try with the 5 users local server.
What do I have to do ?
I have a server 2008 and 3 stations with windows 7
I guess I must install something on the server ? Do you have a link where I can download an ASD for free ?
And, in my App do I only have to set
SetAnsi(FALSE)
RDDSETDEFAULT("AXDBFCDX")
AX_AXSLocking(FALSE)
AX_RightsCheck(FALSE)
and remove all kind of self:server:filter := "...." ?
What can replace filter with ADS ?
Sorry if all these questions seems to be evident, but I don't know nothing about ADS...
Jean-Luc
[toc] | [prev] | [next] | [standalone]
| From | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| Date | 2012-12-17 14:01 -0800 |
| Message-ID | <b661f2eb-a134-4f91-a271-4bdd724af0df@googlegroups.com> |
| In reply to | #4476 |
Wolfgang,
I have installed ADS on my server. Do I have to specify the path of my databases dbf ?
On the workstation, I made a little app that use ads, like this:
SetAnsi(FALSE)
RddSetDefault("AXDBFCDX")
AX_AXSLocking(FALSE)
AX_RightsCheck(FALSE)
oserver := clients{,,,"AXDBFCDX")
...
on the open line I get an error saying that a call to _except_handler_4 in msvcrt.dll is not avaiable, and the app crashes...
Can you light me ?
Thank you
Jean-Luc
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-12-18 07:12 +0000 |
| Message-ID | <ajajbcFsaakU1@mid.individual.net> |
| In reply to | #4476 |
Hi Jean-Luc,
> Ok, I just want to try with the 5 users local server.
> What do I have to do ?
> I have a server 2008 and 3 stations with windows 7
> I guess I must install something on the server ? Do you have a link
> where I can download an ASD for free ?
the local server is only a DLL, so nothing to install on the server -
only to adjust ADS.INI in your app directory to permit local server:
[SETTINGS]
;ADS_SERVER_TYPE = 7
ADS_SERVER_TYPE = 3
> And, in my App do I only have to set
> SetAnsi(FALSE)
> RDDSETDEFAULT("AXDBFCDX")
> AX_AXSLocking(FALSE)
> AX_RightsCheck(FALSE)
> and remove all kind of self:server:filter := "...." ?
> What can replace filter with ADS ?
filters are working, but only when ADS-provided functions are used. The
same is true for orders: orders can include only ADS-provided functions
(since they are executed on the server), but most standard functions
are provided.
I have spent about half a day to make work an application with ADS (and
would never miss it).
But the true saving is coming when you are using the commercial server
on the server itself: it runs very stable and it does consume very few
ressources on CPU and memory.
Wolfgang
--
[toc] | [prev] | [next] | [standalone]
| From | Jean-Luc Stassen <igsoftsprl.be@gmail.com> |
|---|---|
| Date | 2012-12-17 06:27 -0800 |
| Message-ID | <4596ec68-54ff-4f3a-9b47-89889d03e75f@googlegroups.com> |
| In reply to | #4461 |
Hello Ginny, I agree with you but now I think it's too late for me to change all my app to SQL. I have around 200 tables to manage ! this is a very big application. And we still work everyday on it, so it's impossible to stay 2 or 3 months without any new version (with bug correction) So if ADS can fix my problem, I'm going to try... Jean-Luc
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2012-12-18 03:41 -0800 |
| Message-ID | <76d9745d-1b8b-492a-8c89-aae6939a1e1a@googlegroups.com> |
| In reply to | #4299 |
Jean-Luc, My apps run seamlessly on both driver: DBFCDX and AXDBFCDX. I also have working apps converted from Geoff SOVO SQL classes that work like a treat. Now we have two modes: ADS/ALS/DBFCDX and SQL Server. My only problem with SQL is that we have a delay in converting hundred RP3 to SSRS. But with ADS, RP3 works fine, it evens used native ADT using ADSADT.RDD. -- Rene On Wednesday, October 17, 2012 2:38:15 PM UTC+8, igsof...@gmail.com wrote: > Hello Wolfgang, > > > > By "ADS" do you mean Advantage Database Server ? Ok, I tried that some years ago (with the driver AXDBFCDX that I was loading in the start function) but I never really make it working... on the server, ADS didn't use my dbf... > > > > I think, make the code good for the 2 database is maybe the best solution... > > > > Jean-Luc > > > > > > > > Le lundi 15 octobre 2012 19:01:10 UTC+2, Wolfgang Riedmann a écrit : > > > Hi Jean-Luc, > > > > > > > > > > > > PMFJI, > > > > > > > > > > > > I had a similar problem and I solved it by using ADS. ADS can be used > > > > > > like a DBF, for SQL do work properly you need a complete redesign of > > > > > > the application. > > > > > > > > > > > > Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | Jean-Luc Stassen <jls@igsoft.be> |
|---|---|
| Date | 2013-02-02 07:23 -0800 |
| Message-ID | <ea1c15fa-3694-4cf0-bc28-04528fef443d@googlegroups.com> |
| In reply to | #4483 |
Hi René, Can you tell me where I can find the SOVO classes ? Thank you Jean-Luc
[toc] | [prev] | [next] | [standalone]
| From | "Jose F Zouain" <jfzouain@zetaconcepts.com> |
|---|---|
| Date | 2014-09-05 17:51 +0000 |
| Subject | Win XP Pro vs Win 7 Pro |
| Message-ID | <c6ubgvFtknnU3@mid.individual.net> |
| In reply to | #4291 |
Jean-Luc Stassen wrote: > Hello Geoff, > > I only see this reply two years later... <g> > > I agree with you, the code is not really a problem... we can work on > it to make it working with SQL. > > Altrought, how can I in the same code manage DBF or SQL ? > If it's possible, I will be instersting with this mechanism. > > My actual difficulties are: > - convert all the personalised reports (reportpro 2.16) of each > customers (+/- 500) - install and configure Mysql or something else > on the server of my customers > > These two points cannot automatically done via standard software > update. I need to go to the customer or connect his network with > teamviwer to configure anything... > > If you show me the basics to use the same code for dbf or sql, it > will be very kind... > > Jean-Luc > > > > Le lundi 3 janvier 2011 00:10:22 UTC+1, Geoff Schaller a écrit : > > J-L, > > > > Everyone claims their app is big <g>. I genuinely suspect yours is > > about the same size as most other people's. However the point about > > class libraries like mine is that you can convert to SQL without > > rewriting your code base. > > > > Let me take the average VO application: > > > > * say around 250,000 lines of generated and written code > > * say around 20 main lookup browsers > > * say around 120 edit windows and dialogs (forget popups) > > * perhaps 80-120 reports > > * around 50-60 business processes (no GUI) > > > > I can have your first cut in SQL in 2-3 weeks, sometime half that, > > depends on the quality of your original VO code. Data conversion to > > SQL included. And the code will run alternately DBF and SQL to > > prove business logic is the same. Very little code manipulation > > save for the replacement of SetSelectiveRelation with joins and > > SetRelation with dynamic scopes. > > > > The refinements then take a while. Perhaps 2-3 hrs per report (to > > convert to reporting services) and 1-2 hours per browser/process. > > But let's make it clear. Your DBF style code remains the same until > > such time as you want to take advantage of SQL-only functionality > > and performance benefits. Your app will run faster and be many > > times more stable. > > > > Of course there is effort and I would probably allocate a 6 month > > time frame to do it carefully but at least the process can be > > undertaken along side your existing maintenance program. The user > > won't know until the day you cut over. > > > > Cheers, > > > > Geoff > > > > > > > > "Jean-Luc Stassen" <jls@igsoft.be> wrote in message > > news:5831fa1f-bd70-4909-b167-121be4991e00@v12g2000vbx.googlegroups.c Hi all I have been getting this weird behavior in my Win 7 machine, IN XP looks beatiful, no problem. Bu in Win 7 I get problem of resizing and double controls. Running VO 2.8 SP3. I did not know that going from XP Pro to Win 7 Pro, will have this problem. Have anyone had this problem. Don't know where to start. Di MS again changed all the settings. Thansks Jose --
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web