Search results for query: *

Hi, I'm trying to echo an Image (jpg) type - Longblob from a table and it outputs all funny characters. Example : {sí]  (¢€úÑÒ–Š(¢ŠJ(¢€ (¢€ (¢€ (¢€ (¢€“½:›Ži0ºtϵ?)M7·4€q¨ØæžsMn”
JþšÝ÷vÍy¦¡µn$MzuóbÒBx⼺ôæy äÓBe95Î1ŸÆ¤n¦£4ÄzÏü#š'ý
ôÿüOð¤o and this is only a small section ! I...

Select CUR_TRN_DT, sum(F_LT_AMOUNT), sum(F_LT_AMOUNT) over (order by CUR_TRN_DT) FROM FAT_BSE_LEDGER_TRANS where LT_LEDGER_TYPE_ID='AA' and CUR_TRN_DT>= '01/01/2007' and GL_OBJ_ACCOUNT_DESC='22895' group by CUR_TRN_DT I'm trying to do a runningsum but when I run the code it's failing with...

Hi, Does anyone know how to include column names when exporting to a file ..... EG EXPORT TO "C:\NOW.XLS" OF WSF MODIFIED BY 1 METHOD N (WO_DOCUMENT_NUMBER_ID) MESSAGES "X" SELECT WO_DOCUMENT_NUMBER_ID FROM E6DW_DATA.PBVIEWS_SNAP_WORK_ORDERS ; or EXPORT TO "c:\now.csv" of del MESSAGES "X"...

Sorry, If this question is ridiously easy ... ' If I click on a button (event) then I can change my textbox value Private Sub btnClosePort_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClosePort.Click txtSend.Text = "Text value Changed" End Sub 'But how...

Hi, I can read my COMport but I can't seem to display the data in a text box in my WebForm. 'DECLARING Imports MSCommLib " " " " Protected WithEvents mscomm As New MSCommClass() 'OPEN PORT - WORKS Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Hello, I have a table (TblA) with 30m records. I want to do an Insert into (TblB) that will commit every 100k records at a time....is this possible? Thanks

Hello, I trying to join 2 tables, I know in some programs SQL the Transform/Pivot works but I'm no too sure how to do it in DB2, any help is appreciated. Table1 LID Lot Date 1 100 01012004 Table2 PID LID Job Value 1 1 JobA 1.5 2 1 JobB 3.5 3 1...

Hi, I have a button on form1 that when you click it it opens form2. Because there are so many controls on there it takes a while to open. Hence I want to have a progress bar on form1 or either on form2. Is it possible to have a progress bar on form1 so when it hits the max.value it opens...

Hi, I have some code, Sub Dim Parentform as Form, Childform as Form Set Parentform = Me.Parent Set Childform = Forms!sfrmChild If Parentform = Childform .. .. EndSub Getting error stating that Forms!sfrmChild is not found and Parentform = Childform (type mismatch). is there something...

Hi, I have some code, Sub Dim Parentform as Form, Childform as Form Set Parentform = Me.Parent Set Childform = Forms!sfrmChild If Parentform = Childform .. .. EndSub Getting error stating that Forms!sfrmChild is not found and Parentform = Childform (type mismatch). is there something...

I have the following code ... SUB DETAIL_FORMAT if isnull(me![txtImagePath]) then me![iImage].picture = "" else me![iImage].picture = me![txtImagePath] END SUB this works fine (image is displayed) where the fieldname iImage has a path pointing to an image but when the field is...

Hi, I have a listbox(multiselect) on a form with a valuelist of 4 items (SRep1, SRep2, SRep3, SRep4) each one repersents a subreport. Depending on what items you select I want to show only thoes subreports on the main report. Also, there is a pagebreak between each subreport. (Is it posibble...

Hi, I have a listbox(multiselect) on a form with a valuelist of 4 items (SRep1, SRep2, SRep3, SRep4) each one repersents a subreport. Depending on what items you select I want to show only thoes subreports on the main report. Also, there is a pagebreak between each subreport. (Is it posibble...

Hi, I have a table called ´tblTest´ with 3 fields, TestID, TestName, TestValue. The problem is with the field ´TestValue´, I want the type to be able to change for each new record Example... TestID TestName TestValue ------- -------- ---------- 1 TestA 3.14(single) 2 TestB...

Hi, I have a table called ´tblTest´ with 3 fields, TestID, TestName, TestValue. The problem is with the field ´TestValue´, I want the type to be able to change for each new record Example... TestID TestName TestValue ------- -------- ---------- 1 TestA 3.14(single) 2 TestB valueB(value...