Hi!

Michael A. Hess wrote

I too have finished up that project and will be diving head long back into Lazarus this week. It appears that we have all finished up some of the work that was tying our hands and I believe we should see some major advances in Lazarus in the coming month. I can't wait. :-)

:-((((

Seems I'm the only one who has to work on other projects for the next weeks. I hope I can get something done for lazarus also but I'm not to optimistic. There are about 5 customers waiting for me and during october I'll have to make trips to Berlin, Zuerich and some other cities. Spending so much time on the highway.... it's a nightmare....

> We already got a little bit of snow here friday night. YUUCCCKKKK! Snow already!!! That is just to dang early for me.

Lucky guys, we have snow here only in Jan/Feb and even that only for a day or two.

bye,

Stefan

I have got just a few more days doing this project I am on for work. I had to re-write a VB client server system in Delphi. The program in VB was just getting to ugly "Kludgy" to maintain in the long term. The boys with the ties just tasked me two weeks ago to convert it to Delphi. I used to write a ton of stuff in VB but this little deal has changed my mind in a big way. The VB program was well written but the lack of True OOP just made it ugly. The developer that wrote the last one did it in two months, I rewrote it in two weeks. It took a whole lot less time and code due to the fact that stuff like inheritance is supported in Delphi.

So that means that I am going to format my fast machine later this week and put Debian, Free Pascal and Lazarus Code Base back on it. I am then immediately going on a two week write code at home holiday ;).

Summer is over here and winter is setting in. We already got a little bit of snow here friday night.

Cliff Baeseman

At my company we're about to rewrite a 16Mb VB app with over 50 MDI screens in Delphi. The VB app - while very well written in some parts - isn't doing well. We figure that to make the VB app go to Client-server (needed), we'd need:
- 2 months code/DB cleanup (badly needed by itself)
- 1 month going to VB 6/7, updating all widgets. (OCX's and stuff)
- .75 months creating/filling/documenting a Data dictionary (we've a HUGE access DB :( )
- 2 months DAO -> ADO conversion (UNION SQL statements all over the place :( )
- 2 months Client/server work to go to oracle or whatever... total estimated time: about 8 months.

By rewriting the app FROM SCRATCH in Delphi 5, we think we can do it in less than 6 months.

As a result we would have all the above, plus a much more consistent interface of the program; better performance; better maintainability of code; plus some additional features that are just not possible when working in VB.

Plus, and this will be the nice thing; in the end maybe we can port to linux, hopefully with FPC...

If we can pull it off it will be huge publicity for FPC. I believe in it. (But the time frame for this port is another matter :) )

Michael.

- 2 months DAO -> ADO conversion (UNION SQL statements all over the place

beware with DAO in D5, it make bad decisions when you use joins sqls..

I'm using mOdbc (http://perio.unlp.edu.ar/modbc) and in this components we have update, insert, delete sql separated if you want (a la TUpdateSql), but ADO come without this ...

I've found that if you make a join sql and try to delete a record, a record is deleted from all the tables in the join !

this is _very_ sad, now I have a component making decisions for me... (I'm so stupid ?)

and needless to say, ADOExpress come with very nice bugs for your pleasure...

I have to agree with this one. Friday I just finished working for a company doing a VB project. When they hired me back in the beginning of June they wanted to get everything cleaned up by the middle of June. In fact they thought it might be done by the time I started. Well here it is Oct. 1st and we just finished a stable release. Talk about a pile of junky code. It was a nightmare. I wonder how fast I could of redone the whole thing had I been given the oportunity to redo it in Delphi.

I too have finished up that project and will be diving head long back into Lazarus this week. It appears that we have all finished up some of the work that was tying our hands and I believe we should see some major advances in Lazarus in the coming month. I can't wait. :-)

We already got a little bit of snow here friday night.

YUUCCCKKKK! Snow already!!! That is just to dang early for me.

I am using ADO 2.1 right now in Delphi 4...

No component library I just imported the type library interface.

I do not use bound controls..

Cliff

I like PostgreSql because it is very complete.

Sam

Michael Van Canneyt el d�a Mon, 4 Oct 1999
09:35:08 +0200 (W. Europe Daylight Time), escribi�:

the JOINS must be removed completely; it is NOT ansi SQL.

hu ? are you saying that a sql like:
select a.h, b.h, c.h, d.j, e.j
from table1 h, table2 j
where a.h = d.j

is not ansi sql ???

> I've found that if you make a join sql and try to delete a record, > a record is deleted from all the tables in the join ! I think this has to do with the 'cascaded delete' option of the tables.

I've just tryed the ADOQuery ...

I've falled in love with PostgreSql a long time ago ... :)

Sergio

the JOINS must be removed completely; it is NOT ansi SQL. Also, in delphi we don't use the BDE; we use Diamond Access DAO components.

I think this has to do with the 'cascaded delete' option of the tables.

:-) We'll move to interbase altogether. I haven't had problems with that yet :)

Michael.

No, no: but MS Access allows
SELECT a,b,c,d,e,f,g

  FROM table1 LEFT JOIN table2 ON field1=field2;

A typical VB application is full of it. The 'LEFT JOIN' is NOT ansi SQL.

we'll have to change about 250 queries to more 'ansi sql' statements.

I like it too; but I got stuck on MySQL&interbase anyway.

Michael.