I used Softvelocity (formerly Topspeed) Clarion for Windows many years ago. When creating a new form for a table, Clarion gave an option to have either 1) a browse/table-grid form, or, 2) an Add/Edit form automatically generated. It simply took all fields for the selected table and placed them down the form with a label (the field name) and Add-Edit-Del-Exit buttons (Add/Edit form) some Save-Cancel buttons (browse form). This auto-generated form could then be modified as needed. It saved quite a bit of keyboard work and basic CRUD applications (even with many tables) could be created very, very quickly. Most of a developers time was spent on the event driven programming.
2 2017-04-19 15:08:44
Re: Phone book database (8 replies, posted in Database applications)
Hello Dmitry,
I downloaded the latest version but still get the SQL INSERT syntax error because of an apostrophe in the last name to be added.
3 2017-04-18 14:37:09
Re: Phone book database (8 replies, posted in Database applications)
I am new to MVD. When testing this sample phonebook application, I receive a SQL Syntax error if the last name entered in the textbox contains an apostrophe in a record being added (SQL INSERT). MVD does not seem to generate this error if an apostrophe is added prior to a record update.
I can also see from other forum posts that this topic has been discussed but I do not understand the preferred method for handling this common situation. Should one always use custom script (SQL Insert) for any textbox linked to a database field? Or... should one use a custom script to process the textbox before a MVD Saverecord? And if it is the second option, what string functions are available in MVD from the SysUtils Unit? "StringReplace" ??
Thank you.
4 2017-04-11 18:26:08
Topic: Script for Clipboard bitmap operations (2 replies, posted in Script)
I am very new to MVD. For a DBImage control, I would like to paste a bitmap from the clipboard instead of using the file dialog. I am not able, however, to reference the ClipBrd Unit.
The following generates an error:
uses Clipbrd;
Is this possible with MVD scripting?