SQL Power Software Forum

Yes Jonathan, about the FK, I tried to recreate the problem in order to describe it, but it didn´t happened anymore. Maybe it has been fixed in the latest nightly build. It was a difference between the PK type and the correspondent FK type, that generated a warning from the database saying something like: "this relationship will generate costly selects" or something like that. If I came across with it in the near future, I let you know.

thnx again,
Nelson Teixeira
Blog:www.aocontrario.com

Jonathan, just want to thank you. It worked on the last build 11/09. I could sucessfully reverse engineer my database and recreate it using auto-increment fields and boolean types.

When I reverse engineer it the serial fields didn´t had the check in the "auto-increment" option, the fk fields type didn´t match the id field type, and the boolean field still where bits (but now we have the boolean type). As soon as I did these modification in the model, all worked up.

Great job!

Thank you and your team

NP. it´s a free solution after all. I´m not complaining, I should be helping you guys

Hello Jonathan,

After the nightly build problem been fixed, I tried the nightly build of 7/11 and 8/11 . And in both I got the same error:

"The architect keeps it´s list of connections in a file called PL.INI. Your PL.INI location is not set.

You can browse bla bla..."

Then I got an option of Browse or Create,.if I browse I can´t find it. If I create it, I got a null error.
Tried to install over the existing installation and to uninstall before install. None of them worked.
There is some special procedure for using nightly builds ?

Nelson
Blog: www.aocontrario.com

NP. Thnx for the quick fix

What happend to nightly builds ? the downloads aren´t working.

Jonathan, none of the downloads for the nightly builds are working. I´m trying at http://nightlybuild.sqlpower.ca/ is this right ? Where can I get them ?

Nelson
Blog: www.aocontrario.com

Wow, thanks!

I´ll try it as soon as I get on work tomorrow.

Great news about auto-increment types

Now the only think needed to be usable for my project is PGSQL boolean fields

) maybe in the next one

well... I really liked Power@Architect, but not having the serial type, is a problem to me. Now that PA is open-source do you intend to include it in the near future ?

Nelson