Dear Support!

Is query supports now more statement as in DBISAM?

For example:

select * into memory x  from a;
update ....
select * from memory x;

And if supports, then what is the separator I can use?

Thanks:
     dd

durumdara

>Is query supports now more statement as in DBISAM?

No TEDBQuery is restricted to a single sql statement. I think there is a method call to convert them into scripts but I've never used it and can't remember what it is (if it exists).

What you need is a TEDBScript. This allows multiple simple statements similar to DBISAM (but you need to use the syntax EXECUTE IMMEDIATE 'sqlcode') but also has its own comprehensive programming language so are much more powerful.

Roy Lambert [Team Elevate]