I don't know how to do that, that's the reason that I need your help.
So I have two tables and I store the data to two different combo boxes.

When I choose a item form a comboboxA,  I want that in the next comboboxB  shows
items that includes for that Item I have choose and not all.
It's something like in excel when we choose FIlter options.

727

(3 replies, posted in General)

It's only a browser I can not Edit on it. Do you know anything else ?
I can not undesrund why sqlitestudio crasch on my windows? It worked well and now it crasches.

http://i58.tinypic.com/2uq12mq.jpg

728

(3 replies, posted in General)

I have downloaded the sqllitestudio2.1.5 and it crash. Somthing's wrong with a file main.tcl.
Anyway is there any alternative free tool?

729

(30 replies, posted in Script)

Hi how can i avoid the same input of a data if ti already exist in the table?

730

(5 replies, posted in Script)

could you please tell me how you did it ?

731

(5 replies, posted in Script)

Ok i did sen it !!!!

732

(5 replies, posted in Script)

I make my first serius program and i face a problem with combobox.
I have a table with the name kat1.katigoria wich I will relative with another table ypothesi.
The problem is in the form it dose't let me to choose the Namefield for the table kat1.katigoria1
I sent you the attaxhed files

733

(1 replies, posted in Script)

How can I hide a form?

734

(1 replies, posted in Script)

If there is a table with Names, and in some cases there are the same names sometimes, I like to add the Names in a combobox but if there is the same name it should not be added. So the name should be only once.

735

(12 replies, posted in Script)

Thank 's again for your help,
and a last question

How can I edit a record by scripting?
I have read the help file you have send but I can not translate it correct.
What I want to do is  when I choose from a TableGrid the Record and I like to change it,

736

(1 replies, posted in Script)

is there a way to execute program like Notepad or Paint by pressing a button?

737

(12 replies, posted in Script)

It's my mistake.
What I want to do is to delete a record choosinbg it from a talegrid.
I tried it with your code you have sent but nothing happend.

Also how ca I refresh a table after adding, updating or deleting a record?
- How can I execute pressing a button the Notepad or another program?

Thank you again for your help.

738

(12 replies, posted in Script)

the code you have sen show an error :   expected ")"

var
   idRecord: integer;
begin
   SQLExecute ('DELETE FROM omada1 WHERE id = ' + IntToStr(idRecord) +');


When I need SQL code to include in a script do I always nee to put the command SQLExecute in the beginning ?

739

(12 replies, posted in Script)

Thank you for your  help!!!!!!!!!

740

(12 replies, posted in Script)

Thank you.
Where can I find simple codes for SQL to create scripts?

741

(12 replies, posted in Script)

Table1 name is omades
Tbale2 name is omadesA

the colum of table 1 is omada1
and the colum of table 2 is omada2

so the when i write in edit2.text and edit2.text something this must be stored in the follwinf colums

In table1  in the colum omada1  the value of edit1.text
and in table2  in colum omada2 the value of edit2.text

how do I write it like this below????
because thre must be an error?
SQLExecute ('INSERT INTO omada1 (omada1)  VALUES (Edit1.Text)');
SQLExecute ('INSERT INTO omadaA (omada2) VALUES (Edit2.Text)'); 

and hoh can I delete them also?

Thank you in advance

742

(12 replies, posted in Script)

I have two tables

I would that with pressing one button to insert record in two different tables.
example
pressing a button i would add record
edit1.text = table1.name
edit2.text= table2.lastname

how can I do it?

743

(4 replies, posted in Script)

Great news.
Thank you!!!

744

(4 replies, posted in Script)

Thank you for you're quick response.
Hope that the commands are similar with pascal.
I must find a way to learn about Delphi XE3 commands.

745

(4 replies, posted in Script)

I used in the past Turbo Pascal under DOS.
But this was long ago. What kind of a Pascal version is it in MyVisulaDatabase included and where can I find the commands of Pascal?
I know I am asking questions that for some people sound stupid but I like to refresh my mind again.

Thank you in advance.

746

(1 replies, posted in Script)

How can I make this math in script ?

var
a:integer;
b:integer

begin
a:=10;
b:=20;

Form1.Label1.Caption := a+b;

end;

747

(1 replies, posted in Script)

How can I sort combobox by script ?

748

(2 replies, posted in Script)

Thank you. The last time I used pascal was on 199something (year)

749

(2 replies, posted in Script)

How do I convert a string to number. I use Val but there is an error.