1 Reply by v_pozidis

(10 replies, posted in General)

derek and all my friends , a big thank you to all of you.  Every answerer is for me a new lesson.

Go to forum: General

2 Reply by v_pozidis

(10 replies, posted in General)

Hi friends, jean.brezhonek, Destiny,Derek,sparrow I try the example but  does not work. It loops when adding it on Form1.OnClose
When adding the frm.OnCloseQuery := @procedurename; the Cancel do not work.

Go to forum: General

3 Topic by v_pozidis

(10 replies, posted in General)

I have the following Procedure and I want when I press the Close ( X button on the right upper form )
when I add the name of the procedure (Telos) in the Form Events OnClose it doesn't work. How can I do it o show me  the messagebox from the procedure Telos?

Procedure Telos (Sender: TObject; var Cancel: boolean);   
       messagebeep(0);
         if IDNO = MessageBox('It will end , are you sure ?', 'Question', MB_YESNO+MB_ICONQUESTION) then // If the user clicked No
    begin
        Cancel := True; // If the Cancel parameter is set to True, the action that is assigned to the button will not be executed
        exit;
    end;

    frmApografi.Close;
end;

Go to forum: General

4 Reply by v_pozidis

(17 replies, posted in General)

Perfect....I really have no words for your help.

Go to forum: General

5 Reply by v_pozidis

(17 replies, posted in General)

Derek your help is priceless , Thanks' so much !!!!
Can I change the date manually when i insert a  datetime picker  ?
what's the script to insert
  sqlexecute('insert into pin (ean,perigrafi,qtypina,qtypinb,qtydiff,datesaved) ' +
        'values ("'+frmapografi.TableGrid5.cell[0,vrow].AsString+'", ' +
                '"'+frmapografi.TableGrid5.cell[1,vrow].AsString+'", ' +
                '"'+frmapografi.TableGrid5.cell[2,vrow].AsString+'", ' +
                '"'+frmapografi.TableGrid5.cell[3,vrow].AsString+'", ' +
                '"'+frmapografi.TableGrid5.cell[4,vrow].AsString+'", ' +
                '"'+ frmApografi.DateTimePicker1.DateTime);

Go to forum: General

6 Reply by v_pozidis

(17 replies, posted in General)

And another question, How can I keep the results of the tablegrid 5 (the difference ) in a table pressing the SAVE button? I have create a table Pin for storing the data's

Go to forum: General

7 Reply by v_pozidis

(17 replies, posted in General)

Thanks all of you....

Go to forum: General

8 Reply by v_pozidis

(17 replies, posted in General)

yes I know that but the idea was not to mess with the original excel that's why I'm asking for a solution. Thank you for your help.

Go to forum: General

9 Reply by v_pozidis

(17 replies, posted in General)

Hi Derek,
in my software everything works fine. What I like to do is when I press the button difference (in the third table) as you can see the EAN column is sorted. I do not want it sorted, i need it to be in the same line as in the first table. it compares the two tables ,on the  left,with almost the same values. I ask your help because my sal knowledge is very poor.

Go to forum: General

10 Reply by v_pozidis

(17 replies, posted in General)

Sorry Derek my mistake.

Go to forum: General

11 Reply by v_pozidis

(17 replies, posted in General)

Is it possible in the table with the difference  not to group by code? I try it not include in the script the last line " group by code" but the result that I get is just one line.... ..I just need it without group

Go to forum: General

12 Reply by v_pozidis

(17 replies, posted in General)

A quick question. When I enter manually the code pressing the enter and not the disk it doesn't check the procedure chechk_i_exists. I can not find any solution. I tried the properties for the edit box on key press, on enter but it doesn't work the procedure.

Go to forum: General

13 Reply by v_pozidis

(4 replies, posted in General)

Thank you Derek.
I just sow it...

Go to forum: General

14 Topic by v_pozidis

(4 replies, posted in General)

in my Project are Two tables (PinA and PinB) which they get all the data's form importing each one a differed excel file. In the Third table (PinC) it should show all the difference between the two tables from the qty when the code is the same . I try to do it but I failed. In the button under the table PinC there is a button which has an sql code but I am sure that it is wrong. please see also the calculated fields in the table PinC Iknow that I can do it with printing the excel file and using the VLOOKUP or XLOOKUP, but i need the job done in MVDB (i need it to finish my procejt)
[PinA.Qty - PinB qty when Code is the same , show code, title and the difference A-B qty's]

Go to forum: General

15 Reply by v_pozidis

(17 replies, posted in General)

Thank you so much Derek.

Go to forum: General

16 Topic by v_pozidis

(17 replies, posted in General)

In my try of creating a small program I need your help. I do not know SQL so that is the reason that I need your help.
This is for my work so really I need your help because it will help me.
A) i have an order in an exell file which contains 3 columns EAN, Description, Qty)
what I wanna do is  when I receive the order I scan or insert manually  each item and put the quantity for each one. when I finish with the procedure of delivery the order  pressing the Result button it should  export in a new table the sum for each Ean separately with the sum of the quantity I forgot to write  (when adding an product it should compare the EAN if this in the exell file. If not It should show a message that tis item does not exist in the file).
I send you my software to help me to finish it.
thank you in advance

Go to forum: General

17 Reply by v_pozidis

(2 replies, posted in General)

thank's k245

Go to forum: General

18 Topic by v_pozidis

(2 replies, posted in General)

having a table with barcode and quantity and creating an editable Tablegrid how :
When  inserting in the tablegrid which is in editable how can I make it always when I scan a barcode after the inserting in thetalegrid it should  go to the first row there where we insert the barcode and how can we add 1 item in the second colum which is the qty when scanning a barcode ?

Go to forum: General

19 Topic by v_pozidis

(0 replies, posted in General)

I need help.
I want to select the sheet from an excel file and put the data according to the column headings.
I have an excel file in the folder. I can not complete it, please help. Thank you in advance.

Go to forum: General

20 Reply by v_pozidis

(8 replies, posted in General)

You can use the RichEdit button from the menu and to save the note use from the FOrm2 the export button and save it us a txt file.
See the example

Go to forum: General

21 Reply by v_pozidis

(13 replies, posted in Script)

I also started in the past to "backup" the forum nut it took a very long time. I used HTTrack but I do not know to configure it.
Anyway thank's Destiny for sharing your file,

Go to forum: Script

22 Reply by v_pozidis

(4 replies, posted in General)

Marry Christmas and a happy 2026

Go to forum: General

23 Reply by v_pozidis

(9 replies, posted in General)

Χρόνια πολλά και Καλα Χριστούγεννα... Marry Christmas !!!

Go to forum: General

24 Topic by v_pozidis

(2 replies, posted in General)

Merry Christmas to all the MVDB friends, and wish you all the best... And in a view days a happy new year!!!

Go to forum: General

25 Reply by v_pozidis

(6 replies, posted in General)

I  thought it was in the properties., so I was searching there for this command . As you can see in the non module program there is no such a command, but it works, can not find how.

Go to forum: General