using a SQL editor

[DFehrenbach]

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?

[maarten]

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

[mattman]

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?