using a SQL editor

Classic Servoy
1

I am trying to use IB Query as a SQL editor to build SQL search strings that I can paste into methods. Can someone please help with the following questions:

  1. is IB Query a good tool for this ?
  2. How do I register the database and find my solution in IB Query?
  3. What database user name and password are used by Servoy Developer?
2
  1. I use IB manager, but I guess IB query would also work for you.
    (If you plan to use Firebird in production, I’d go for IB manager which is a complete package for DBA)
  2. see attachment.
  3. sysdba/masterkey (=default setting)

If your using other platforms check out:
http://forum.servoy.com/viewtopic.php?t … light=aqua

3

Maarten, Jan, Jan or Johan, are there other variables supported within the DB Servers connection string?

Also, are shortcuts (desktop aliases) resolved?

For example current connect string is…

jdbc:firebirdsql:localhost/3050:%%user.dir%%/database/SOMEDB.GDB?lc_ctype=WIN1252

Where %%user.dir%% is relative to the Servoy folder.

It seems that user.dir is a variable you have defined. This is not working off the system or user path. Are the user and system path supported?

If I place a shortcut at C:\Databases and it points to
C:\Documents and Settings\Matt\My Documents\Databases
will Servoy resolve this?

Do the DB files have to be stored relative to the Servoy app?