Search options (Page 94 of 104)

Hello v_pozidis,
In that case, I suggest you don't use a script at all;  just add a button with 'show record' functionality, double-click the row in your tablegrid and the information (including the correct parent combobox functionality) will be displayed (see attached).
Derek.

Hello Knobby, EHW,
Just to try and help clarify things. 
The script that has been written is SOLELY to load data from a .csv file.  It has NOTHING to do with creating any relationship between tables.  That is done when you define your data tables.  All you need to do is to indicate you want a relationship between two tables and MVD does it for you automatically using internally generated IDs;  it is a far simpler, easier and more rigorous approach than many of the other relational database products.
The script that uploads the .csv data does not add the account number to the calls records.  The script matches the account number from the .csv file to the account number on the CLIENTS table to obtain the relevant record id (the primary key) and then uses that record id as the foreign key on the CALLS table - that is how the relationship between the two tables is maintained.  The screen capture (calls.jpg) in the attachment shows the raw data as it is held in the two tables and may help you see how it all hangs together.
If you look at the attachment, this is pretty much how your application would be if you were entering the calls manually and as you can see, everything is done without scripts.
Hope this helps,
Derek.

Morning EHwagner, Mathias, Knobby,
Thanks for the example - very nice. 
And easy to alter to suit other applications that require data to be loaded from .csv. 
A definite "keeper".
Regards,
Derek.

Hello George,
Is this the sort of thing you're after?  (see attachment).
There isn't really any book for MVD although general references for Delphi, Pascal etc might help. 
The videos that Dmitry took are a good place to learn the very basics and the help file is okay too. 
But for me, the best source for learning is the forum itself, particularly downloading various attachments and just seeing how other users have done things.
Good luck,
Derek.

Hi John,
On your frmmain.gridinvoices, you specify packageofcare as your table;  I think this should be invoices.  You then need to add the packageofcare.id onto the grid so that it can link through to pick up the client details (see attached).
On a quick 2 minute glance, there are actually a few things that jump out as possible problems (eg, there is no relationship on the invoicedetails table up to the invoices table, invoices that don't belong to any client, packages of care that don't belong to any client etc etc), and I think (not 100% sure without checking it) that when you add a bit more test data, you might find you'll get issues with data being displayed more than once on some of your forms. 
But you may be aware of these already.
Derek.

Hi John, Hi EHW,
Don't worry about it - we've all been there!
When I replied, it was more to show you the calculation of the dates and a response to your question about drawing lines, boxes etc.  So for speed, I simply populated the table that the combobox is based on using SQLITESTUDIO rather than MVD (which is why there is nothing to see)!
As this has perhaps added a degree of confusion, I've re-done it wholly within MVD which will enable you to now see where you maintain your RAIT, ICT and whatever categories.  And because I've done it 'properly' this time (LOL!), rather than hard code the number of days into the script, you can set this as part of creating your categories.
Have a look at the example and I think it will become clearer.
Derek.

Hello John,
MVD offers many different ways but I'd do it something like this (see attachment);  I've cut corners by creating the drop down directly in sqlite and hard coding the date intervals (which you wouldn't normally do) but it gives you the general idea.
Lines can be drawn to separate areas using panels (defined as thickly or as thinly as you want) but you can also use panels to wholly enclose areas.  Another option is to use groupboxes (although you don't have the same choice for changing colours). 
Hope this gets you started.
Derek.

Hi Adam,
Not sure if this is the sort of thing that you're meaning for the first part of your post (moving records from one grid to another) but I imagine it will be enough to get you started;  please see attached.
But I'm out of ideas as to how you'd achieve the second part (moving rows up and down).
Derek.

Hi Adam,
I'm a bit confused (often happens!).  In your earlier post you said you:

and your error message you wanted to display was

This is what I based the example on that I attached to you.
But in your latest post, you quote two calculation examples where the starting balances (Edit1) can be negative. 
Anyway, even if not mathematically correct, it should still enable you to see how to write the code for the situation you face.
Derek.

Evening Adam,

Getting the calculation to fire off correctly is trickier than you first think - what sequence is the user entering the figures in, do they 'tab' or 'backtab', do they backspace out a field (leaving it empty / not null / zero).
Anyways, this is the way I think I'd do it.  Probably other ways as well.
Derek.

Hi Again,
What I forgot to do (duh!) was to set the 'first item empty' object property to 'false' for the comboboxes in my earlier example;  it's not a show-stopper, but nevertheless, apologies.
Derek.