Search options (Page 1 of 2)

Hi

This is a similar question that I had but with a twist (I previously could use a GRID to get an SQL reference but now I am using a different Table and only have a combobox as a point of connection)

I want to force an answer into a combobox from a different table. It works with a Textbox, but not with Combobox

The reason behind my crazy, is that I can get the users to use the search button with the combobox (otherwise I wouldn't know how to get around this problem)..

Here are 2 lines of code similar in function but information placed in 2 different formats (TEXTBOX and COMBOBOX) I just get a blank in combobox..

*** From a selection of a condobox = cdClientResource,  you will look up the table dbManager of ManagerNameCombined and place it in Combobox

Push to a text box (ClientManagerText)

# 1

fmClient.ClientManagerText.text:=SQLExecute('Select ResManagerText FROM dbResource WHERE id= '+fmclient.cbClientResource.sqlvalue);

Push to a combo box (cbClientManager.)

# 2
fmclient.cbClientManager.text:=SQLExecute('Select ResManagerText FROM dbResource WHERE id= '+fmclient.cbClientResource.sqlvalue);

see ATTACHED PDF. I find it hard to explain my problem.

Hi all

If there is anybody that help me solve this issue. 
I've gotten his far in my search with my minimal on going learning of SQL.

I want to filter everybody over a certain age.
Originally I was scripting everybody's AGE and saving in the table. I then realized that it wouldn't get updated automatically and would have to go into everybody's account and press save.

So I know the answer lies in SQL and came up with some kind of logic !
I know it doesn't work but Im missing the gaps of programming to get it going.

At Form startup (SQL QUERY)

        SELECT client, message, FROM dbclient
        WHERE
                date(Datebirth) – curdate() >= 58;

Result is sent to a table.

Does this make any sense ?

      fform.combobox1.dbSQLExecute('SELECT id FROM dbClientName WHERE id='+fmClientsSearch.TableGrid1.sqlValue);   

I'd like to basically force an answer into a combo box, as I am limited in my programming skills, this would be a quick loop around  my problem.

(p.s. what is in the fmclientSearch.TableGrid would be the same list that would be available in the combo box)

Help and thanks to anyone.

Hi Everybody

I am trying to extract the ID number (For example : of a client) by using SQL, convert that Number into a string.

I then will use that Number(id) to "INSERT INTO database (Client, Update, price) values ('id','On Hold', 'Price pending');

So my question has 2 parts.

1) Extracting the id using sql using Delphi scripting:   
     
Example ( I can do this which extracts the info but not the ID) 
fmGroupPresence.GroupProgressClientName.Text:= SQLExecute('SELECT txClientName FROM dtClientName WHERE id='+fmClientSearh.TableGrid1.sqlValue);

2) How to insert a string into an sql using sql. I will be using the SQL BUTTON , which all is done in mysql..

Example (as a test ive forced info into the table by doing this, but would need the client number to be scripted.)

insert into dtFollowing(id_dtClientName,ProgressEdited,txtTitle,txNote)  values ('23','Yes','Test','Testnote');         

Sorry Im not more clear as I don't have the lingo used to explain what i need to do.

Thanks for your help.

Jeff

Hi All, hope you guys can help or lead me to the right direction.

Now that I've built an application, I would like to share it with people at work. With one click at a hidden button, I could the necessary tables and clear the tables.  I've tried this code as a test in a testing environment.

procedure fmMainMenu_Button7_OnClick (Sender: TObject; var Cancel: boolean);
     begin
             SQLExecute('DELETE FROM dtTimeTableListing');
     end;

Yet I get the following message:

Error Message
FFOREIGN KEY constraint failed

Script: SQLExecute.

I am assuming the cause is links between other tables ? !

I've done as much research as my "PROGRAMMER WANT-TO-BE" brain can handle and would need simple coding to clear tables I think i need to before it becomes too spaghetti programming for my mind.

Also, am I on the right track to think, that one needs clear the links of secondary tables that feed to a main table ? (Does my sentence may any sense ?)

Thanks for your help everybody.

Hi, as I am now up to the point of learning how  SQL works, my question is probably very basic but part of the learning curve.

I seem unable to find how you search for an individual from a parent grid.

I am trying to sort info form a table using a "Client name" that has been selected in an earlier grid/form.

See my pic for a visual example and here is my script.

form2.totalExpense.Value := SQLExecute('SELECT TOTAL(amount) FROM expense WHERE 'Status' = "expense" AND   ???? Name of client on form matches id of table expense ?????   ');

Hi Everybody

I'm looking for a command that will open either a file or url depending on what is in the TABLE
Best I could come up with was the following (and it ain't working);

var S : String ;
uses ShellApi;

begin
       s :=SQLExecute('SELECT Menu1URL2 FROM MainDatabase WHERE id=1');
        ShellExecute(Handle,'open',s,nil,nil, SW_SHOWNORMAL);
end;

Far from being a programmer  anything too complicated and it  starts looking like spaghetti.
Thanks for your help

Mike