Please list!!! All your commonly asked questions here!

Hi all,

This is for an FAQ i'm doing!

I need a list of all the common questions that get asked in this DB Forum!

So feel free to start listing them. I will find the answers!

thanks
b :)

I see this all the time

How can I open an MS Access Report through VB without having MS Access installed?

Lets see...


Sql Statements
- the characters around dates/strings in where clauses
- wildcard differences between Access and Sql server (and oracle etc?)


Moving around recordsets / finding / filtering
(both bound and unbound - didn't you cover this already though?)

Filling Comboa (Or flex etc) via ADO code

Creating tables in an access db via code (DAO and ADOX)

Putting controls into dbgrids (assuming people what that)

erm....



Vince

How do you fire an sql string formed inside an oracle stored procedure?

In MSSQL we tend to use sp_executeSQL which works from within a stored procedure.

What is its equivalent in Oracle?

Regards,
Abhijit

How do you retrieve a resultset from an Oracle Stored procedure if the output parameter of the stored proc has been defined as a REFCURSOR?

-Abhijit

Can I make use of an MDF File in SQL Server to restore a database?

-Abhijit

How can I create objects in an oracle database 8i using ADOX?

Can I create vArrays and Nestedtables through ADOX?

-Abhijit