🚀 go-pugleaf

I am fairly new to the ADO side so take this with some caution, it is 
merely an idea. I am guessing from your string that Variable1 and 
Variable2 are values that will/are assigned. I think you solutions might 
be in Params. ex:

"Select * From TableName Where Field1 = :Variable1 And Field2 = :Variable2"

ADOQuery1->Parameters->ParamByName( "Variable1" )->AsString = "Hello";
ADOQuery1->Parameters->ParamByName( "Variable2" )->AsString = "World";

etc...

Notice the : in the select statement, that is a must for the params to work.

Hope this helps.

David Barnes

Michael Mouer wrote:

> Check the following please:
> 
> "Select * From TableName Where Field1 = Variable1 And Field2 = Variable2"
> 
> Error Message is "Project X.exe raised exception class EOleException with Message 'Parameter Variable1 has no default value'. Process stopped. Use Step or Run to continue."
> 
> When I substitute a literal, 123, for variable1 and literal, 456, for variable2 it works correctly.
> 
> Variable1 is a long integer and variable is a single float.
> 
> I searched the Builder and MSAccess help files to no avail.
> 
> Any help or suggestions greatly appreciated.
> 
> Michael Mouer
> 
>