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!

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

Search results for query: *

  1. Gita21

    Get Stock On Hand

    I found a simpliar query that works for me. But it uses 3 queries. I was wondering if there was a way to just use one. qrySumBought:- SELECT [BookID], [BookType], Sum([QtyBought]) AS SumOfQtyBought FROM BookBought GROUP BY [BookID], [BookType]; qrySumSold:- SELECT [BookID], [BookType]...
  2. Gita21

    jar

    Yes the xml files are in the same directory as the class files
  3. Gita21

    jar

    sorry, I dont understand what you mean by user.home XML Files and images are stored with the classes
  4. Gita21

    jar

    I'm trying to run my jar C:\jbuilder5\jdk1.3\bin\javaw -jar application.jar The program runs but I cannot see any images and it also doesnot read xml files. I'm using xml to produce my reports. The classes, xml and my images are in the same folder. Help please.
  5. Gita21

    how to develop a queryDataSet which

    how to develop a queryDataSet which shows all the events that will occur with the criteria that the event date should be greater then today's date select [field list here] from [tablenamehere] where EVENTDATE > :TODAYDATE How to get TODAYDATE
  6. Gita21

    How to overwrite these database exception errors?

    JBuilder produces exception errors automatically For example, when Primary Key Field empty Or when the PK already exists Or when Delete is not allowed when related records exist and delete cascade is not allowed. How to overwrite these database exception errors?
  7. Gita21

    Hi I am using DBswing components

    Hi I am using DBswing components. >> Course >> ------ >> CourseID(PK) >> CourseStartDate(PK) >> >> Registration >> ---------- >> customerID (PK) >> courseID(PK) >> courseStartDate(PK) >> A person cannot register for a course where the courseStartDate is same as the courseStartDate for a course...
  8. Gita21

    How to save to multiple tables with master detail link.

    How to save to multiple tables with master detail link. That is, how to save the master table first then the detail tabes. For example, there is a order table and a orderItem table. When save button is clicked. It must save to Order table first then to orderItem table...
  9. Gita21

    Date Field

    The short date format display date like this 2/10/2002 I want a zero before the 2. That is, 02/10/2002. Any ideas how to do this....
  10. Gita21

    Get Stock On Hand

    How to find Stock on hand for each product. Product ------ ProductID(PK) ProductSold --------- ProductID (PK) date(PK) QtySold ProductBought ----------- ProductID(pk) date(PK) QtyBought
  11. Gita21

    Query

    Course ------ CourseID(PK) CourseStartDate(PK) Registration ---------- customerID (PK) courseID(PK) courseStartDate(PK) Relationship Course 1--* Registration *--1 Customer A person cannot register for a course where the courseStartDate is same as the courseStartDate for a course already...

Part and Inventory Search

Back
Top