two dimentional output
If you are on SQL SERVER 2005 or above, you could use a query like this: <pre> SELECT * FROM (SELECT id,year,col1,col2,ddate, ROW_NUMBER() OVER (partition by year ORDER BY ddate DESC) rowNumber FROM yourTable) ordered_temp WHERE rowNumber = 1;</pre> If you are not using SQL SERVER, or you are using an older version, please provide [...]
View Answer
| February 3, 2010 3:47 PM
SQL Query, SQL tables, Two-dimensional Output
If you are on SQL SERVER 2005 or above, you could use a query like this: <pre> SELECT * FROM (SELECT id,year,col1,col2,ddate, ROW_NUMBER() OVER (partition by year ORDER BY ddate DESC) rowNumber FROM yourTable) ordered_temp WHERE rowNumber = 1;</pre> If you are not using SQL SERVER, or you are using an older version, please provide [...]
View Answer
| February 3, 2010 3:47 PM
SQL Query, SQL tables, Two-dimensional Output
Difficult Select Statement in SQL
It sounds like you want all of the duplicates in A regardless of the duplicates in B <pre> select * from table1 where flda in( select flda from table1 group by flda having count(*) > 1) </pre> ————- If I understand correctly, I think you would have to add an additional condition to the query [...]
View Answer
| February 3, 2010 3:36 PM
SQL, SQL Select, SQL Select statement problem
It sounds like you want all of the duplicates in A regardless of the duplicates in B <pre> select * from table1 where flda in( select flda from table1 group by flda having count(*) > 1) </pre> ————- If I understand correctly, I think you would have to add an additional condition to the query [...]
View Answer
| February 3, 2010 3:36 PM
SQL, SQL Select, SQL Select statement problem
SQL for MS Access Syntex issue
I don’t know much about MS Access, but I think some statements can only be executed through ADO, and will throw errors when trying to execute them from the SQL View user interface. So, I would try creating a module, with some code like this: <pre>Sub CreateTable() CurrentProject.Connection.Execute _ “CREATE TABLE Manufacturers” _ & “( [...]
View Answer
| February 2, 2010 3:26 PM
Microsoft Access, SQL
I don’t know much about MS Access, but I think some statements can only be executed through ADO, and will throw errors when trying to execute them from the SQL View user interface. So, I would try creating a module, with some code like this: <pre>Sub CreateTable() CurrentProject.Connection.Execute _ “CREATE TABLE Manufacturers” _ & “( [...]
View Answer
| February 2, 2010 3:26 PM
Microsoft Access, SQL
REXX tool to change a particular word in more than 50 PS at a time- PLS help
Sure. This can be done. REXX (or a CLIST) can do this with the old TSO editor, or REXX (maybe with an EDTMACRO) can do it within ISPF. So that is your first decision. In either approach, you will have to get the dataset names passed to the routine. One way would be to list [...]
View Answer
| February 2, 2010 6:41 AM
REXX, REXX Mainframe, REXX Procedure
Sure. This can be done. REXX (or a CLIST) can do this with the old TSO editor, or REXX (maybe with an EDTMACRO) can do it within ISPF. So that is your first decision. In either approach, you will have to get the dataset names passed to the routine. One way would be to list [...]
View Answer
| February 2, 2010 6:41 AM
REXX, REXX Mainframe, REXX Procedure
VB .NET Tabs and Forms
Something like this ? <pre> Private Sub TabControl1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TabControl1.SelectedIndexChanged If TabControl1.SelectedIndex = 1 Then Dim myForm As New Form2 myForm.Show() End If End Sub</pre> ————
View Answer
| February 2, 2010 1:55 AM
forms, TabControl, VB .NET
Something like this ? <pre> Private Sub TabControl1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TabControl1.SelectedIndexChanged If TabControl1.SelectedIndex = 1 Then Dim myForm As New Form2 myForm.Show() End If End Sub</pre> ————
View Answer
| February 2, 2010 1:55 AM
forms, TabControl, VB .NET
Coding career question
The best way to get better at something, including writing code, is to practice by doing, then have someone review your work and show you where you used the correct techniques and where you used the incorrect techniques.
View Answer
| February 1, 2010 7:08 PM
Careers, Coding, IT careers, Programming, Programming Careers
The best way to get better at something, including writing code, is to practice by doing, then have someone review your work and show you where you used the correct techniques and where you used the incorrect techniques.
View Answer
| February 1, 2010 7:08 PM
Careers, Coding, IT careers, Programming, Programming Careers
Run time error
Most likely you are assigning a value outside the valid range (0 – 100) to the ‘value’ property.
View Answer
| February 1, 2010 2:51 PM
VB6
Most likely you are assigning a value outside the valid range (0 – 100) to the ‘value’ property.
View Answer
| February 1, 2010 2:51 PM
VB6
problem in my pb11 application and sql2008
Are you trying to use ADO.NET to connect from PowerBuilder to SQL Server 2008? What’s the connection string that you are using?
View Answer
| February 1, 2010 5:23 AM
ADO.NET, PowerBuilder, PowerBuilder 11, SQL 2008
Are you trying to use ADO.NET to connect from PowerBuilder to SQL Server 2008? What’s the connection string that you are using?
View Answer
| February 1, 2010 5:23 AM
ADO.NET, PowerBuilder, PowerBuilder 11, SQL 2008
C++ malloc typedef struct which is in a typedef struct already
Hi Mr.JammerLT, From the code snippet I could see that the Object variable (member of the Frame Structure) is allocated with size as ObjectCount each having the size of object. So when accessing the member of Object structure either you have to use statements as below: Frame[t].Object[i].objectTransformX=0; since it is a pointer it should use [...]
View Answer
| January 30, 2010 6:26 AM
C, C++, Microsoft Visual Studio, Programming, Visual Studio
Hi Mr.JammerLT, From the code snippet I could see that the Object variable (member of the Frame Structure) is allocated with size as ObjectCount each having the size of object. So when accessing the member of Object structure either you have to use statements as below: Frame[t].Object[i].objectTransformX=0; since it is a pointer it should use [...]
View Answer
| January 30, 2010 6:26 AM
C, C++, Microsoft Visual Studio, Programming, Visual Studio
where we have to use Pointer
A pointer is a memory variable that contains the address of another memory variable. They were widely used in older, procedural programming languages like C. Using pointers allowed programmers to write very fast, low-level code. But pointers also exposed some security risks that were difficult to identify when the programs were being written. Pointer use [...]
View Answer
| January 30, 2010 6:12 AM
C++, C++ Pointer
A pointer is a memory variable that contains the address of another memory variable. They were widely used in older, procedural programming languages like C. Using pointers allowed programmers to write very fast, low-level code. But pointers also exposed some security risks that were difficult to identify when the programs were being written. Pointer use [...]
View Answer
| January 30, 2010 6:12 AM
C++, C++ Pointer
Different results for embedded SQL
I doubt that’s happening..please show us both commands and the values ..it’s likely a difference in library list or a value in the where clause. Phil
View Answer
| January 30, 2010 3:26 AM
Embedded SQL, RPG, SQL, STRSQL
I doubt that’s happening..please show us both commands and the values ..it’s likely a difference in library list or a value in the where clause. Phil
View Answer
| January 30, 2010 3:26 AM
Embedded SQL, RPG, SQL, STRSQL
Access the API using AS400
What you ar asking for is basically a ‘webservice’, since you do not need the data to be presented in any way in a browser. You will need to ask the supplier if their solution has a webservice which returns tha data that you need; – if not, it cannot be done (according to my [...]
View Answer
| January 29, 2010 10:46 PM
API, AS/400, AS/400 API, AS/400 programming, CLP, RPG, URL
What you ar asking for is basically a ‘webservice’, since you do not need the data to be presented in any way in a browser. You will need to ask the supplier if their solution has a webservice which returns tha data that you need; – if not, it cannot be done (according to my [...]
View Answer
| January 29, 2010 10:46 PM
API, AS/400, AS/400 API, AS/400 programming, CLP, RPG, URL
Require the method and steps to decrease ASP and DASD utilization.
You must have free space equal to the space your of any file you are going to rgzpfm because it makes a copy. I woud go for the low hanging fruit like GO CLEANUP and make sure your options look something like this: Change Cleanup Options CSYS 01/29/10 14:36:11 Type choices below, then press Enter. [...]
View Answer
| January 29, 2010 7:42 PM
AS/400 performance, ASP, ASP Utilization, DASD, V5R4M0
You must have free space equal to the space your of any file you are going to rgzpfm because it makes a copy. I woud go for the low hanging fruit like GO CLEANUP and make sure your options look something like this: Change Cleanup Options CSYS 01/29/10 14:36:11 Type choices below, then press Enter. [...]
View Answer
| January 29, 2010 7:42 PM
AS/400 performance, ASP, ASP Utilization, DASD, V5R4M0
SQLCOD = -7008 when doing an insert into file using SQLRPGLE
Hi I did not see the exact code in question but do you have a pgm described varaible as the “Library name”? <i>That is not allowed when SQL is embedded in RPGLE.</i> Jim …….. Yes, it is allowed. You just have to code it properly. — Tom Is commitment control on? If not, are you [...]
View Answer
| January 29, 2010 2:40 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Hi I did not see the exact code in question but do you have a pgm described varaible as the “Library name”? <i>That is not allowed when SQL is embedded in RPGLE.</i> Jim …….. Yes, it is allowed. You just have to code it properly. — Tom Is commitment control on? If not, are you [...]
View Answer
| January 29, 2010 2:40 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Convert/Migrate Lotus Notes Client Applications to Web
(I deleted my previous answer, as I misread the question). I don’t know that there is a tool specifically designed for this. However, if you had TeamStudio tools, such as Analyzer and/or Configurator, you could design filters to use in analysis that would find and report code that would not work in a Domino application. [...]
View Answer
| January 29, 2010 2:30 PM
Development tools, Lotus Domino, Lotus Notes
(I deleted my previous answer, as I misread the question). I don’t know that there is a tool specifically designed for this. However, if you had TeamStudio tools, such as Analyzer and/or Configurator, you could design filters to use in analysis that would find and report code that would not work in a Domino application. [...]
View Answer
| January 29, 2010 2:30 PM
Development tools, Lotus Domino, Lotus Notes
In-built functions in C
Built-in functions are similar to operation codes in that they perform operations on data you specify. Built-in functions can be used in expressions. All built-in functions have the percent symbol (%) as their first character. The syntax of built-in functions is: function-name{(argument{:argument…})} the other there are the library files getch,,putch
View Answer
| January 29, 2010 6:01 AM
C, C programming, Vista
Built-in functions are similar to operation codes in that they perform operations on data you specify. Built-in functions can be used in expressions. All built-in functions have the percent symbol (%) as their first character. The syntax of built-in functions is: function-name{(argument{:argument…})} the other there are the library files getch,,putch
View Answer
| January 29, 2010 6:01 AM
C, C programming, Vista
vbscript date format
You could use the <a href=”http://msdn.microsoft.com/en-us/library/eh8fefz1(VS.85).aspx”>Right Function</a>. Something like this: <pre>sYesterday = Day(dYesterday) & Month(dYesterday) & <b>right(</b>Year(dYesterday)<b>,2)</b></pre> -CarlosDL ——————————— kccrosser: There is a FormatDateTime function in VBScript that gives the date/time back in a variety of formats. If you use the “short date” format, it returns “mm/dd/yy”. sYesterday = FormatDateTime(dYesterday, 2) This will result in [...]
View Answer
| January 28, 2010 4:43 PM
VBScript, VBScript Date Format
You could use the <a href=”http://msdn.microsoft.com/en-us/library/eh8fefz1(VS.85).aspx”>Right Function</a>. Something like this: <pre>sYesterday = Day(dYesterday) & Month(dYesterday) & <b>right(</b>Year(dYesterday)<b>,2)</b></pre> -CarlosDL ——————————— kccrosser: There is a FormatDateTime function in VBScript that gives the date/time back in a variety of formats. If you use the “short date” format, it returns “mm/dd/yy”. sYesterday = FormatDateTime(dYesterday, 2) This will result in [...]
View Answer
| January 28, 2010 4:43 PM
VBScript, VBScript Date Format
Query Calculation Part of Select Criteria
Try something like this: <pre>SELECT “T16.CPRP”.CP_DISTRICT_CODE, CASE “T16.CPRP”.CP_DISTRICT_CODE WHEN ‘xx’ THEN SUM(“T16.CMCL”.MC_TAX_AMOUNT) AS TOWN WHEN ‘yy’ THEN SUM(“T16.CMCL”.MC_TAX_AMOUNT) AS TOWN ELSE SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS TOWN END, SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS COUNTY</pre> (Replace ‘xx’ and ‘yy’ with the special district-codes which shall not be divided. And let the rest of your code remain. Happy coding ————————————— It could be [...]
View Answer
| January 28, 2010 3:56 PM
iSeries Navigator, Query Calculation, SQL, Sql Script
Try something like this: <pre>SELECT “T16.CPRP”.CP_DISTRICT_CODE, CASE “T16.CPRP”.CP_DISTRICT_CODE WHEN ‘xx’ THEN SUM(“T16.CMCL”.MC_TAX_AMOUNT) AS TOWN WHEN ‘yy’ THEN SUM(“T16.CMCL”.MC_TAX_AMOUNT) AS TOWN ELSE SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS TOWN END, SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS COUNTY</pre> (Replace ‘xx’ and ‘yy’ with the special district-codes which shall not be divided. And let the rest of your code remain. Happy coding ————————————— It could be [...]
View Answer
| January 28, 2010 3:56 PM
iSeries Navigator, Query Calculation, SQL, Sql Script
Edit a text file with VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
Can’t see overlay screen in debug
I’m using RPGLE and I using STRDBG to debug the pgm. I set the OVERLAY using SDA. I’m using client access. During debugging the pgm, first time go into the loop is OK, which means all the screen can display, but not the 2nd time in the loop, bcoz only have EXFMT DETAILS but not [...]
View Answer
| January 28, 2010 2:07 AM
Debugging, Program Debugging
I’m using RPGLE and I using STRDBG to debug the pgm. I set the OVERLAY using SDA. I’m using client access. During debugging the pgm, first time go into the loop is OK, which means all the screen can display, but not the 2nd time in the loop, bcoz only have EXFMT DETAILS but not [...]
View Answer
| January 28, 2010 2:07 AM
Debugging, Program Debugging
