Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread DBISAM to EDB Conversion, building on Roys work
Sat, Apr 23 2011 3:19 PMPermanent Link

Adam Brett

Orixa Systems

Hi:

I attach a simple project, Delphi 2007, but I hope it will compile on most versions.

The key unit which does all the work is uDBISAMtoEDBSQLConverter, it contains an Object the user can instantiate & pass parameters to ... then call "Execute" & the actual work of re-wrapping the SQL-String is done.

I hope its function is clear.

The aim is to be able to convert longish, reasonably complex DBISAM SQL Statements written for things like reporting into functional EDB SQL.

It is flawed ... the user will need to clean up the resulting SQL a little to make it work.

It is not hugely tested ... there may well be SQL scripts which it will mangle!

... but I have tried to make it as usable as possible.

--

If someone uses it & improves it I would be grateful if they post the result back here.

I am only going to start using it in anger over the next couple of days ... so I am quite likely to post my own improvements too ...



Attachments: DBISAMtoEDB.zip
Sun, Apr 24 2011 3:29 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


Take out the MainFormOnTaskbar and it compiles in D2006, replace "strict private" with "private" and move a couple of lines of code and it compiles in D6

Not looked at functionality yet - I didn't make much use of SQL prior to ElevateDB and have few complex scripts to test it on.

Roy Lambert
Sun, Apr 24 2011 9:54 AMPermanent Link

Adam Brett

Orixa Systems

>>I didn't make much use of SQL prior to ElevateDB
>> and have few complex scripts to test it on.

That's certainly changed now though Roy! The scripts you have posted on the various forums are pretty challenging & extremely educational.
Mon, Apr 25 2011 3:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


>That's certainly changed now though Roy! The scripts you have posted on the various forums are pretty challenging & extremely educational.

They usually challenge me <vbg>

Roy Lambert
Image