Results 1 to 7 of 7

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

  1. Sep 23rd, 2002, 01:21 AM #1
    Beacon
    Beacon is offline

    Thread Starter
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188

    Exclamation 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
    Reply With Quote Reply With Quote
  2. Sep 23rd, 2002, 02:32 AM #2
    frigginjerk
    frigginjerk is offline
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    San Jose, Ca. - USA
    Posts
    302

    Reports

    I see this all the time

    How can I open an MS Access Report through VB without having MS Access installed?
    Reply With Quote Reply With Quote
  3. Sep 23rd, 2002, 02:32 AM #3
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    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

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  4. Oct 11th, 2002, 12:54 AM #4
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Lightbulb ***Dynamic SQL in Oracle***

    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
    Reply With Quote Reply With Quote
  6. Oct 11th, 2002, 12:58 AM #5
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Question ** Retrieving Results Set From Oracle **

    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
    Reply With Quote Reply With Quote
  7. Oct 11th, 2002, 01:02 AM #6
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Question ** MDF File in SQL Server ***

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

    -Abhijit
    Reply With Quote Reply With Quote
  8. Oct 11th, 2002, 01:04 AM #7
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    **Adox and Oracle**

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

    Can I create vArrays and Nestedtables through ADOX?

    -Abhijit
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width