Search options (Page 65 of 104)

Привет Dmitry,,
Это работает именно так, как мне нужно сейчас.
Спасибо,
Derek.

Hi Didier,
Please have a look at the attached.
Even though the form object has a property of 'autoscroll', this does not seem to work even when ticked (at least on my configuration) and so you need to explicitly code for it in a script. 
Also (again in my configuration), if your form object has a 'borderstyle' property of 'bsdialog', this will disable the scrollbar (perhaps a couple of small bugs that Dmitry could have a look at).
Regards,
Derek.

Hi,
You just need to add a check in your calculated field to see if any of the fields that are being concatenated are blank.
Try it like this:
ifnull(firstname,'')||' '||ifnull(lname,'')||' '||ifnull(oname,'')
Regards,
Derek.

Hi Dynapta, Hi Jean,
Just to expand a little on Jean's reply, you can autofit columns depending on
1.  the header (bfheader),
2.  the data in the column ()
3.  both the data and the header (bfboth). 
You can also specify, for discrete columns
4.  a specific initial column width which can be manually altered,
5.  lock the column width so that the User can't change it.
All of the above are done using a script.  Please see the attached example - in the script, each option is commented out - just remove the '//' against each option then run the example to see the effect. 
You can also use these options in combination - for example, let the data interactively adjust the column by using form1.tablegrid1.bestfitcolumns();  but prevent the User from adjusting, for example, Column0, by using form1.tablegrid1.columns[0].options := form1.tablegrid1.columns[0].options - cofixedsize;
I've probably made that sound way more complicated that it actually is - just play around with the attached example and all will be revealed (I hope - LOL!)
Derek.

Hi,
As I understand it, setting 'keypreview' to true basically allows you to process an action (in this example, using the 'enter' key) AT THE FORM LEVEL instead of writing code for each individual object on that form.
Derek.

Hi,
Perhaps the easiest way is to reformat the date using a calculated field and then just pass it through to the report and not use ReportSQL at all (see attached).
Thanks to DBK for the example.
Derek.

Hi Adam,
From your attached example, I'm not sure why you want to save each change of label as a new record in the 'label' table (unless you're going to subsequently refer to them).
Anyway, in the attachment are two suggestions.  In the first option, each label change is saved as a new record (as per your example).
In the second option, it inserts a record into the 'label' table only if that table is empty and subsequently just overwrites the record with whatever you want the changed label to be.
I'm sure there are other ways as well.
Derek.

Hi,
Try putting something like this into your script:
procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
  showmessage(towords(form1.edit1.value));
end;

procedure Form1_Button2_OnClick (Sender: TObject; var Cancel: boolean);
begin
  form1.edit1.Text := towords(form1.edit1.value);  //*** USD is the default currency - it can be changed as per the example below
//  form1.edit1.text := replacestr(form1.edit1.text,'dollars','pounds');
//  form1.edit1.text := replacestr(form1.edit1.text,'dollar','pounds');
//  form1.edit1.text := replacestr(form1.edit1.text,'cents','pence');
//  form1.edit1.text := replacestr(form1.edit1.text,'cent','pence');
end;

See attached example,
Derek

Hi Dustin,
It's possible to import data into MVD either directly from Excel or as a CSV saved from Excel.  How easy it is depends on your data structure but it's a one-off set up and after that, you just click a button.
But it might be worth you investigating MVD a bit further - entering data directly into MVD doesn't have to take any longer than Excel (it could just be the familiarity of Excel over something new).
You can actually use MVD rather like Excel with an editable tablegrid (but you wouldn't really be playing to its strengths).  Depending on how you structure your application and how you design your forms, data input can be quick and data validation is relatively easy to set up.
Attached is a dummy project that I knocked up to give you a quick feel for things you can do with MVD.  Just open the .vdb file in MVD and then run it.
I've arbitrarily shown a left hand tablegrid with School Weeks and a right hand tablegrid with Pupils.  Click on rows in either tablegrid to display the relevant information in the middle tablegrid.
I've chosen to enter data by school week no' - to add a record, just click the 'add' button and select from the comboboxes (which are all searchable so, for example, just typing a couple of characters quickly finds the relevant entry).
Hopefully, this gives you some ideas,
Regards,
Derek.

Hi Jean,
Glad to be of help.
You can also do the same thing in a script - for example 
sqlexecute('select firstname||" "||lmiddlename||" "||lastname||" "||email from people where id ='  etc etc) which can avoid lots of 'selects' and then joining fields together.
Of course, if you use this to output to a tablegrid, you then need to loop through the tablegrid, so a calculated field is often simpler.
Derek.