Search options (Page 67 of 104)

Hello Peacemaker,
I've just had a quick look at your project and I'd make the following comments.
1.  The dropdown boxes are working correctly but you have hidden form1.button1 and form1.button3 so no values have yet been entered for 'type' and 'rsotype'.
2.  Form2.button8 has been defined as 'showform'  Your 'rso' data is actually being saved but incompletely (rso. id_document is blank).  In other words, the 'rso' record doesn't know which 'document' record it is related to.  Use 'newrecord' instead of 'showform' and rso.id_document should get filled in correctly.
3.  The 'show cost breakdown' button has also been defined as 'showform' rather than 'newrecord' so, same problem as 2) above.
4.  I would use editable tablegrids on Form4 and Form5 - the way you have done it does work but makes it very easy to create both blank entries and duplicate entries.
5.  I am not sure why you are using a separate cost table if you have a fixed number of discrete fields (4) for 'food', 'supplies', 'transport' and 'expenses' - you might just as well delete the 'cost' table and hold them as discrete fields on the 'document' table which will simplify things.
6.  Whether you hold your costs in a 'cost' table or as part of the 'document' table, I would use a calculated field to get the 'totalcost' rather than store it which is data inefficient.
7.  Irrespective of where you hold your costs, they should be defined either as 'currency' or 'real', not 'text'.
8.  In your script, you are hiding frmlogin once the user has successfully logged in - this leaves the application running even when the user has logged off.
There may be other things - I've only had a few minutes to look.
Regards,
Derek.
..
..
Sorry Jean - only just seen your earlier reply.

Hello Kristof,
I don't believe you can directly display the table ID of a record on a form, so I'd simply use a calculated field instead.
But if you want to perform an sqlexecute statement based on the ID of the record, the ID doesn't actually need to be displayed anywhere - you should be able to retrieve it from the calling form's tablegrid ID  - 
sqlexecute('select fieldname from tablename where id =' +form1.tablegrid1.sqlvalue);
Derek.

Hi Darek,
I'd use a calculated field to get the count of nominations in each category.
In your 'categories' table, add a calculated field and attach the following code:
(select count(id) from nominations where nominations.id_categories = categories.id)   
Then add this calculated field to tablegrid1 in Formcat.
Derek.

Hi DBK,
Perhaps the relationship is incorrectly specified.
Can you attach your project and I'll have a look.
Derek.

Hi DBK,
The calculated field in your example is, at its core, like this:
(case
when id_type = 1 then name
when id_type = 2 then company     
end)   
The other elements are simply to add the text literals '(C) ' and '(P) ' and the || is the way in which you join two or more fields (or a text literal and a field etc etc) together when using calculated fields.
I guess it's like any syntax rules ........ you simply get used to them after a while!
Derek.

Hi DBK,
If you want to clear all the fields, you can use 'componentcount' and loop through all the fields on your form, clearing each of them (use button4 on form1 in the attached example).
However, rather than use 'showmodal', you could just use a normal button with a 'new record' action associated with it - but hide the button.  Then when you click on your 'new record' image, the hidden button associated with the image is clicked by your script (see attached example);
procedure Form1_Image1_OnClick (Sender: TObject);
begin
  form1.button1.click;
end;
This then avoids all the issues with clearing fields, using modal forms etc etc.
Hope this helps,
Derek.

Hi Adam,
Drag and drop is actually supported (see screen capture), although note that it doesn't drag child nodes with it (which may or may not be what you want).
But the real problem is saving the node in its new place in the structure.   Saving re-sorted nodes alphabetically within the structure isn't a problem but you mentioned in an earlier post that you wanted to do it 'freehand' and that, as far as I understand it, is a different matter altogether.  I can't think of a straightforward way of doing it - I wondered if it might have been possible using 'autoincrement' but I believe it's only supported with tablegrids and not treeviews.
Derek.

Hi DBK,
It's the button that is causing a problem;  there are a couple of things to mention.
1.  Your 'add' button is trying to save the tablegrid (see screenshot.jpg highlighted in red) rather than fields.
2.  If you use editable tablegrids you don't need 'add', 'edit' or 'save' buttons at all.
3.  (this is the actual error).  If a button has it's 'default' property set (see screenshot.jpg highlighted in blue) then whenever 'enter' is pressed, the button is clicked (because it's the default!).  So what is happening is when you press 'enter' to save the editable tablegrid data, it is clicking the 'add' button instead - and then giving you the error.
To fix it, either set the 'default' property for the button to 'false' or remove the button completely - it's not currently doing anything.
Hope this makes sense.
Derek.

Hi DBK,
If you can attach your project, I'll have a look and see if I can spot anything.
Derek.

Hi Adam,
Are you trying to move things in the Tree so that they are sorted alphabetically or are you wanting to move child nodes to a different parent node?
Derek.

Hi Darek,
I had a bit of time so I added a couple of things to your project that may be useful.
1.  Now you can enter a nominee in the 'Nominee' search box (for example  'John Wayne' and select a film from the Nominations tablegrid (for example 'True Grit') and this will select films called 'True Grit' into the Films tablegrid.  Then click on 'True Grit' in the Films tablegrid to see ALL of the nominations for that film in the Nominations tablegrid .......  So now it is easier to go back and forth between the two tablegrids.
2.  Click on the 'Oscar' image to link to the academyawards website.
3.  Click on the 'Tomato' image to link to www.rottentomatoes.com website for film reviews (it finds most of them).
Hope this helps to give you ideas for your project and some of the things that MVD is able to do.
Derek.

Thanks Dmitry.