weird adoquery behavior
Posted on 2004-11-06
Alright so the problem is that I have a onevent function that executes and after Memo.Lines.Add starting query the function just quits and none of the other functions below that execute now if i take out the ADOQuery functions it works fine... Whats wrong with it? Basicly Im looking to just lookup an person_id by quering a table by the phone number.
It will only return one record...
Any advice would be great
ADOQuery1.SQL.Text:='select * from linkcallperson where phone_number = ' + QuotedStr(Trim(number));
if not VarIsNull(ADOQuery1.FieldValues['person_id']) then
person_id := String(ADOQuery1.FieldValues['person_id'])
person_id := '';