Search options (Page 6 of 25)

mickeywatsonnn,
The fixed project is attached. I removed "tablegrid1" from the Report Search. When included in the search the report will only report out the highlighted product in the tablegrid. When you add products it will automatically highlight that product in the tablegrid and therefore will only print that item. Removing the tablegrid from the search will print all items in the tablegrid.

MarkoS,
If you have fields already defined on the form and then you decide to insert a panel on the form, you cannot just move the fields onto the panel. You need to select all the fields you want on the panel, then do a cut and paste onto the panel. Once you do a paste onto the panel, all the fields will still be selected so you can then move them around the panel. Make sure that your panel is large enough to hold all the fields. You can always downsize the panel once you have the fields where you want them on the panel.

MarkoS,
If you do not want to use tables for storing combobox values as Derek provided, then you need to manually load the combobox through script. There are two options in how you store the combobox values. You can either store the actual text value from the combobox or you can store a numeric number (id) of the combobox value. Check out the two options in the attached example. FYI - Option 2 is the more efficient way for database applications. If you look at the raw data in the table you can see the difference between the two options in how the values are stored.

madbit71,
Try the attached.

I'm not sure if the attached is what you are looking for, but you do not need an IF statement. You can use the onChange event on the combobox to retrieve the associated image from the database.

Umbigo,
If you remove the exe from the project folder and zip the rest, you should be able to upload to the forum. Since you do have the script.pas file, you may be in luck to recover. Make sure you upload the original project folder, not one that you tried to modify. Just curious as to why your friend is not helping you with this. Hope you are not trying to pirate it.

derek,v_pozidis,
I was putting together a similar solution when I saw your post Derek. Not meant to step on you, but maybe it will give v_pozidis some additional ideas for his own project. My solution is very similar as yours. The only difference is that you can scroll through the tablegrid and display the record details. It's a tad bit more script, but some of it is not necessary. It just goes to show that there is more than one way to do things in MVD. The main point for v_pozidis is that you can still use NewRecord and ShowRecord on the same form as the tablegrid form.

There should not be a problem with that, but you will need to clear the form fields on FormShow otherwise the same fields will show up on the next form show and it will duplicate the record if you do not change the field contents. I'm not sure why you would want to do this.

unforgettable,
Just start typing in the country field and it will fill in with matching entries from the country table. He's using a combobox for displaying but the actual table field being stored is in the text field.

vohans,
dbUpdate also updates the tablegrid from MySQL. If you have the tablegrid settings defined on the form, then placing the dbUpdate after your connection, as follows, will display the records in the tablegrid.

 if MySQL.Connected then
            begin
               Form1.TableGrid1.dbUpdate;  // This will display the MySQL records if you have the fields defined in the settings of the tablegrid.
               //ShowMessage ('DB OK');
            end;

CDB,
When you build a tablegrid manually or through SqlQuery and you need to get to the dbitemId for editing, etc you need to include id in your SELECT. See below. If you do not want to see the id in the tablegrid, then you insert "delete_col" in its place in the FieldNames. 

procedure frmEditPart_OnShow (Sender: TObject; Action: string);
begin

     frmEditPart.grdEditPart.dbSQL :='SELECT p.id,p.LineNumber, i.description,p.partModel FROM products p, productsupplier i INNER JOIN products ON ' +
     'p.id = i.id GROUP BY p.id ORDER BY p.lineNumber ASC;' ;

    frmEditPart.grdEditPart.dbListFieldsNames:= 'delete_col,BSuite#,Description,Model,Part Code,Supplier';
    frmEditPart.grdEditPart.dbSQLExecute;

end;

Categories work now too.