comserving



FAQ

Developer Corner

Q: Does ComServer.i.Net  support more than standard select statements ?
A: Yes. The ComServer.i.Net  wizard supports 'simple' select statements on tables and views. If you want to see Joins in a grid, insert field names into the 'select'-window with copy&paste. Insert table names into the 'from'-window with copy&paste. Example Syntax: 'table name' LEFT OUTER JOIN 'table name' ON 'tablename.fieldname'='tablename.fieldname'
Joins and views are great for seeing data from different tables in one window. The 'Ad hoc query' function works in views and joins.

Q: Why is the number format different for editing and browsing modes in ComServer.i.Net ?
A: When you select 'Preview', the data is loaded line by line from the database. The database driver formats the data!
When 'Preview' is deselected, the field is formatted by ComServer.i.Net . ComServer.i.Net  uses the settings from the logged-on user's currency and date settings.

Q: What is the difference between ComServer.i.Net  and a 'Rapid Prototyping System' ?
A: ComServer.i.Net  uses no language other than SQL. Create '(Master/Detail) Edit Grids' using the database query wizard. There's nothing to compile: The development version is the runtime version. It depends on your logon as user, admin or owner.
But you can use ComServer.i.Net  as a 'Rapid Prototyping System'.


Q: I do not see my sql proxy tables (remote tables) in a grid.
A: First, check whether you can connect to the proxy while grid mode is 'line by line'. If this works, you have a valid connection. Now, logon to the system as 'Owner'. On the cursor menu, select 'static cursor' and use 'cursorlib.' The cursor for your proxy will now be cached on the client side.

Q: the .csm file cannot be loaded by file manager.
A: Why?: see MSDN Q148806, wrong short filename linked to file extension
Solution: uninstall any old ComServer.i.Net  version, and close all windows.
Start regedit; under HKEY_CLASSES_ROOT  delete the following entries: .csm; ComServer™.Document (in German ComServer.i.Net .Dokument); ComServer.i.Net .Menu.
Close regedit and reboot your system.
install ComServer.i.Net  1.25c,
start ComServer.i.Net  and open a file,
ComServer.i.Net  will be correctly registered again.
BE CAREFUL CHANGING THE REGISTRY. MAKE A BACKUP FIRST.

Q: My ComServer.i.Net  Project is based on a Sybase Database. When users change database field entries, ComServer.i.Net  ignores them.
A: Change your cursor settings to foreword cursor.

Q: How do you get a Join into a SQL-Grid ?
A: Create a new SQL-Grid.
Choose the database.
Copy into the select-statement: 'table'.'fieldnames'
Copy into 'from': 'table name' (LEFT OUTER) JOIN 'table name' ON 'tablename.fieldname'='tablename.fieldname'




User's Corner


Q: Sometimes I delete some data by mistake. How can I avoid this ?
A: Your ComServer.i.Net  administrator can change 'rights' in all grids to 'confirm insert/update/delete'. When you update or delete data, ComServer.i.Net  now displays a 'confirm query'.

Q: I want to search data within a complex string. Are there any wild cards available ?
A: Yes. you can use the standard ANSI SQL Wild Cards that are normally in underscore i.e. '_' to substitute one letter or use the '%' sign to substitute a complete string.

Q: ComServer.i.Net  DMS does not allow the opening of *.doc-files. Other documents like *.bmp are no problem.
A: One reason can be that your Internet Security Software settings are: 'script-blocking' = 'active'.

 

 

 

 

 
 
Contact   |   Imprint   |   References   |   FAQ