Using LO 6.2
Created a Base firebird database.
Using the SQL command window off the Tools menu in Base. Is a little difficult when creating longer scripts.
I can accomplish what I need to using that tool, but it would be nice to have a fuller sql command environment. Is it possible to use another tool, such as firebird’s isql to work on the Base database. Is that possible?
thank you
Hello,
Have not seen any SQL tools which integrate directly with Base. If using an external database, you could use their tools.
Of course you can create SQL in any tool you want then copy it to Base.
Edit:
Since you are talking of the Tools->SQL mode, you can enter all in a Query (turn on "Run SQL directly) and even save it (no execution), then you can copy and paste into command area for actual updating.
With some databases you can use the Query section for limited DB processing but don’t see that for Firebird embedded.
All of this is based upon you dealing with a Firebird embedded DB.