Please feel free to move this to some better location. I’m working my way through Bob Cusick’s FMP to Servoy Tutorial. Bob supplies you with an FMP file and a 146-page PDF of instructions on how to reproduce effectively the same solution but in Servoy.
This strikes me as an eminently sensible place to start to get one’s hands on these tools, get a feel for them, start to build some experience with working with Servoy before moving on to the “real thing”.
I have mixed feelings about this tutorial. It’s really excellent and Bob’s obviously put a lot of thought and time on it. However, I’ve found one bug in Servoy (Mac only apparently) in doing it. I’ve discovered there’s a few differences between what Bob says in the surrounding text and what’s in the screenshots (my recommendation, go for the screenshots), and one of the files he says to import isn’t there, replaced by another which behaves slightly differently.
But hey, I’ve made mistakes along the way (like not paying close attention to fine details such as Bob’s names for tables and fields. FMP is VERY forgiving and Servoy is not nearly so. As a result I’ve increased my time working through this tutorial due to both my own goofiness and oddities in Bob’s text.
Having said this, I plan to continue my discussion of working through this tutorial here where perhaps others can chime in and clarify my confusions, not leave that just to Bob.
The bug has already been posted here. On the Mac, go to the Media dialogue and click on Import Directory. The subsequent dialogues are completely different than Bob’s PC screenshots and in the end this function is non-functional. The work around is to import your graphics one at a time. No big deal, just the long way round the rectangle.
Remember, I’m reading the PDF on screen, switching to Servoy, doing the step, back to the PDF, and so forth. I’ve NOT read ahead. Therefore I sometimes get ahead of Bob and run for a moment off the rails.
First Bob walks you through creating a new empty SQL database. Sybase went and changed their website AFTER Bob published the version of the PDF I have. Therefore I downloaded the wrong file and became very confused. But on the plus side, Bob walks you through a very lengthy series of required steps (once you’ve downloaded the correct software) and although it’s lengthy it’s actually a snap.
Then he gets you to create tables and columns (fields) within that database. Warning. Don’t correct the typo on one of the screenshots and name the tables and fields EXACTLY as on the screenshots.
Next Bob tells you he’s got a file you can import with all the layouts already done. Turns out the file supplied is slightly different than what he supplies and has non-fatal differences in its effects. (Chances are these things will get fixed in a forthcoming revision).
I’m now on page 42 of this 146 page opus. By the way I’m identifying the pages the way Acrobat identifies them on screen, rather than the printed page number in one corner of the page.
I’ve imported Bob’s version (had to delete my own in order to do it; don’t fully understand that dynamic, but it works). Bob has forms that look like dead ringers for the FMP version.
However, I really want some hands on experience building a form from scratch. Therefore I create a new form and name it “contact_main2”, to distinguish it from Bob’s “contact_main”. Bob helpfully supplies a grid of properities for all the objects on these forms for those who want to “roll their own”.
Here’s my current puzzlements. I welcome your help in shining a light into my darkened room.
-
Bob says the Form’s “title Text” property should be “Contact Main”. However, when I double click on that property I get a dialogue similar to FMP’s Merge dialogue. A bug? I can send a screenshot to those interested.
-
Bob calls for a background of "Colour = Red:255, Green:255, Blue, 255.
However clicking in the property brings up a colour picker. I don’t see a way of defining colours by number. That should be possible but I don’t see the settings to let me enter this by text.
- Bob calls for a Rectangle of size 612, 15 and location 0, 19. I don’t see any vector drawing tools. I can place some text and revise that but no rectangle drawing tools.
Again, I’m sure there here somewhere but they’re eluding me. (It’s dark in here, I’m a stranger to these parts.)
Whoops! I’ve an answer to my own question. From the View menu → Toolbars → Draw brings up a drawing palette.
Okay, it’s getting late. For those that are interested I’ll continue this diary tomorrow into the world beyond page 42.
Morley Chalmers