Thank again, that helps a lot

Richard

"Fernando Dias" <fernandodias.removthis@andthis.easygate.com.pt> wrote in
message news:0308F773-DDDE-4FDD-B469-423E9902FC98@news.elevatesoft.com...
> Richard,
>
>> I noticed that I didn't have to use 'EXECUTE IMMEDIATE ' to call my sp.
>> I checked the docs but it didn't seem clear on when I need to use EXECUTE
>> IMMEDIATE and when I don't need to use it.  Can you clarify its use at
>> all?
>
> EDB uses dynamic sql for DML, DDL and administrative statement execution
> in procedures, functions, jobs and scripts.
>
> So, you need PREPARE/EXECUTE or EXECUTE IMMEDIATE for:
>
> * DDL Statements
> http://www.elevatesoft.com/manual?action=mancat&id=edb2sql&category=10
> * DML Statements
> http://www.elevatesoft.com/manual?action=mancat&id=edb2sql&category=11
> * Administrative Statements
> http://www.elevatesoft.com/manual?action=mancat&id=edb2sql&category=14
>
>
> You don't need it for:
>
> *SQL/PSM Statements
> http://www.elevatesoft.com/manual?action=mancat&id=edb2sql&category=13
>
>
> --
> Fernando Dias
> [Team Elevate]

Richard

>1. SCRIPT (IN SQLStatement .... looks pretty much like a stored procedure
>definition but there is no name associated with it

Its actually just passing a SELECT statement in as a text variable

>Sorry for my obtuseness.

Not a problem. Post as many questions as you need. Tell us when you don't understand and we'll try and help. This is the best newsgroup I know of for support.

>Changing DB environments can be a steep learning
>curve and I don't have a handle on ElevateDB yet

You don't say I moved from DBISAM to ElevateDB and Tim had done a great job in providing ease of use features in DBISAM and a couple of years on I still miss them

Roy Lambert [Team Elevate]