VB.NET code to search if a record already exists or not
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
SQL select for month date range
Carlosdl 29360 pts. | Nov 9 2009 11:08PM GMT I’m wondering how is that running without errors. AFAIK, the DATEPART function retunrs an integer, so, here: <pre>[service date 1] between [new patient date] and datepart(m,[new patient date])+1</pre> You are mixing two different data types. I think you should try something like this: <pre>[service date 1] [...]
View Answer
| November 10, 2009 12:24 AM
SQL, SQL Server
Carlosdl 29360 pts. | Nov 9 2009 11:08PM GMT I’m wondering how is that running without errors. AFAIK, the DATEPART function retunrs an integer, so, here: <pre>[service date 1] between [new patient date] and datepart(m,[new patient date])+1</pre> You are mixing two different data types. I think you should try something like this: <pre>[service date 1] [...]
View Answer
| November 10, 2009 12:24 AM
SQL, SQL Server
Data selection criteria to pull last months information
If you are using AS400 query, you can define a result field to use for you selection. You can retrieve todays date using using teh keyword CURRENT. Then you can create other result fields using that and values to determine the begining of the previous month. I have done this in the past but cannot [...]
View Answer
| November 9, 2009 1:27 PM
AS/400 date format, Date Picker
If you are using AS400 query, you can define a result field to use for you selection. You can retrieve todays date using using teh keyword CURRENT. Then you can create other result fields using that and values to determine the begining of the previous month. I have done this in the past but cannot [...]
View Answer
| November 9, 2009 1:27 PM
AS/400 date format, Date Picker
Acrobat fail to connect to a dde server error?
It <b>could be</b> being caused by an antivirus/antispyware or a firewall that is preventing Acrobat from connecting to some other process it needs to connect to. Check your antivirus configuration to see if there is something you can modify to let Acrobat run and establish DDE sessions without problems. ——————-
View Answer
| November 6, 2009 7:42 PM
Acrobat Error Messages, Adobe Acrobat
It <b>could be</b> being caused by an antivirus/antispyware or a firewall that is preventing Acrobat from connecting to some other process it needs to connect to. Check your antivirus configuration to see if there is something you can modify to let Acrobat run and establish DDE sessions without problems. ——————-
View Answer
| November 6, 2009 7:42 PM
Acrobat Error Messages, Adobe Acrobat
How to write a program to download a website from a given URL
I’m not sure if this is what you are looking for. The programs on this page are all offline viewers. They grab a page, or an entire site and save them on you local HD where they can be veiwed off-line. Not that server side functions, such as searches will probably NOT work, but for [...]
View Answer
| May 19, 2013 12:46 PM
C++, Java
I’m not sure if this is what you are looking for. The programs on this page are all offline viewers. They grab a page, or an entire site and save them on you local HD where they can be veiwed off-line. Not that server side functions, such as searches will probably NOT work, but for [...]
View Answer
| May 19, 2013 12:46 PM
C++, Java
The request could not be submitted for background processing
I am running a CrystalReport 10 report thru ODBC to MS Sql 2000 db. There are Many subreports that are not running until I manually RESET teh SQL Query of Each SubQuery. IS there a Global Update for all subquery within a report?
View Answer
| November 5, 2009 9:19 PM
Crystal Reports 10, Visual Studio 2005
I am running a CrystalReport 10 report thru ODBC to MS Sql 2000 db. There are Many subreports that are not running until I manually RESET teh SQL Query of Each SubQuery. IS there a Global Update for all subquery within a report?
View Answer
| November 5, 2009 9:19 PM
Crystal Reports 10, Visual Studio 2005
CGI loses percent sign
A percent sign, along with the plus sign and ampersand, are special characters. You need to send them to your page encoded. See this thread: http://archive.midrange.com/web400/200207/msg00106.html
View Answer
| November 4, 2009 11:05 PM
CGI, RPGLE, Web application development
A percent sign, along with the plus sign and ampersand, are special characters. You need to send them to your page encoded. See this thread: http://archive.midrange.com/web400/200207/msg00106.html
View Answer
| November 4, 2009 11:05 PM
CGI, RPGLE, Web application development
FTP transfer from iSeries to PC workstation
I did a search on Google http://www.google.com/search?hl=en&lr=&q=as%2F400+ftp+pc and the first hit gives information on a book that tells you how to do just that. ========================================================== There are about 3.5 million google hits for [ftp message 550]. Looking at just a couple (e.g., <a href=”http://support.ipswitch.com/kb/WS-20000817-DM02.htm”>from WS_FTP</a>, <a href=”http://forum.filezilla-project.org/viewtopic.php?f=2&t=8596″>or from a FileZilla forum</a>) makes fairly clear that [...]
View Answer
| November 4, 2009 6:35 AM
AS/400, Database, Development, Network management software, Networking, Performance management, Remote management
I did a search on Google http://www.google.com/search?hl=en&lr=&q=as%2F400+ftp+pc and the first hit gives information on a book that tells you how to do just that. ========================================================== There are about 3.5 million google hits for [ftp message 550]. Looking at just a couple (e.g., <a href=”http://support.ipswitch.com/kb/WS-20000817-DM02.htm”>from WS_FTP</a>, <a href=”http://forum.filezilla-project.org/viewtopic.php?f=2&t=8596″>or from a FileZilla forum</a>) makes fairly clear that [...]
View Answer
| November 4, 2009 6:35 AM
AS/400, Database, Development, Network management software, Networking, Performance management, Remote management
Message Queue
I don’t think you can by any conventional means. One of the messaging API’s at the info center may help though. You can find them at: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/mh1.htm ======================================================== A message queue may be allocated for *CHANGE (delete) to a single job at a time. Any number of jobs may (add) but only one can (delete). [...]
View Answer
| November 3, 2009 1:07 PM
AS/400, AS/400 message queues, Message Queuing
I don’t think you can by any conventional means. One of the messaging API’s at the info center may help though. You can find them at: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/mh1.htm ======================================================== A message queue may be allocated for *CHANGE (delete) to a single job at a time. Any number of jobs may (add) but only one can (delete). [...]
View Answer
| November 3, 2009 1:07 PM
AS/400, AS/400 message queues, Message Queuing
Binder Language
Check out these articles. http://search400.techtarget.com/tip/1,289483,sid3_gci1141217,00.html http://search400.techtarget.com/tip/1,289483,sid3_gci1146796,00.html http://search400.techtarget.com/tip/0,289483,sid3_gci1150118,00.html# As well as a plethora of other hits at: http://www.google.com/search?hl=en&ei=skzvSp_vNoTclAfN5pEr&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CBAQBSgA&q=binder+language&spell=1 ===================================================== A primary purpose of binder language is to allow multiple generations of a service program to remain linked to programs. It provides a kind of ‘level check’ to the programs that use its procedures. As new procedures [...]
View Answer
| November 3, 2009 8:56 AM
AS/400 Binding Directory, AS/400 programming, Databinding, iSeries
Check out these articles. http://search400.techtarget.com/tip/1,289483,sid3_gci1141217,00.html http://search400.techtarget.com/tip/1,289483,sid3_gci1146796,00.html http://search400.techtarget.com/tip/0,289483,sid3_gci1150118,00.html# As well as a plethora of other hits at: http://www.google.com/search?hl=en&ei=skzvSp_vNoTclAfN5pEr&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CBAQBSgA&q=binder+language&spell=1 ===================================================== A primary purpose of binder language is to allow multiple generations of a service program to remain linked to programs. It provides a kind of ‘level check’ to the programs that use its procedures. As new procedures [...]
View Answer
| November 3, 2009 8:56 AM
AS/400 Binding Directory, AS/400 programming, Databinding, iSeries
SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
I had the same question and could not easily find any answers. Here is what I came up with. The sysobjects table stores each table name with a type = ‘u’ The syscolumns table stores the column name for each table. Each of these tables shares an ID column, which you can use to join [...]
View Answer
| November 3, 2009 12:20 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
I had the same question and could not easily find any answers. Here is what I came up with. The sysobjects table stores each table name with a type = ‘u’ The syscolumns table stores the column name for each table. Each of these tables shares an ID column, which you can use to join [...]
View Answer
| November 3, 2009 12:20 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
calling a URL from RPG OR CL
Check out this article: http://systeminetwork.com/article/use-cgi-redirects-launch-long-urls. It requires a membership but i think a free on will work. If not you can get the code from: http://www.pentontech.com/IBMContent/Documents/article/55778_385_OpenUrl.zip
View Answer
| November 2, 2009 9:17 PM
AS/400, AS/400 Web Access, URL
Check out this article: http://systeminetwork.com/article/use-cgi-redirects-launch-long-urls. It requires a membership but i think a free on will work. If not you can get the code from: http://www.pentontech.com/IBMContent/Documents/article/55778_385_OpenUrl.zip
View Answer
| November 2, 2009 9:17 PM
AS/400, AS/400 Web Access, URL
DataGridView – first cell appears blank when navigating bindingsource
I found my mistake. In order to make the selection invisible, I had changed the SelectionBackColor to white so the text color was white on a white background. Setting the SelectionForeColor to black did the job. Selection highlight is invisible but values are now readable.
View Answer
| November 2, 2009 9:01 PM
.NET Framework 3.5, DataGridView, Visual Basic .NET
I found my mistake. In order to make the selection invisible, I had changed the SelectionBackColor to white so the text color was white on a white background. Setting the SelectionForeColor to black did the job. Selection highlight is invisible but values are now readable.
View Answer
| November 2, 2009 9:01 PM
.NET Framework 3.5, DataGridView, Visual Basic .NET
How can i send my VB.Net output to Tally ?
<pre></pre>
View Answer
| November 2, 2009 11:24 AM
Tally, VB.NET 2005
<pre></pre>
View Answer
| November 2, 2009 11:24 AM
Tally, VB.NET 2005
Equivalent of a Application MAKE file on AS400
This might be of some help. It is one of the make files for a combined language (RPG and C) for an application by Giuseppe Costagliola. Maybe it will be of some help. SAY “========================================” SAY ‘Initialise fax decoder tables’ SAY “========================================” /* source files directory */ SRCDIR = ‘/pdf/libtiff-3.7.2/’ “CD /” “CD DIR(&SRCDIR)” “CHGJOB [...]
View Answer
| November 1, 2009 10:37 AM
AS/400, Database, Development
This might be of some help. It is one of the make files for a combined language (RPG and C) for an application by Giuseppe Costagliola. Maybe it will be of some help. SAY “========================================” SAY ‘Initialise fax decoder tables’ SAY “========================================” /* source files directory */ SRCDIR = ‘/pdf/libtiff-3.7.2/’ “CD /” “CD DIR(&SRCDIR)” “CHGJOB [...]
View Answer
| November 1, 2009 10:37 AM
AS/400, Database, Development
STRQMQRY problem
Do you want to remove the prompt because it’s always the same company? It looks like you want company 10 from your DCL statements… you can change the setvar to use the &COMP# rather than the &OSCOMP variable. ===================================================== You have &OSCOMP declared as a *CHAR — is oscomp in the table a CHAR or [...]
View Answer
| October 31, 2009 11:26 AM
AS/400, Certifications, Data analysis, Development, Lifecycle development, Software Quality Assurance, Software testing
Do you want to remove the prompt because it’s always the same company? It looks like you want company 10 from your DCL statements… you can change the setvar to use the &COMP# rather than the &OSCOMP variable. ===================================================== You have &OSCOMP declared as a *CHAR — is oscomp in the table a CHAR or [...]
View Answer
| October 31, 2009 11:26 AM
AS/400, Certifications, Data analysis, Development, Lifecycle development, Software Quality Assurance, Software testing
CPYTOPCD filename length limitation
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
how to read records from Externally Described file into data structure
In the ILE RPG reference manual the follwoing is listed: If file name refers to an externally-described file or a record format from an externally described file, the data structure must be a data structure defined with EXTNAME(…:*INPUT) or LIKEREC(…:*INPUT). You don’t show these keywords on your DS definition. ======================================================== There is no need for [...]
View Answer
| October 31, 2009 7:57 AM
Development, RPG
In the ILE RPG reference manual the follwoing is listed: If file name refers to an externally-described file or a record format from an externally described file, the data structure must be a data structure defined with EXTNAME(…:*INPUT) or LIKEREC(…:*INPUT). You don’t show these keywords on your DS definition. ======================================================== There is no need for [...]
View Answer
| October 31, 2009 7:57 AM
Development, RPG
QMF issue
Try adding OVERRIDING SYSTEM VALUE here: <pre>INSERT INTO destination table OVERRIDING SYSTEM VALUE SELECT * FROM origin table </pre> Without knowing more than what you show, it’s hard to be about exact syntax or even if it’s appropriate. There’s no way to be sure that the schemas match up between QMF and interactive SQL, nor [...]
View Answer
| October 31, 2009 1:40 AM
AS/400 DB2, QMF, Query Management Facility, SQL
Try adding OVERRIDING SYSTEM VALUE here: <pre>INSERT INTO destination table OVERRIDING SYSTEM VALUE SELECT * FROM origin table </pre> Without knowing more than what you show, it’s hard to be about exact syntax or even if it’s appropriate. There’s no way to be sure that the schemas match up between QMF and interactive SQL, nor [...]
View Answer
| October 31, 2009 1:40 AM
AS/400 DB2, QMF, Query Management Facility, SQL
How to convert LONG to CLOB or to VARCHAR type in select statement
Have you tried to_string()?
View Answer
| October 30, 2009 10:29 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL
Have you tried to_string()?
View Answer
| October 30, 2009 10:29 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL
