Search options (Page 100 of 102)

Hi,
I am not sure if you have a need to store the cars you 'buy' and the cars you 'sell' in 2 separate tables with all the extra problems that might cause.
You could use just 1 table with extra fields to hold additional information about the 'sold price', 'sold date' etc.
Then all you need is 2 grids with filters - one grid automatically shows cars that haven't been sold (for example, with a 'sold price = 0.00) and the other grid automatically shows cars that have been sold (sold price > 0.00).
I have attached a little example of how I might do it if it helps.
Derek.

Hi TCOTON,
I thought that when I first had the problem so tried it with just 2 conditions but it still didn't work.
And then I left outer joined instead - and still it didn't like it!  There is something wrong somewhere but I can't find it!
The only way I have got it to work is by using separate search fields for each column in the grid rather than using an SQLQUERY;  if I can't fix it, I may end up doing that on all the other columns as well, but it isn't quite the way I wanted it to be done.
Thanks again for your interest.
Derek.

Hi Dmitry,

Thanks for your help.  What I have also done is copy your extra code from the tablegrid_oncellclick procedure and added it to the tablegrid_onkeyup procedure and now the filtered list stays in place to allow me to work through it.  It's 100% working!

I have 2 other questions please. 
1.  My SQLQuery searches for values in ALL fields and works okay except with the MODEL.model field.  For example, if I enter 'Volkswagen' into my SQLQuery, 4 rows are found (PIC1.jpg) but if I enter 'Golf', nothing is found (PIC2.jpg).  Can you see if there is anything wrong with my query?

2.  I have 2 currency fields that are displayed in the basic grid correctly (right hand justified).  But when I use the SQLQuery, the result shows in the grid as left hand justified (PIC3.jpg).  Is this a bug or do I need to explicitly format currency fields in the SQLQuery itself?

Thanks again for you help,

Derek,

Hi Imcisco, Hi Jean, Hi Dmitry,

I see that Jean has already mentioned enabling 'auto execution of the query' on your list forms.

With regard to the other problem,  as your project stands at the moment, when you select a row in the FormSearch grid, it passes through the Design Name and SKU fields to FormInventory.  However, you need to add a button to act as a SEARCH, using the Design Name and/or SKU as the search parameters.

This isn't particularly 'slick' because you still need to 'click' the Search Button to see the effect.  So as an extra step, you can write a script to simulate the 'click'.  And if you've done that, you could also make the Search Button invisible so the User isn't even aware that this is happening.

I've done this in the attached zip file so you can run it and see if it's addresses your problem.  So.....
1) manually click the Search button on FormInventory to see the effect
2) go to the script tab and remove the // against the line  //forminventory.button1.click;   it now runs automatically
3) on FormInventory, change the Search Button property to 'visible' = false and run it again.

Hope this helps.

Derek.

Hi Tcoton,

With mandatory fields, as well as using .setfocus to take the User back to a field they've missed, I like to set it to a different color (as a non too subtle reminder!).  So, in Dmitry's code, you'd also have

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
    if (Form1.ComboBox1.dbItemID = 4) and (not Form1.DateTimePicker1.Checked) then
    begin
        ShowMessage('Date is mandatory field.');
        Form1.DateTimePicker1.Color := clred;
        Form1.DateTimePicker1.SetFocus;
        Cancel := True;
    end;
end;

Maybe that helps.

Derek.

Hi TCOTON,

I do much the same thing when the value in an edit field changes - I imagine it's exactly the same for a checkbox.

procedure form1_Edit1_OnExit (Sender: string);
begin
  if   form1.edit1.text   =     'ABC123'  then form1.color := $0066CCFF;
  if   form1.edit1.Text <>   'ABC123'  then form1.color := $00DCD9AF;
end;

Hope it helps and good luck,

Derek.

Hi Dmitry, Hi Eddie,

At first, I had defined the 'ratings' field as text and displayed in the grid '*' instead of '1', '** instead of '2' and '***' instead of  '3'.  This worked quite well and the script was very simple. 

But I then redefined the 'ratings' field as integer and displayed '1', '2' and '3' in the grid because I wanted to use tablegrid footers to calculate averages.

But visually, the way you have done it looks much more professional.   I have not seen Form1.TableGrid1.Columns.InsertGraphicColumn(n) used in the tablegrid lke this before - it will be very useful for new projects.

Thanks again,
Derek.

Hi Heribertom6466.
I had a similar requirement a while back.
My solution, although not as slick as I'd have liked (but it was quick and it worked) was to import an image of 5 Star ratings onto my form and then align 5 check boxes against the image.
When one of the check boxes was ticked, I then 'greyed out' the other 4 by script to stop people from using more than just 1 rating.
Depending on how you want to structure your table, you could have 5 fields (one for each star rating) or, as I did, have just 1 field and populate it with a value (1-5) depending on which of the 5 check boxes has been ticked (obviously, when re-displaying the form, you then need to take the field value and work out which one of the 5 check boxes gets the tick!).
Hope this helps and maybe gives you some ideas,
Derek.

Hi Jean,
Glad it helped.
Now you can go on holiday and not be thinking about it!
Derek.

Hi Again TCOTON,
Just a thought - to give the effect of a User clicks 'add' ----> pop-up with a droplist,  could you instead click 'add' ----> call a form which contains menu buttons which, when clicked,  then show different forms depending on what you need to do? (please see attached).
Derek