Jump to content

Osama Ghazal

Members
 View Profile  See their activity

  • Posts

    56

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by Osama Ghazal

    UniDBGrid - How start editing by keypress?

    in General

    Posted

    @Sherzod

    Ok, now it works but not very well

    it is like excel in one row only

    you should only move the cursor by Tab not by Enter and when the row is finished it stops, not moving to the next row.

    I think it is very limited not practical.

    I can't depend on them if the customer want to work inside the grid in the invoices and vouchers.

    for example:

    The customer want to enter the barcode then the qty then the price and want to begin a new line by pressing Enter Key, like TDBGGrid

    Delete row in uniDBTreeGrid

    in General

    Posted

    Hi all,

    I have a uniDBTreeGrid Connected with fdquery.

    I delete a record by this sentence:

    qryProductsTree.Delete;

    the record deleted from the table but still on the grid unless i refresh the query or refresh the grid, so it will be full collapsed.

    how can i delete the record from grid without reload the full tree and without collapsed.

    Thank you all

     

    UniDBGrid Auto Edit when I Enter the Column

    in General

    Posted

    Hi All,

    I have a UniDBGrid, I want to Edit Cells in this grid without press Enter on key board or dblclick on mouse Then type the value then press Enter again.

    and I want to skip the readonly fields

    I used hidden panel and uniedit for the field editor, and i tried the solution the you gave it to someone before by reconfigure event, but it gives me an error

    I am using Trial Version 1.90.0.1565

    Thank you

    FireDAC Transactions in MySQL and UniGUI

    in General

    Posted

    On 10/24/2022 at 10:29 PM, Abaksoft said:

     

    Hello,

    1. Your VoucherID should be  into your Global Transaction :

     

    FDConnection.StartTransaction;

    try

    VoucherID:=

    Select IfNull((Select Max(VoucherID) + 1 From vouchersheaders),1) as NewID;

    ....

    2. It seems to me you forgot to commit

    FDConnection.Commit;

    except

    FDConnection.rollback

    end;

    __________________

    I am not using FireDac. Instead i use devart technology (so easy, light and robust)

    That said, you can read :

    http://www.unigui.com/doc/online_help/index.html?firedac.htm

    Thank you for your answer.

    but Only Now I Found the problem.

    the problem is that When I Open a Cheques Form by Mistake I forget to delete StartTransaction from Onshow.

    so there is two starttransaction, one when save the voucher and other when show the cheques form.

    thank you again

    • Like 1

    FireDAC Transactions in MySQL and UniGUI

    in General

    Posted

    what i see is when I make the voucher cash payment it will execute the post command and  qrysaveAccountingEntries.execute(chRecCount,0);

    and it goes ok, and other user can found the voucher directly, but if the payments id cheques or e-wallets and run many execute commands on many tables this cause that the new voucher does not appeared on the other user until the first user add another voucher or logout from his program.

    only the last voucher don't appeared on other users, it seems that it stored in cache, put the cache update always false not true

×
×
  • Create New...