Tim,

First let me say that you done a great job on the EDB and the EDBmngr!
Congrats.

1)The conversion of old scripts to new style scripts doesnot deal with new
lines correctly (the whitespace that should follow a line in the new script
is ignored).  See the example below.

2)Also, it would be nice to have in the EDBmngr a convert function, so you
can copy old style statements into the SQL text tab, convert it (seperate
button), and then execute it. Just a thing for the whislist.

Regards, Harry

SELECT
extract(month from Datum) AS maand,
SUM(Bedrag) AS bedr
INTO memory tmpJTOV
FROM contracten, contractregels
WHERE extract(year from Datum_van) = 2005
AND contracten.id_contract = contractregels.id_contract
AND Object_of_Artikel = 'O'
AND geannuleerd is Null
GROUP BY maand;
....

is converted as

SCRIPT ()
BEGIN
  EXECUTE IMMEDIATE 'SELECTextract(month from Datum) AS maand,SUM(Bedrag)
AS bedrINTO memory tmpJTOVFROM contracten, contractregelsWHERE extract(year
from Datum_van) = 2005AND contracten.id_contract =
contractregels.id_contractAND Object_of_Artikel = ''O''AND geannuleerd is
NullGROUP BY maand';
....

Harry


Where/how do you convert scripts - I'll be needing to soon.

Roy Lambert

Roy,

A put a TEDBscript component on a form, set the SQL text and then did:
EDBScript.convertsql(3)

http://www.elevatesoft.com/edb1d6_tedbscript_convertsql.htm

After that you can read the changed SQL.text to see the new script syntax.

Regards, Harry


"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:BAB32EA6-BB75-4BE0-9F0B-118B3AF5D96D@news.elevatesoft.com...
> Harry
>
>
> Where/how do you convert scripts - I'll be needing to soon.
>
> Roy Lambert
>

Harry,

<< First let me say that you done a great job on the EDB and the EDBmngr!
Congrats. >>

Thanks.  That damn syntax editor took forever to write.

<< 1)The conversion of old scripts to new style scripts doesnot deal with
new lines correctly (the whitespace that should follow a line in the new
script is ignored).  See the example below. >>

What happens if you close the converted script and re-open it ?  Is it okay
then ?  I noticed this after the release was out and, as far as I can see
here, it appears to be simply a visual display issue.

<< 2)Also, it would be nice to have in the EDBmngr a convert function, so
you can copy old style statements into the SQL text tab, convert it
(seperate button), and then execute it. Just a thing for the whislist. >>

What do you mean by "old style" ?  Do you mean DBISAM statements ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Harry,

Ignore my last post about the line conversion - there are two issues, one
being the line conversion, and the other being the display in the EDB
Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> What do you mean by "old style" ?  Do you mean DBISAM statements ?
Yes. I thought it would be nice to copy the dbIsam scripts (I have a lot)
into the new SQL syntax editor and convert them there to the new syntax.
It's just a whish though. It is something I thought might be handy for me
and other users too.

Regards, Harry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:A3CEC830-0456-45B2-BAF4-FD5BA4B0B6FF@news.elevatesoft.com...
> Harry,
>
> << First let me say that you done a great job on the EDB and the EDBmngr!
> Congrats. >>
>
> Thanks.  That damn syntax editor took forever to write.
>
> << 1)The conversion of old scripts to new style scripts doesnot deal with
> new lines correctly (the whitespace that should follow a line in the new
> script is ignored).  See the example below. >>
>
> What happens if you close the converted script and re-open it ?  Is it
okay
> then ?  I noticed this after the release was out and, as far as I can see
> here, it appears to be simply a visual display issue.
>
> << 2)Also, it would be nice to have in the EDBmngr a convert function, so
> you can copy old style statements into the SQL text tab, convert it
> (seperate button), and then execute it. Just a thing for the whislist. >>
>
> What do you mean by "old style" ?  Do you mean DBISAM statements ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< Yes. I thought it would be nice to copy the dbIsam scripts (I have a lot)
into the new SQL syntax editor and convert them there to the new syntax.
It's just a whish though. It is something I thought might be handy for me
and other users too. >>

Yes, but that is just a little bit more involved than the simple script
conversion.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Yes, but that is just a little bit more involved than the simple script
> conversion.
Yes, I guess there is Well, never mind, not all whishes do come true....

BTW, is there any good and simple basic information on how to write scripts?
I read the EDB manual, but I miss some basics on how to use (and why) and
declare cursors, for example.

Regards, Harry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:7C7999B7-CB78-4305-8BF1-7FC424D88D08@news.elevatesoft.com...
> Harry,
>
> << Yes. I thought it would be nice to copy the dbIsam scripts (I have a
lot)
> into the new SQL syntax editor and convert them there to the new syntax.
> It's just a whish though. It is something I thought might be handy for me
> and other users too. >>
>
> Yes, but that is just a little bit more involved than the simple script
> conversion.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< Yes, I guess there is Well, never mind, not all whishes do come
true.... >>

Given a lot of free time, I could probably do it.  However, that isn't the
case currently.  When I do get some free time, however, I will check out
what's involved.  Simple keyword switching/removal is easy, it's the
contextual aspects that require hand-coding.

<< BTW, is there any good and simple basic information on how to write
scripts? I read the EDB manual, but I miss some basics on how to use (and
why) and declare cursors, for example. >>

The best place to review is the SQL/PSM section - stored
procedures/functions and scripts all share the same statement syntax:

http://www.elevatesoft.com/edb1sql_sql_psm_statements.htm

The declaration of cursors is covered fairly well here:

http://www.elevatesoft.com/edb1sql_declare.htm

The general rule of cursors is the same as with Delphi code - you use them
like a TEDBQuery whenever you need to get a result set back to the client
application or whenever you need to iterate the rows in the result set
inside of the script/procedure/function.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


How near to final is the manual? I'd like to print it out but 350+ pages means I don't want to do it very often.

I'd like to print 2 pages per A4 side but my version of Adobe won't let me. All suggestions welcome.

Roy Lambert