Search results for query: *

I have problem like this: there are two fields in the table, type, duedate and postdate. If type (field) is X then query should looklike this: Select * from Table where duedate < 'DATE' else query should looklike this: Select * from Table where postdate < 'DATE' Can I do it in one query...

Hi all, I'm writing a little bit long select query; SELECT I.ACCOUNT, C.NAME1 AS STEXT,C.COUNTRY, (CASE WHEN EXTPAYDOCNUM IS NOT NULL AND PAYMDOCKEY = '3' THEN NVL((SELECT SUM(HPOSTAMNT * (POSTWAY * 2 - 1)) AS OPENAMNT1 FROM IASFINITEM WHERE (CLIENT = '00') AND (COMPANY =...

Hi All, I have table called Eventsl with four fields; DTime: 01.07.2005 18:36:00 Name: Name Surname: Surname CardNo: 1234324 and I need to get all the records between 18:00:00 and 19:00:00 between the given date parameters. Below is my query that does not work :( SELECT DISTINCT...

Hi all, I can not run this Query :( SELECT SUM(I.QUANTITY), (SELECT DISTINCT COUNT(COLOR) FROM COLORTABLE WHERE I.MATERIAL = MATERIAL GROUP BY MATERIAL, REVISION) as COL FROM SOLDITEMS I, COLOR C WHERE I.QUNIT = 'KG' AND I.CREATEDAT > '01.06.2005' AND I.CREATEDAT < '30.06.2005' GROUP BY COL...

Hi, I got Listboxs like this: First Second 1 3 1 4 1 3 2 5 3 4 3 2 4 1 5 7 5 5 What I need is to remove the duplicate items from the first one and sum all the corresponding values in the second one, so the example become: 1 10 2 5 3 6 4 1 5...

Can not we use parameters (as fieldnames) in Reporting services? I'm putting a combobox and field names in it and let the user select the order type of the report for example: Select * from X order by @param where param is a field name. BTW I'm connecting to an Oracle DB so the format must...

I must send a dataset to a function and I can not do it in one Query.. the basic logic: SUM(("SELECT IBI.ComponentID, IBI.QUANTITY FROM BOMITEM IBI WHERE IBI.MATERIAL = '" & MatNum & "' " / "SELECT IBH.BASEQUAN FROM BOMHEAD IBH WHERE IBH.MATERIAL = '" & MatNum & "' " * MatQuan) *...

I'm trying to run a select query on 5 tables but it seems my code is not efficient enough :( please help... BTW it gives me a timeout error. I don't know but maybe the problem is that there are 2500 records on my card table... SELECT CARD.LNAME, CARD.MNAME, CARD.CNUM, CARD.CNAME, (CASE...

Hi, I'm creating a number of radiobuttonlists at runtime and assign them different IDs but when I try to access them using FindControl, it can not find them: This is what I'm trying to do Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

I'm creating a button at runtime and It will insert the radiobuttons (from dynamic radiogroups) values to table: But I can not implement the click event, here is my code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim...

I wrote a simple query (not a storedproc) with an order by but it does not work :( SELECT * FROM EventsL WHERE (Door = 'yemekhane') AND (Site LIKE @Site) AND (CONVERT(CHAR(10), DTime, 110) = @Tar) ORDER BY @Ord I tried things like SELECT * FROM EventsL WHERE...

I'm using a matrix; Row=Name,Surname Cols=Site Data=DateTime The problem is when two or more names match it only shows 1 name and hide the others like this -------------------- Name Surname -------------------- Surname -------------------- I want to make the other lines (Names)...

I don't know if this belongs here but it is vb .net related. If not please move my post to the correct forum. I have 25 Dbase III tables and I created ODBC connections using MS FoxPro VFP Driver, MS Dbase VFP Driver and these 2 connections, can only see 6 tables out of my 25 tables. The second...

void __fastcall TForm1::DBGrid1DrawDataCell(TObject *Sender, const TRect &Rect, TField *Field, TGridDrawState State) { Query1->Prior(); double temp = Query1value2->Value; Query1->Next(); DBGrid1->Fields[3]->Value = Query1value1->Value + temp; } This is something similar to what I am...

procedure TForm1.Edit1KeyPress(Sender: TObject; var Key: Char); const ValidInput = [ '0'..'9', #8]; begin if not ( key in ValidInput ) then begin key := #0; Beep; end; end;" How can I change this code so that it will work with C++ Builder? I want this; Users can not enter...

I have an old delphi component and I changed the source (dsgnintf -> designmenus,designintf ) and now it works but when I uncheck project options->packages->build with runtime packages still the proxies.obj file I searched them and I only found proxies.hpp and proxies.dcu can I build the obj...

I have 13 edits in my form if 5 is entered in the first edit , first 5 of the 12 remaining edits will be enabled, if 10 is entered in the first edit 10 edits will be enabled and 2 will be disabled... Thanx (names are edit1,edit2....,edit13) I think it should look something like this: for...