Yes it can, but MS Access 2007 databases - *.accdb files require MS Access 2007 or AccessDatabaseEngine.exeWe would like to know if WhizBase can be run with a SQL database.
Yes it can, both using an ODBC connection or ADO connection string.Does Whizbase run on NT servers and/or Unix servers?
WhizBase is a 32-bit Windows® application and will work properly on any 32-bit and 64-bit Windows® operating system (95/98/Me/2000/XP/Vista/7/NT/2003/2008/Vista/Windows 7).When deleting a record, if there are more than 1 matching records, can a list be displayed so only the correct record is removed.
Yes, but you have to set up a field that uniquely identifies every single record, and then to pass the value of that filed (as wbf_fieldname variable) to a wbsp file that perform the deletion. If WB_UID is defined inside the configuration section of the file with WB_Command set to D then WhizBase will not allow deletion of more than one record at a time.Can WhizBase use data from more tables at once?
To use data from more than one table on a single form, you have to define a complex recordset:
wb_rcdset=invoice inner join account on invoice.number=account.invoice
(of course these are sample field names - you will use real fields that make relation between your tables. In this example we have two tables invoice and account. Field named "number" in table invoice should match field named "invoice" in table account).
On the report you will refer your fields same as usual - $wbf[fieldName] but in case of fields with same name in both tables you must include table name also - $wbf[tableName.fieldName] e.g. if both your tables have field named ID then you use $wbf[account.ID] and $wbf[invoice.ID]If someone would like to search my database, it seems that they have to buy one more license?
To publish any number of databases on a single Internet domain you need only one license. Your visitors do not need WhizBase license to browse WhizBase - powered site.