Log in

View Full Version : SYWARE Visual CE: Powerful & Flexible Application Building


Andy Sjostrom
01-29-2003, 10:00 AM
Darren Humphries (<a href="http://www.pocketpcthoughts.com/forums/profile.php?mode=viewprofile&u=196">Dazz</a>) is a Senior Account Manager at <a href="http://www.osft.com">Opensoft Inc</a> and a frequent Pocket PC Thoughts visitor. Darren has written a review of SYWARE Visual CE 7.0, an application development tool which is very simple to use yet very powerful. Check it out!<br /><!><i>If you are a wannabe-coder but don't know where to start or even if you are a code jockey you should take a look at Visual CE from <a href="http://www.syware.com ">SYWARE</a>. For those that don't know, Visual CE has been around for quite a while and can pretty well be considered the grand-daddy of database and development environments for Windows CE. SYWARE, who has recently released version 7.0, has built on an already flexible and powerful RAD (Rapid Application Development) solution. I have had a chance to use with it and am impressed.</i><br /><br /><span><b>Visual CE Building Blocks</b></span><br />To build your app you start by building a table and then build a form based on that table. Building forms is a fairly simple drag-and-drop affair. The complexities of your application are at the form level and not table. There are a number of field types to add functionality to your app. The field types include:<li>Text - any combination of characters and numbers.<br /><li>Note - basically a large text field.<br /><li>Checkbox - ummm…checkbox.<br /><li>Drop down - tapping on field will show choices to select. User can add items or you can have the field select items from another table.<br /><li>Radio button - shows multiple item where you can only select one.<br /><li>Calculated - VERY powerful calculations (more later).<br /><li>Scribble - allows handwriting and drawings.<br /><li>Timestamp - will populate a date field when activated.<br /><li>Image - any image including bmp, gif, jpg<br /><li>Autonumber - assigns incremental value to numeric field.Further, you can add functionality using:<li>Command buttons - almost all menu functions and used for Macro language<br /><li>Jump - open another form to view/add related records.<br /><li>Lookup - pull value of a record from another table.<br /><li>Grids - like a list of related records from another table (like a sub form).Your forms can have any combination of colors, layout and font styles. Synchronization is either through the desktop application or Activesync connection. Sync can be one or two way and multiple users can sync to one desktop/server. The real power of Visual CE is in its relational capabilities (not available in the Lite version). If you have worked with database design you will know all about this. Relational databases allow you to "relate" tables by associating fields in between them.<br /><br /><span><b>My Music Collection Catalogue</b></span><br />You can create an application that will catalogue your complete music collection. You could create tables for CD's, Tracks and Artists. Then create a form for each. On the CD form you can create a "jump" button to the Artist form and can create a grid (sub form) that will list all of the tracks on that CD. On the Artist form you can create a grid that shows all of the CD's for that Artist. By linking all of these forms with grids and buttons you end up creating your very own application. This really just scratches the surface of what Visual CE can do though. You can customize your forms with images. A rather big feature for me is the ability to develop on both the desktop and Pocket PC. I take the train to work everyday and when I am not reading I am able to build and customize forms. With the Enterprise version you can access server databases wirelessly using SYWARE's mEnable. <br /><br />The following images are screen shots from applications built using Visual CE!<br /><br /><img src="http://www.pocketpcthoughts.com/reviewimages/dazz-jan03-syware-1.jpg" /><br /><i>Figure 1: Custom built Contacts application</i><br /><br /><img src="http://www.pocketpcthoughts.com/reviewimages/dazz-jan03-syware-2.jpg" /><br /><i>Figure 2: It’s very easy to link forms together</i><br /><br /><span><b>Extensibility for Enterprise</b></span><br />Visual CE also allows interaction with other devices such as bar code scanners and GPS units. Using a bar code scanner and mEnable a company could equip warehouse employees with the ability to quickly take stock and compile orders. For you developer types who would like very much to snub your noses at Visual CE...you'd better take another look. Visual CE includes a Macro ability of sorts by daisy chaining command buttons together. If-then-else logic statements are possible as well and when combined with the Macro's ability to skip steps a fairly complex application and comprehensive solution is possible. I can't stress enough how powerful the calculation field is. You <u>have</u>to see it to believe what is possible. The usual arithmetical functions are there of course but then you can use a huge variety of advanced calculation functions like sums, averages, high/lows, truncate, sin, cos, tangent, etc. Calculations can also be based on dates with some interesting goodies like showing the month name after a date calculation and a bunch of other things.<br /><br />Did I mention that you can distribute your application royalty free? Yep, with the Professional version includes a license to distribute without any licensing fees to your users. Be careful if you want to build a fairly complex app, make sure you read the user manuals carefully. Also, I had a few problems in getting my databases to sync because of the field properties not being set properly in Microsoft Access. These are not the fault of Visual CE, rather an over-enthusiastic jumping-in on my part.<br /><br /><b><span>Gotchas</span></b><br />None - this is a solid and highly refined application.<br /><br /><span><b>Where To Buy</b></span><br />You can buy SYWARE's Visual CE in the following editions (affiliate links):<li><a href="http://www.handango.com/PlatformProductDetail.jsp?siteId=311&productId=13262">Visual CE Lite ($19.90)</a><br /><li><a href="http://www.handango.com/PlatformProductDetail.jsp?siteId=311&productId=13261">Visual CE Personal Edition ($129.90)</a><br /><li><a href="http://www.handango.com/PlatformProductDetail.jsp?siteId=311&productId=13263">Visual CE Professional Edition ($399.90)</a><br /><li><a href="http://www.handango.com/PlatformProductDetail.jsp?siteId=311&productId=13265">Visual CE Enterprise Edition ($599.00)</a>While the prices might seem a little steep to some it isn't too bad. For most people the Lite version will handle most chores. The Personal version with all of the functionality of the Professional version has all you could need to develop complex applications for yourself and with the Professional version you can redistribute at no cost. The Enterprise version would also be considered fairly inexpensive for corporations, especially when compared with other development tools and per seat licensing agreements.<br /><br /><b><span>Conclusions</span></b><br />As mentioned, I have found Visual CE 7.0 to be very capable and comprehensive. If you're looking to build simple or complex applications, SYWARE Visual CE is an excellent choice.

mv
01-29-2003, 12:46 PM
How easy is to create a little DB aplication, (To organize my book collection) using this program? I´m not a programer at all, but i can do little things (like creating a DB viewer) on visual basic. And can that be done with the lite version? All i want is a little DB that i can sync with my desktop.

dazz
01-29-2003, 03:02 PM
No problem mv. You can create a table and form fairly easily. The lite version will do the job quite nicely. Also, it's dead simple to do. No programming involved.

paqguy
01-29-2003, 03:04 PM
What's the performance like? Is it pretty snappy or a little sluggish?

I am using SprintDB, and while I really like the tools, the databases as a whole are pretty slow. Loading time is the biggest hurdle. Once the forms are loaded, it's not too bad, but it has almost deterred me from using it.

dazz
01-29-2003, 03:14 PM
I hear ya paqguy. Performance can be a problem if your form loads a lot of info on launch.

Fortunately there are a lot of things you can do to speed up your forms. Fields that pull info from other tables or tally info from that table on each launch will slow things down. Make sure you don't have too many of these on each form.

Also, splitting your forms up will help. When you build forms they can be much larger than the actual screen size and you build navigation buttons to move around the form. It is much better to create separate forms with link buttons to each other. Will increase the speed.

If you design for app right speed does not end up being a big factor.

Also, the list view can get bogged down. With huge tables it can be slow. Simply limit the number of fields showing in the list.

paqguy
01-29-2003, 05:15 PM
Great, thanks for the detail! I guess I'll give it a test drive.

SassKwatch
01-29-2003, 11:38 PM
Though I hate to plug another site :), PocketNow did a pretty comprehensive review of db apps available at the time approx a yr ago. And Visual CE (I believe it was in v6 at the time) was included in the review.

As I recall, it pretty much would have been the hands down winner of that review except for one annoying 'feature'. Now, I'm trying to recall this 'feature' from my not always so trusty memory, so feel free to correct me if I'm wrong, but I believe Visual CE was only capable of syncing with one Access db on the desktop pc. I.e., one could develop 5 different dbs on the PPC, but if we wanted to sync them with Access on the desktop, all 5 had to go into the same desktop db. I'm *reasonably* sure that was the limitation only because I questioned the reviewer about it at the time. Given all the nice features that existed in that version at the time, this one limitation really struck me as a showstopper.

*IF* I have recalled all the above correctly, can anyone tell me if this has changed?

Thanks!

dazz
01-30-2003, 12:07 AM
Nothing wrong with your memory SassKwatch. You are right in that you can only sync with one db. That might be a problem for developers and power users but for most users of apps built using Visual CE it won't be a problem. Remember that this has nothing to do with the Access DB's you sync through Activesync. It is ONLY for those you are using the built-in Visual CE syncing software. If you have multiple DB's just use Activesync.

SassKwatch
01-30-2003, 04:58 AM
...Remember that this has nothing to do with the Access DB's you sync through Activesync. It is ONLY for those you are using the built-in Visual CE syncing software......

Oh, that's a distinction I'd missed....and certainly changes my thinking about the app in a big way.

Now I need to go back and review the features available in each level of the product.

Thanks!

bdegroodt
01-30-2003, 07:48 PM
Anyone know if there is a trial version of the Personal version that I can monkey around with before shelling out $130?

dazz
01-30-2003, 08:00 PM
Pretty sure there is not a trial version. The best you will be able to do is the lite version for 20 bucks. You can then upgrade to the personal version and they will discount it by the 20 bucks.

Are you looking for something to create apps for yourself? What are you looking to do with it?

bdegroodt
01-30-2003, 08:07 PM
Pretty sure there is not a trial version. The best you will be able to do is the lite version for 20 bucks. You can then upgrade to the personal version and they will discount it by the 20 bucks.

Are you looking for something to create apps for yourself? What are you looking to do with it?

One of the applications my company (http://www.skillgenie.com) has designed is to aid recruiters in managing resumes and clients. It could be a cool addition for us to have a PPC version that syncs up with the client database when they come back to the office (Say from a job fair.). Won't be worth much on a sales volume level, but it's worth the press and the buzz.

I was thinking this morning (After talking to a friend that asked me why he might need a PPC.) that there are too few applications for business reasons so far for the PPC. It seems most of what I see is for personal pleasure/information. I'd love to be able to knock out an app quickly that ties into our product.

dazz
01-30-2003, 08:57 PM
BD,

I sent you a PM.