Home

Simple steps provide complex solutions

For a visual presentation, see: Designing

For those who've downloaded our evaluation version, here's some quick steps that let you quickly create a fully updateable, filterable multi-tier client application, with no code:

Start with dbOvernet by first scanning through through the Help file, to acquaint yourself with the concept of multi-tier and the components.

1. Ensure you have our ODBC-enabled dbOvernet_JET.MDB (MS Access) database installed. (check here)

2. Compile and launch server-side application and launch it

  1. Move to the Servers folder in Applications, open and Compile SimpleServerProject.DPR (don't Run it).
  2. Use Explorer to locate the compiled SimpleServerProject.EXE - Copy it and paste it on your desktop as a shortcut.
  3. Run SimpleServerProject.EXE from your desktop and leave it running. It serves as the server side.

3. Visually create a client-side application:

  1. Move to the Basic Client example. It's basically no code. Once you've had a quick look at it, select New Application from the File menu.
  2. Drop a TdbOClientDataset, a TDatasource and a TdbGrid on the form.
  3. Point the grid's Datasource to the TDatasource and the TDatasource's Dataset to the TdbOClientDataset.
  4. In the TdbOClientDataset, click any property that uses [Data Central].
  5. In Database name, select the dbOvernet_Jet alias.
  6. For Table name, select customers.
  7. Click [OK] to close the wizard.

Run the project:

  1. Run the project. If all went well, you have an updateable multi-tier application.

Notice how you didn't even have to specify a SQL expression. It was built automatically for you.

 

Add WHERE clause filters to your SQL expression

  1. Close the form and add an Edit box named Edit1.
  2. Modify the FormShow event like this:
    with dbOClientDataSet1 do
    begin
      Filter := 'companyname like ' + chr(39) + Edit1.Text + '%' +      chr(39);
      Send;
    end;
  3. Run the project. Enter a character in the Edit box and click Refresh.

That's the dbOvernet way.

Top