Search options (Page 8 of 16)

Sent.

You can also try creating your own version of IncMonth if it is not available in ver1.44,

function AddMonth(const DateTime:TDateTime; NumberOfMonths: Integer): TDateTime;
var
    _m,_d,_y : Integer;
begin
    DecodeDate(DateTime,_y,_m,_d);
    result := EncodeDate(_y,_m+NumberOfMonths,_d);
end;

Add it in your code and you can use AddMonth just like of the IncMonth

You can try decoding and encoding the date

procedure frmFornitore_dtData_OnChange (Sender: TObject);
var
  mm,dd,yy:Integer
begin
  DecodeDate(frmFornitore.dtData.date,yy,mm,dd);
  frmFornitore.dtScadenza.date :=  EncodeDate(yy+10,mm,dd);
end;

try this one.

ShowMessage(Form1.TableGrid1.Cells[Form1.TableGrid1.SelectedRow,0]); // string

You can access the properties, functions etc by just typing the Grid, followed by dot(.)

Form1.TableGrid1.

then, Hit Ctrl+Spacebar. this will list down properties, functions, etc

Try blackpearl's example. Just add a condition before updating the grid. It'll be a bad experience for the user when navigating the grid if you reload it. unless your grid is only for viewing.

procedure updateGrid ;
begin
    if not Form1.TableGrid1.Focused then
        Form1.TableGrid1.dbUpdate;
end;

Then again, you have to consider the traffic, If you are accessing database online, then there's a drawback. It will continuously sending a request. Trap it If your grid is accessed in a popup or not in the main form by adding another condition

procedure updateGrid ;
begin
    if ((not Form1.TableGrid1.Focused) AND (Form1.Visible)) then
        Form1.TableGrid1.dbUpdate;
end;

Please check on this one please. I hope you can include it in your update.

http://myvisualdatabase.com/forum/viewtopic.php?id=7339

I love the new update, but I need the latest build of sqlite for my projects.

Don't put fsBold into array.

frm1.button1.font.style := frm1.button1.font.style - fsBold;

I think it is better to just put a button and manually update the grid
e.g.

Form1.Tablegrid1.dbUpdate;

I got some idea on how to make it auto-reload but it's kind of messy.
If you know trigger in MySQL, then you can use it to update a table (`settings` maybe) that will increment if a user add, update or delete a record in a table, then you can have a loop in script that will check on that table.
On load of your system, store that `setting` value in a global variable or store it in the refresh button's tag, etc, your choice. then if the data from database changes or not same with the data in your variable/button's tag, reload the grid.
You have to consider traffic in your server though especially if you implement this with several tablegrids.

I'm not so sure on what you really want. But here, I previously made a function involving arrays. I hope it gives you an idea to what you are looking for.

It's hard to check it without seeing all the actual script and forms. maybe if you can attach the project. Someone can see and check it.

Good Day. If you could share your application, maybe I or someone can look what's going on with it. If not, try to lay down as much as code and/or screenshot you can so we can help. It's hard to know the problem without looking at the source.