Hi, newbie alert.
I am just starting to build a small portal for an existing legacy line of business system. The DB has been hand built since 1995 and is currently FB1.5 dialect 1. I have other questions that I'll post in more appropriate forums about the best way to package up the data to get it to the WebCore front end.
I just tried to reverse eng the DB and it only has the option for FB 2 & 3. I tried using the FB2 settings and pointed it at the 1.5 FBClient.dll.
Data Modeler detected you are connecting to a database
server whose version is older than the selected one
(Firebird 2). Reverse engineering may not work properly.
Do you want to proceed?"
[DatS]-32 Variable length column [DOMAIN_NAME] overflow.
Value length - , column maximum length - "
So are all bets off. In all honesty, of the 100's of tables in the DB there are only a few I am after and in fact I am likely to do them as specific views or even SPs to restrict access.
As I said at the top, I am at the start of my journey and don't know much about the data modeller and how much time it would have saved me vs starting at the Delphi code end.