Search results for query: *

Hi Friends I am trying to achieve a very common business rule, i.e.: I have following tables: 1) PO_HDR - PO_ID PK 2) PO_DTL - PO_ID FK 3) GRN_HDR - PO_ID FK FROM PO_HDR 4) GRN_DTL - GRN_ID FK My requirement is to list only those PO's where the po_dtl qty is less than the grn_dtl qty. Means...

Hi Friends This might not be the appropriate forum to post this question but still as its related to oracle 10g database i m posting it here. I have installed Oracle's free 10g Express edition database on a Machine with Windows XP professional loaded. The database and the related application...

Hello friends, I need to write a query to compare the quotations recived from various vendors item wise. Which means that different vendors may give different prices for the same item... i want to find out the least price for each item and assign a rank to it.... I have gone through oracle's...

Hello Friends, I have a very common requirement but a very difficult problem (at least for me)... In my application i have a form for generating Requests for Quotations (RFQ's). In the detail part the user will select the Items. I want to filter ONLY THOSE VENDORS who are supplying ALL THE...

i am trying to create a report which gives the number of complaints recieved lastmonth, thismonth, thisyear, till today per category. the query is: select distinct category, decode(reg_date,SUBSTR(ADD_MONTHS(sysdate,-1),4,6),cnt,0) LastMonth, decode(reg_date,SUBSTR(sysdate,4,6),cnt,0)...

Hi Guys, I am using Oracle 8i on Windows 2000 server, i have a table which contains a column called Ingredient_Code, its a detail table and has multiple rows, and i want to show them as three different columns for example: Ingredient_Code =============== 971 956 900 Should be shown as...

Hi Friends I am using ORacle 8i, Forms 6i to develop an application in which i have to store the following data, for which i have created a table but i think i m doing lot of data duplication so how to store it more efficiently The data is in the following manner...

Hi Guys I guess a really unique question may be... Ok here is what i want to achieve In my application, there is a login form, in which users (the number of users are unlimited and most of them are visitors), have to enter their names and start using the application, Ok many buggers, instead...

Hi Friends I am using VB 6.0 SP6, MSDE 2000, I have a table to store subscriber's details, right now the table has only 10,000 records and the application is running very slow while fetching, saving and unloading the records. So i created a unique Index, which upto certain extend improved the...

Hi Friends I am facing problems in dispalying datareport, I have created a datareport with all the labels on it and from my form i am simply calling the report by Datareport1.show It gives me error: Invalid Data Source. I searched microsoft for this error but as usual no help. And even...

hi i m stuck with a very typical problem, i am using a class (which i downloaded from psc) for printing labels. One page contains 12 labels (6 on right 6 on left). The class has got parameters for Row and Column, which makes the class understand where exactly it has to print... but now my...

hi guys last night when i was working all of a sudden my comp went off... and the form on which i was working got crashed. now when i am trying to add that specific form to my project it gives me the following error: Path / File access error "C:\Spenta\frmCirculation.frm" How do i get back my...

hi guys i am writing the following statement to insert records from one table to another Insert into SubscriberMaster (SubCode, SubName, SubAdd1) Select OldSubsCode, OldSubsName, OldSubsAddress from OldSubscriberMaster I am not able to execute this statment becuase my SubscriberMaster Table...

Hi Friends I have assigned short cut keys to my toolbar buttons, using the & just before the Access Key, but its not Activating the click event even if i use it with Ctrl or Alt... Please help.... I searched this forum and found only one relevant thread thread222-265762, in which CCLINT (one...

hi friends I have installed MSDE 2000 on WIN 98SE machine, The Service manager runs properly and connects as well but when i try to connect from VB6, it gives me error saying Invalid User Name / Password. While installing i have given following command line parameter setup...

Hi Friends, I am planning to deploy a standalone Access / VB application to a network and multiuser application. In which my Access database will reside on server and my VB client will communicate with the access database. Now i want to know how do i handle the following possibilities: 1)...

Hi friends today afternoon when i was coding, all of sudden when i ran my VB APP on which i am working from pas three months and using the same connection stopped connecting to SQL Server, where as i can connect through an OLE DB Connection string (Which is created by ADODC data control)...

Hi Friends I want to know, is it possible to prepare a Recordset from the information displayed in a FlexGrid. Yeah i mean to say that Lets say my FlexGrid is Displaying 10 Rows and 2 Columns, So i want to prepare a Recordset which should contain 2 Fields and 10 Records, I know i can loop...

Hi Friends I am developing a small application which will upload data from excel files to SQL Server using VB 6. The Work Books may have many sheets in it. So before upload i want to show the user all the sheet names in the selected work book. so then user can choose from which sheet he wants...

Hi Friends Does anyone knows how can store multiple images in one single file, that single file can be a PDF or an Image file itself. Please its bit urgent.... Regards Gazal