i am confusing using Prepare when setting parameters, should i set the values before prepare or after :
SQLQuery.Prepare; <-------------------HERE
SQLQuery.ParamByName('Param').AsString := 'YourValue';
SQLQuery.Prepare; <------------------- OR HERE
SQLQuery.Execute;
Thanks
John