Thanks a lot Derek............
Looks like fun is starting. Now I get error "Could not convert variant type (UnicodeStrings) into type (Double)"
Also I'm missing something for pulling date fields. Following didn't do anything:
Form1.dtpCustomer_StartDate.Date := SQLExecute('SELECT start_date FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
____________________________
Edit:
It seems SQL script requires different field names for different field types.
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
Lets assume form field names are same. How would you write the above code for field types:
//Integer
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Real
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Currency
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Boolean
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
Date/Time
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Date
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Time
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Image
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Calculated field
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
//Relationship
Form1.EdCust_City.Text := SQLExecute('SELECT city FROM Customers WHERE id='+Form1.TGrid_Form1Search_Customers.sqlValue);
Adam
God... please help me become the person my dog thinks I am.