Search options (Page 89 of 104)

Hello Heriberto,

From my own experience, I have actually found this forum to be the best source of tips and tricks.  Just enter something in the search option and see what comes back;  this is true whether your question is about basic MVD functionality or related to scripting or sql problems.

I think one of the first projects that most of us end up writing is our own tips and tricks application!

In terms of learning more about MVD scripting - for me, the best way was to download other people's projects and see how they had done things.  And then if I am still struggling, I simply ask the question in the forum and Dmitry or one of the other Users will usually reply to you with lots of different ways to do things.

Don't worry about asking what might seem very simple or basic questions - we were all beginners at one point.

Regards,
Derek.

Hello Teco049,
The attached project might give you some ideas.
Rather than have one tablegrid changing to show another tablegrid, I have done an example showing 3 tablegrids that are linked.
But if your design is such that you need to place one tablegrid on top of another, it is not a problem (the processing logic is just the same as in my example).
I hope this helps,
Derek.

Hi Heribertom,
Perhaps this is the sort of thing that you are looking for (see attached).  I have tried to use your screen shot as a guide but may have missed something.
Please note that if you are using an older version of MVD (2.5 or older, I think), this solution may not work.
Also note that in the combobox for hotels, I use both the hotel name and location (because there will presumably be more than one 'Sheraton' (for example), and you wouldn't know which one to choose otherwise).
Hope this is clear but if you have any questions, please just ask.
Derek.

Hi Senorlocksmith,
Your script is fine - I think I would just add  a condition and a where clause.  There are probably other ways to achieve it too but this seems the most straightforward way to me.
Please have a look at the attachment and see if this is the sort of thing that you are trying to do.
Hope this helps,
Derek.

Hello,
Do you mean saving a record by checking a checkbox?
If so, you could use a hidden 'save' button.
See attached,
Derek.

Hi Manixs,
Have a look at the attachment.
Right-click on any row and select "Show On Map" to see an embedded static map based on the post code of the selected row. 
If you want to see an interactive map, click on the 'Interactive Map' button at the bottom left of the static map. 
I wanted to embed an active map into my program rather than make an external call but hit problems.
Anyway, maybe this will be of some help to you,
Regards,
Derek.

Hi Adam,
Does the attached come closer to what you want?
If you select a purchase invoice from the grid, the frminvoice screen has a 'purchase refund' option.  The same goes for a sales invoice.
If the 'purchase refund' button is clicked, the button caption changes to 'Save Purchase Refund' and the transaction type changes to a 'Purchase Refund'.  The same goes for the 'sales refund' button.
If you select a purchase invoice refund, it automatically uses the originating purchase invoice as a cross reference.   The same goes for a sales invoice refund.
Because the script references the originating transaction automatically, I guess you don't need to be toggling the refund panel off and on (I've commented it out in the script).
The script itself is pretty messy now but there seemed little point in tidying it up until you're sure it's doing what you need.
Please note that on frminvoice, the 'purchase refund', 'sales refund', 'save purchase refund' and 'save sales refund' buttons all overlay one another (just in case you're wondering where they've all gone - LOL!).
Regards,
Derek.

Hi Adam,
You could try something like this (see attached).  There's probably other(better) ways to do it but it seems to work.
I haven't looked at anything like negating values etc - just did the actual copy/create.
Hope this helps,
Regards,
Derek

Sorry Adam, only just noticed that you'd already fixed it yourself.
Derek.

Hi Kim,
In Dmitry's solution to your 'pending' question, he needs to use a row in 'subrecords' to then read itself - once to calculate the running total and once to filter all the records that are <= to the particular date of the row.
You can't DIRECTLY refer to the same table twice (it would be ambiguous) so you need to redefine it when it's referred to a second time. 
So when he writes '.....from subrecords s........', he is redefining the second use of 'subrecords' as 's' and then subsequently uses 's.id_cereal=subrecords.id_cereal.id' etc etc.  He could just as easily have redefined it as 'subrecords2' but 's' is easier!
.
As a side issue, I often redefine tables when writing a query or script - not because I'm referring to the same table more than once, but simply to save typing (such bad habits)!  Have a look at the code below:
.
select
a.record_count,
a.salutation,
a.name,
strftime('%d-%m-%y', a.joined),
b.type,
a.phone,
a.email,
a.id
from members a, model b
.
which does exactly the same as -
.
select
members.record_count,
members.salutation,
members.name,
strftime('%d-%m-%y', members.joined),
model.type,
members.phone,
members.email,
members.id
from members, model
.
Hope all of that makes sense.
Regards,
Derek.

Hello Jean,
Thanks, I know about 'form1.combobox1.texthint' but I think this is something that only works with later versions of Windows (Vista and above?).
Some of the users I write stuff for still use XP!
Derek.