Very Computer

Hi!

I saw in VB6 there is this new way cool and way timesaving new thing: THe DataEnvironment.
great!, but... when I create a command on a connection, and I want to create a parameter
query using the sqlbuilder, it doesn't understand the parameters, even if I set the
parameter prefix and suffix correct. So it's not possible for me now to use
parameterdriven commands, and the DE is then rather useless :(

has anybody had the same problem? is there a way to create these parameterqueries
? The help doesn't say much about this subject, and if I define a parameter with
prefix % and suffix %, and type under criteria: =%MyVar% it can't do it.. It's not
appearing under parameters :(

I use an ODBClink to an access97 database as connection.

Please help ! :)

Thanks!

    FB

I'm using it mostly for SQL Server at the moment, but I just hooked it up
to Access for a play.  One thing you could do, is create a
parameterised query in the database first, and then change Database
object to View, and pick your new query.  This has the advantage of
course, that Access precompiles the query, and should therefore be
faster.

Quote:> I saw in VB6 there is this new way cool and way timesaving new thing: THe DataEnvironment.
> great!, but... when I create a command on a connection, and I want to create a parameter
> query using the sqlbuilder, it doesn't understand the parameters, even if I set the
> parameter prefix and suffix correct. So it's not possible for me now to use
> parameterdriven commands, and the DE is then rather useless :(

> has anybody had the same problem? is there a way to create these parameterqueries
> ? The help doesn't say much about this subject, and if I define a parameter with
> prefix % and suffix %, and type under criteria: =%MyVar% it can't do it.. It's not
> appearing under parameters :(

        FB

TIA,

// Juergen