Corrupted project, been piecing it back together but...

[RTollison 0]

I have an ADOQuery that gets changed based upon user selection.

when it changes to a distinct option i get an error saying adoquery.field.app not found. But if i take the command text and paste it into sql query and run it i get the results that i need.

In my form, comparing to a very old version of the form i see these lines added

    ADOQuery1id: TStringField;
    ADOQuery1app: TStringField;
    ADOQuery1version: TStringField;
    ADOQuery1Patch_Version: TStringField;
    ADOQuery1Patch_Level: TStringField;

when i remove those lines from the form and try to compile i get an error 'Class TStringfield not found'

but in my uses i have the Data.DB added.

The query is tied to a datasource that is tied to a smdbgrid.

I know the query is correct, but i suspect that since those fields were added to the form it is wanting to reference them or something.

[RTollison 0]

Never mind found a solution. use the view as text and saw the fields defined in there and removed them all and now it compiles and runs correctly.