help needed....

[learn_to_program]

Hi,

I am a beginner at VB, as i am trying to program a database system, my problems is :

Currently i am using ADO method to retrieve my data and i am trying to do a search engine where i can retrieve information using wildcard like eg. to retrieve and view all company name starting with A*. I am able to do this if i am using DAO but i do not know how can i do this if i am using ADO. How to display the query that i have done?

thanks in advance

[JohnAtWork]

Use % as your wildcard, instead of *

[learn_to_program]

thanks alot for the help, it works if i use % instead of *. But now why is it % and not *, since i am able to use * when I am in the Visdata manager to do a query?

Use % as your wildcard, instead of *

[JohnAtWork]

I think it's an ANSI Std SQL conformance issue.

* is the DOS/Windows wildcard.

% is the ANSI SQL wildcard. Most databases use this.

[Clunietp]

Visdata uses DAO as its data access mechanism. In DAO, the * is the wildcard, while in ADO, the % is the wildcard. As John mentioned, % is the ANSI standard...