General Forum

Ok, I have having a problem joing these two queries. Can anyone please help me out here. These are the results of my two queries: These are the values in the A1 field of QueryA COCKBURN 2 GT KW 1 GTN 1 IPP GT1 IPP GT2 KALG F5

Hii Dudes, Iam Hariprakash. Today I was searching for DB2 DBA in google for exam 701. I got this link. This is very interesting and just now I joined this group. I took the exam 701 last tuesday and got only 59% 42 out of 70 and 43 is pass. I prepared with roger sanders book for 701. please advise me on how to prepare for this exam. i am not...

Although the jpeg from which the OLE value is taken are few hundred kb they increase the dbase size for 5-6 mb. With 20 records the size of the file is 300MB?! What am i doing wrong?

I have to do data dumps from our Unix server (I can't connect directly to the tables) to populate data in an Access db. The current code I use to ftp these files is pretty cumbersome - does anyone know of anything more up to date I could try?

I need the script Ischoolad. The website where it orignated is no more. If anyone has a copy of it. Please let me know. Thanks.

Hi people, I have a function which will receive 2 parameters:the date field in GMT time and the user's time zone. I have to return a datetime field in the user's time. the thing is the server records the GMT time and that is put into the database. but when reports are to be generated for a user who doesn't belong to the GMT time zone, for...

Hello everyone,,, Here is my problem, I'm using MS Access, I'm building a mobile inventory system.I have a table (Products) and I want to update the Quantity of mobiles each time I perform a sale operation. Sales operations are performed through a Form(Invoice) and in that form I built a subform-that was built using a query- where most of...

I have a form with two subforms. The main form holds the Order Number and basic information. The 1st subform holds an abbreviated list of products in the order and the data source is a table that uses master and child fields to populate. The 2nd subform holds product details and I am attempting to use a query with one parameter to...

How Can I copy cloumn "Sql server" to an array in VB.net? thanks

Hello every one, I asked a question earlier and now I'm refining it to make it clearer (Because I'm now getting to understand my problem). I have a table "Products" and an attribute "Quantity". I also have a subform in the Invoice from and the subform is created using a query "Invoice_line_quiry". There is in this query "Invoice_line_quiry"...

Really, all I've ever done is a little html, but since FrontPage, hardly any. Now I am ready to sell my products after being online for a decade. I am newly signed up with Link Partners, and I get an automated email from a site that wants to exchange links. First I look at their site. Then I realize they are a zillion miles ahead of me in the...

Hi, This is srinivas,i need an info regarding customizing query irrespective of any database i.e the backend may be anything like MYSQL,SQLServer,Oracle ,MS Access etc there should be one common query for all these databases to retrieve and insert the values. I hope my Question is clear.Once Again we don't know which...

Hello............. can I copy data set to arrays ? can I enquires from data set like this select ds.tables(0).columns(0) ......................? thanks

Please can any one help me on sending messages on C# language thanks in advance

Hello everyone, Please help me revise this query to make it work. I don't know much about update query so I will need some help with it. Thanks, update encounter set mergedpayment = totalactualcashpayments from encounter E, paymentITEM P, encounterfinancialrecord F where (E.encounterid = P.FINANCIALRECNUM) AND...

Hi All, Recently encountered problems with "Error 3052 File sharing lock exceeded". I have done some research and found the aswer here on the forum. However, I have the following questions: - The number of records in my file (text file) are only small - 3500 and this error is happening. Thought it was suppose to occur only in big files? -...

anyone who can write some scripts for me for this online game would be an lifesaver pm me!

For a period of 24 hours from May 8th to 9th, thescripts.com was down because we made a change in the hardware setup that runs the site. Please let us know if you run into any issues or problems with the site, so that we can address them as fast as possible. More changes are to come. Thanks, KUB

I have the following query : DECLARE tmp INTEGER; BEGIN tmp := 1; DBMS_OUTPUT.PUT_LINE(tmp); INSERT INTO WT_PTFMGT (SESSION_ID,TYPE,L, R, C,GBL_INSTRUMENT_ID,COM,L_HOLDING, R_HOLDING, C_HOLDING)

Hi Is it possible to set up a cascading parameter in visio.net2003 which use different tables? In all examples I can find the data sets for cascading need to use the same table. I will need to draw the data from 2 different tables. Can anyone suggest how to do this? :confused:

Dim strSQL as String strSQL = "SELECT items.itemid, items.itemname, items.itemsupplierid, items.itemdescription " & _ "FROM items " & _ "WHERE " & Me.cmbSearchField Like Me.txtSearchCriteria & "*" & _ "ORDER BY " & Me.cmbSearchField & ";" Me.lstSearchResults.RowSource = strSQL I dont understand, it keeps assigning a value of false...

Hi, I want to know how to write scripts for schema changes from testing server to production server.Please give an answer asap. Thanks

I'm having trouble creating a query using an msaccess adp with an sql backend. I have a form with a subform, within the subform I have a button which runs a query, the query then should get the ID value from the sub form, I have tried everything, the closest I could come is: SELECT ID, Name, IPAddress, Manufacturer, AssetTag, Type,...

Hi I am trying to create a report in which a user will just select their own club from a drop down list, once club is selected, i want all courses scheduled for that day to print - without the user selecting a date (i want today's date to be selected automatically). is GETDATE the right command for this? Thanks.

Im trying to create a report for a purchase order very similar to the Northwind invoice report. I have everything figured out except how to repeat the entries in the detail section of the report. I have all the order information except all of the items. It will only list one of the items in the detail section, where in the Northwind report it...