Attn: Database Gurus

[lathodio]

I am developing a User Interface that will do the following,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1)View Records from an mdb format<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2)Update Records <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3)Print Records<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4)Query Records<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am having problems with the query part.&nbsp;&nbsp;I am using an mdb database<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;format.&nbsp;&nbsp;I am using adodc for the data object, however I can not figure out how<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;to get the adodc control to query conditional datafields form the mdb database.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Should I use another approch or should I use another control for accessing the<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mdb file?

 

[calahans]

To create queries you will need an idea of SQL. SQL is very simple - there are four main command types:<br><br>SELECT - To retrieve information from a table<br>&nbsp;&nbsp;&nbsp;&nbsp;SELECT * FROM TABLE1[/tab]<br><br>UPDATE - to update contentsd of a particular record<br>&nbsp;&nbsp;&nbsp;&nbsp;UPDATE TABLE1 SET COL='CAL' WHERE COL='DAVEY'[/tab]<br><br>INSERT - to add a record<br>&nbsp;&nbsp;&nbsp;&nbsp;INSERT INTO TABLE1 VALUES (1,2,'Hello','T')[/tab]<br><br>DELETE - to remove recs<br>&nbsp;&nbsp;&nbsp;&nbsp;DELETE FROM TABLE1 WHERE COL2&gt;1000[/tab]<br><br>You will be using the SELECT with a WHERE clause at the end - to narrow your search. Look on the web for a tutorial in SQL there are thousands!!<br><br>Cal<br>

 

[DougP]

OK did you look at the Form Wizard that comes with VB<br>It does 3 out of th e4 items you want.<br>And you can use &quot;Cal's&quot; SQL to query your data.<br>

 

[Zahir]

why dont u use DataEnvironment for your task,it is easy and&nbsp;&nbsp;controlled and you can handle it .<br><br>Zahir<br><br><br>

 

[Karl Blessing]

in my opinion if you learn SQL and possibly ADO, the ability to use databases beyound the DataEnviroment control is more essential. ( I use SQL Query Commands in ADO in both VB and VC++ ), and its still just as good, especially since if you got a complex select query, you can make the query design in Access then goto &quot;SQL View&quot; to get the Sql command to use <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML, ASP(somewhat), QBasic(least i didnt start with COBOL)