Search options (Page 34 of 42)

Thanks a lot Guys..........

Thank you very much Dmitry...........

I didn't realize that I had to use both procedure. It works just as I wanted. Thanks again.

Hi JB,

Thanks for the suggestion...

Unless, I did something wrong it still launches both forms on double click.

Hi Derek,

Thanks a lot for the example... Appreciated...

I posted the below on a separate topic but if you are around could you please answer:

procedure Form1_tgSearchSaleInv_OnCellDoubleClick (Sender: string; ACol, ARow: Integer);
begin
     //Script for replacing double click action on a tGrid record with show records button action please....

end;

If the above is not doable then disabling tGrid CellDoubleClick or DoubleClick (whichever is the correct one) could do the job.
Therefore in this situation I'd be just using Edit button for editing selected inv.

I used two form for adding inv and Redund and two edit buttons on same form1/Sale Inv / tGrid. Buttons work OK but double click on a record on tGrid launches both forms.

Hi ehwagner and Derek.

Thank you very much for your suggestions guys......

In line of ehwagner's simple approach suggestion, I altered the project and put together something. I used boolean checkboxes as a filter. I don't know if it's done correctly though.

However, I have one issue with it.
On Form1 / Invoices tab / Refund Selected Invoice button (button14)  used as show records action to get selected invoice details on "frmCR_SaleRefund" form.
It does the job but it causes to load both "frmSaleInv" and "frmCR_SaleRefund" at same time when double clicked  on a record on Form1 / Invoices tab /  "Refund Selected Invoice" (button14)
I'm thinking putting double click event for "tgSearchSaleInv" or onclick event for the button "Refund Selected Invoice" (button14) needed and I couldn't do either of them.

Derek, I look forward to your version implementation.

Please see updated sample project.

Dmitry,

Error occurs during tGrid cells data add/edit then save (Clicking on next row once finished adding values) when #(Auto Increment) used on tGrid settings.

Followings are my shortcomings, I don't think they are related to app bug. That was the reason I asked for example projects. Anyhow, I have created one with errors that I cannot resolve.

1. When adding/Editing data to a tGrid via another form and tGrid I get multiple records displayed on secondary table. (Form1 Invoices and Customers / Forms Inv and Customer)

2. I couldn't get linked all (comboboxes) work. Please see Inv form

3. I have no idea how to calculate on Inv form the followings:
net price= (qty * unit price)
tax amount = (net price * tax rate / 100)
item total= (net price +Tax amount)
I like to put calculation scripts on script page not within fields on db tables as calc fields.

4. Db Image field didn't work in tGrid cell. Perhaps it's not supported yet.

5. It'd be nice to have Add / Edit buttons for tGrid on same form as it wont't be clear for many users clicking on tGrid cells at first. Clicking on Add would put cursor on first available cell. Clicking on edit button would place cursor on on first editable cell of selected record on tGrid.

Hi Dmitry,

I'm trying to do:

1. Select an invoice on Form1 / Sale Invoices tab and click on "Refund Selected Invoice" button to display selected invoice details on "frmCR_SaleRefund"

2. If required edit (partial refund ) and save the data displayed on "frmCR_SaleRefund" to "crSaleInvRefund" / "crSaleInvRefundItems"

3. Change the color or add some indication to the original invoice on Form1 / Sale Invoices tab on save of the refunds so  that  invoice has a refund indication.

I have commented out script lines produced errors and I couldn't correct..

Please see the updated sample project.

Thanks a lot guys........

I'm trying to copy one field value to another.

I like to copy Deliv Cost field value (on form calc) into Plus Deliv Cost field to include in calc as seen on the image above.

I have tried

procedure CalculateTotal;
frmTest.edTestDelivCostPlus.Value := frmTest.edTestDelivCost.Value;

The above script crashes the app on compile?

ps/. I know there is an issue on tax calc as items tax rates can be different. I think I'll have to calc discount separately and copy similar to deliv cost. However, suggestions are welcome.

Hi pozidis,

Most likely you know about button properties: enable (True/False) and visible (True/False)

If you are after conditional enable/disable then check out Derek's solution and see if it provides any answer for you:
http://myvisualdatabase.com/forum/viewtopic.php?id=2931