Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bookor

  1. bookor

    switchboard quit working

    I have several workstations where the switchboard suddenly quit working. On other workstations everything still works properly,  but on the problem stations I get an error when switchboard tries to set up a database variable. Im almost positive there's an mdac or dcom problem but cant...
  2. bookor

    query on date field

    I need to query on a date field on a forms 4.5 form. This is NOT a sql query. In a sql select its easy enough to to_char the date and trim the time portion. However, I cant seem to find any way to do it on a form so I can do an oracle "form query." The query always fails to find the date even...
  3. bookor

    connection to Crystal Reports

    Download the Data Access Components from Microsoft. That will give you the ODBC drivers. Ive never been able to get the Oracle provided ODBCD driver to work.<br> <br> As stated above you have to have sql/net or Net8 installed on your client and configured correctly.<br> <br> In ODBC...
  4. bookor

    run_product question

    I currently use a front end Oracle Forms 4.5 form with buttons that use run_product to submit Reports 2.5 reports. Lets say I have three or four form letters in Reports 2.5 submitted based on a SSN parameter. I want to submit several reports with the same button, for the same employee without...
  5. bookor

    Anybody out there interested in talking about MS multitier dev issues?

    This may be off the subject a bit, but Ive been working with Vb for a while and the last year or so using vb and access as a front end for Oracle databases, and some asp for providing data to web browsers and I end up spending most of my time trying to keep clients, odbc, mdac components etc...
  6. bookor

    date range calculations

    You got that right. I have trouble remembering why I did something yesterday....:)<br> <br> Having a summary table always seemed like the most practical way to handle this problem, but I couldnt get over the feeling I was taking the easy way out just to avoid having to solve the problem in sql...
  7. bookor

    date range calculations

    I have a hospital application where I want to report on demographics of residents (male, female, black, white, etc), the average daily population of the facility, and the average length of stay. I have a person table with the demographics and a movement table which gives me the dates and times...
  8. bookor

    Developer 2000 on the web

    I have several GUI forms that I would like to migrate to a browser form, what is the best way to pursue this migration? Has anyone actually converted existing developer forms to browser forms?<br> <br>
  9. bookor

    secret to developing applications

    At least its not just me then. If win2000 could solve this one problem that would make it worth the upgrade. Our last workstations were NT workstation so we are better able to lock the users out of making changes, installing software etc. <br> <br> Ive done a couple "front ends" to Oracle...
  10. bookor

    secret to developing applications

    There must be a secret. Ive been working with vb since version 4 now up to 6. Ive developed several applications including a simple personnel database. But there is one problem I have not been able to overcome, either with vb or access applications. I still can not create an application that...
  11. bookor

    Access Database - 450 MB, 700000 records - Time to upgrade? To what?

    It would probably pay to leverage your access/vb knowledge by upgrading to sql server. Like the post above points out you're going to run out of room in a couple years unless theres a possibility of purging old records to trim it down. You can build your front end in visual basic for an...
  12. bookor

    query that selects only the most recent record

    I have a persons table with a personid. As the individuals addresses, phone numbers etc. change new records are added to the address, phone number tables etc, linked by personid. The addresses, phones tables have sequence numbers to indicate the most recent entry. There must be a simple sql...
  13. bookor

    Large Databases

    Ill wade through that and give it a shot. Is Visual Interdev worth the investment? Seems like Ive read some uncomplementary reviews?<br> <br> thanks for the reply<br> <br>
  14. bookor

    text file extract on timer

    Unfortunately we are running on NT which doesnt have cron. <br> <br> How do you spool your text to file? Text_io, set spool on, or some other method?<br> <br> thanks for the reply<br>
  15. bookor

    Linking to Oracle tables

    What ODBC driver are you using? I use the standard MS Oracle ODBC driver to link Oracle8 tables in Access97 and have never had any problem. I havnt tried any of the new OleDB drivers or other methods of linking, but they might also be an option if you dl the MS MDAC components.<br> <br>
See more

Part and Inventory Search

Back
Top