Topic: Extracting the ID number using sql and converting to a string
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.