1 Topic by alsu (edited by alsu 2014-10-16 06:56:19)

  • alsu
  • Member
  • Offline
  • Registered: 2014-08-27
  • Posts: 52

Topic: more than one data at same time

sir, i made one database table using two fields (data1 and data 2) . is  it possible to save after filling more than one data  in a same datafield.?

any script.  thanks

Post's attachments

Attachment icon example.zip 334.29 kb, 563 downloads since 2014-10-16 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: more than one data at same time

Using script and SQL query, you can do it

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
     SQLExecute('INSERT INTO table1 (data1, data2) VALUES ("' + Form1.edData11.Text + '","' + Form1.edData21.Text + '")');
     SQLExecute('INSERT INTO table1 (data1, data2) VALUES ("' + Form1.edData12.Text + '","' + Form1.edData22.Text + '")');
     SQLExecute('INSERT INTO table1 (data1, data2) VALUES ("' + Form1.edData13.Text + '","' + Form1.edData23.Text + '")');
     Form1.TableGrid1.dbUpdate;
end;


Please, download example project.

Post's attachments

Attachment icon example2.zip 3 kb, 561 downloads since 2014-10-16 

Dmitry.
  • alsu
  • Member
  • Offline
  • Registered: 2014-08-27
  • Posts: 52

Re: more than one data at same time

img]thanks for ur quick reply...............
this is actually i need... but sir my actual planing not succes because all datas are showing in the table grid...
   any scope?

Post's attachments

Attachment icon example3.zip 334.25 kb, 563 downloads since 2014-10-16 

  • alsu
  • Member
  • Offline
  • Registered: 2014-08-27
  • Posts: 52

Re: more than one data at same time

check this

  • Registered: 2014-02-14
  • Posts: 10,294

Re: more than one data at same time

in your case, you need another table


Please, download project

Post's attachments

Attachment icon example4.zip 4.36 kb, 595 downloads since 2014-10-16 

Dmitry.

6 Reply by alsu (edited by alsu 2014-10-17 18:27:21)

  • alsu
  • Member
  • Offline
  • Registered: 2014-08-27
  • Posts: 52

Re: more than one data at same time

i am again..... and thankyou



sir thats working fine .. but canot making report.. if trying to making report only one data will display....and make a editing in table grid data it canot display report.....? any help..? 

sir if this is not possible please tell me, how to save only the field contain data?  ( i mean  script for  at the time of saving the vaccent field not include)

Post's attachments

Attachment icon New folder (7).zip 333.58 kb, 587 downloads since 2014-10-17