Very Computer

by **Terry Hoope** » Tue, 27 Jun 2000 04:00:00

Is there some way to create a command type of text string with parameters
and then append those parameters to the ADO command object? I know this can
be
done with stored procs but I was wondering about straight SQL. We're
converting an app from Access to SQL Server and we want to minimize
conversion effort and not do stored procs for now.

Thanks.

by **Lon Weis** » Tue, 27 Jun 2000 04:00:00

I don't think it is possible to do exactly what you want but try this. Build
your SQL string in access and add the parameters as variables in the
appropriate spots. Then set the recordsource = str, where str is your sql
statement with the variables in it. If you are using this to populate a
combo box you can avoid ADO.

If this is not what you want be more specific and post some of your code for
review.

--
Lon Weiss

Very Computer

ADO, Parameters and SQL Strings (not stored procs) in SQL Server

ADO, Parameters and SQL Strings (not stored procs) in SQL Server

ADO, Parameters and SQL Strings (not stored procs) in SQL Server