Search options (Page 1 of 2)

Hi all

I want to add checkbox in a table grid and found multiple references on how to do it, but none explain how they create the #Checkbox and #Auto-Number.

I've been on this for a while but can't make sense of it..

I linked an image showing what I want, which are in the table grid.
TKS.

Hi Everybody

I'm a beginner in scripting and attempted to find the answer in the form but might not have had the vocabulary to getting about finding what I wanted.

I am working with a waiting list for clients such that I need to update the whole database of how many days people have been waiting.

An initial date has been entered when a request was made, but unless I enter in each file manually and save the database will not update how many days the client is waiting.

I am use this script when I enter the form (Onshow) and when I click the Save button to update the table.

VAR
    // Calculate number of days client on waiting list.
    i : integer;
    iDays: integer;
    start, stop: integer;

Begin    // Calculate the number of days client is on waiting list.
    if ClientCreate.DateAssigned.Checked = false  then
         begin
            iDays := 0;
            start := Trunc (ClientCreate.DateDiscipline.date);
            stop := Trunc (date);
                 for i := start to stop do
                         Inc(iDays);
                Begin
                      ClientCreate.ClientDaysWaiting.Value := iDays;         
                end;
         end;

I would like to have a script that upon entering the main menu, the table for all the clients is updated automatically.

Any help would be greatly appreicated.

Tks.
Jeff

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.