Free SQL software with interface to enter data
You could use <a href=”http://www.openoffice.org/”>OpenOffice’s</a> Base. Base is similar to Access, but is free. Here’s a guide in case you decide to use it: <a href=”http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf”>Getting Started with Base (OpenOffice.org’s Database Component)</a> (PDF)
View Answer
| October 17, 2011 4:17 PM
Data entry, Free software, Freeware, SQL, SQL Query
You could use <a href=”http://www.openoffice.org/”>OpenOffice’s</a> Base. Base is similar to Access, but is free. Here’s a guide in case you decide to use it: <a href=”http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf”>Getting Started with Base (OpenOffice.org’s Database Component)</a> (PDF)
View Answer
| October 17, 2011 4:17 PM
Data entry, Free software, Freeware, SQL, SQL Query
Auto Serial Number in VB DataReport
Can you tell me how can I create serial number in vb6 report for seperate item?
View Answer
| October 16, 2011 2:34 PM
Auto Serial Number, VB, VB Data Report, Visual Basic
Can you tell me how can I create serial number in vb6 report for seperate item?
View Answer
| October 16, 2011 2:34 PM
Auto Serial Number, VB, VB Data Report, Visual Basic
Crystal Report based on sql query with more than two tables
its very easy u have to use below code for ur project try { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cr.Load(“C:\Users\NOOR-UL-AIN\Documents\Visual Studio 10\Projects\invoice\invoice\commercial invoice\commercial invoice\MyReport.rpt”); crConnectionInfo.ServerName = “your server name”; crConnectionInfo.DatabaseName = “database”; crConnectionInfo.UserID = “userid”; crConnectionInfo.Password = “password”; CrTables = cr.Database.Tables ; foreach [...]
View Answer
| October 16, 2011 9:54 AM
C# .NET, Crystal Report, Visual Studio 2008
its very easy u have to use below code for ur project try { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cr.Load(“C:\Users\NOOR-UL-AIN\Documents\Visual Studio 10\Projects\invoice\invoice\commercial invoice\commercial invoice\MyReport.rpt”); crConnectionInfo.ServerName = “your server name”; crConnectionInfo.DatabaseName = “database”; crConnectionInfo.UserID = “userid”; crConnectionInfo.Password = “password”; CrTables = cr.Database.Tables ; foreach [...]
View Answer
| October 16, 2011 9:54 AM
C# .NET, Crystal Report, Visual Studio 2008
EXTENDED: IT Scripts Contest now ends October 17
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Job Scheduler affecting environment variable
Thanks everyone for replying. I discovered that I need to change the override scope to *JOB.for the OVRDBF command for STDOUT. Somehow the default override scope works fine for SMJOB, but not when the program is called by a scheduled job.
View Answer
| October 11, 2011 8:00 AM
CL Program, iSeries job scheduler, Job scheduling, QSH environment variable, SBMJOB
Thanks everyone for replying. I discovered that I need to change the override scope to *JOB.for the OVRDBF command for STDOUT. Somehow the default override scope works fine for SMJOB, but not when the program is called by a scheduled job.
View Answer
| October 11, 2011 8:00 AM
CL Program, iSeries job scheduler, Job scheduling, QSH environment variable, SBMJOB
Corrupted database file with Memo Field in FoxPro 2.6
Determining given trouble can be <a href=”http://www.recoverytoolbox.com/dbf.html”>repair .dbf</a>. It has easy to use interface for any experienced users, tool can’t change source data during restoration. Program starts under low system requirements and any major version of Windows OS.
View Answer
| October 10, 2011 8:40 PM
Corrupted database, FoxPro, FoxPro 2.6, FoxPro errors
Determining given trouble can be <a href=”http://www.recoverytoolbox.com/dbf.html”>repair .dbf</a>. It has easy to use interface for any experienced users, tool can’t change source data during restoration. Program starts under low system requirements and any major version of Windows OS.
View Answer
| October 10, 2011 8:40 PM
Corrupted database, FoxPro, FoxPro 2.6, FoxPro errors
Return only one word– SQL
If you know that there is a match why not just return the value that you are looking for? If you wanted to pull the value from the column you would need to use the SUBSTRING and PATINDEX (in SQL Server at least) to get that value from the column.
View Answer
| October 5, 2011 11:53 PM
Oracle, Oracle SQL, SQL, SQL Server
If you know that there is a match why not just return the value that you are looking for? If you wanted to pull the value from the column you would need to use the SUBSTRING and PATINDEX (in SQL Server at least) to get that value from the column.
View Answer
| October 5, 2011 11:53 PM
Oracle, Oracle SQL, SQL, SQL Server
Error Message in SQL Server 2008 code.
Remove the comma after Emp.LoginID.
View Answer
| October 5, 2011 1:33 PM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
Remove the comma after Emp.LoginID.
View Answer
| October 5, 2011 1:33 PM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
INZSR with RETURN & INLR
This question was just asked and answered. http://itknowledgeexchange.techtarget.com/itanswers/inzsr/
View Answer
| October 5, 2011 12:43 PM
*INZSR, Coding, RPGLE
This question was just asked and answered. http://itknowledgeexchange.techtarget.com/itanswers/inzsr/
View Answer
| October 5, 2011 12:43 PM
*INZSR, Coding, RPGLE
Free recovery tools for Lotus Notes
Hi Sirong, Unfortunately, there is no such free tool to repair/recover NSF file. Although the demo version of such tools are available for free but they only show the recoverable components of a corrupt NSF file. To save the recovered NSF file you need to buy the license fo the tool. One such NSF file [...]
View Answer
| October 5, 2011 5:10 AM
.NSF files, Freeware, Lotus backup and recovery, Lotus Notes, Lotus Notes recovery tools
Hi Sirong, Unfortunately, there is no such free tool to repair/recover NSF file. Although the demo version of such tools are available for free but they only show the recoverable components of a corrupt NSF file. To save the recovered NSF file you need to buy the license fo the tool. One such NSF file [...]
View Answer
| October 5, 2011 5:10 AM
.NSF files, Freeware, Lotus backup and recovery, Lotus Notes, Lotus Notes recovery tools
Free IT Book: IP Networking
just answered Users not receiving alerts to new General Discussion – http://itknowledgeexchange.techtarget.com/itanswers/users-not-receiving-alerts-to-new-general-discussion/#viewquestion hope to win IP Networking book
View Answer
| October 4, 2011 7:37 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
just answered Users not receiving alerts to new General Discussion – http://itknowledgeexchange.techtarget.com/itanswers/users-not-receiving-alerts-to-new-general-discussion/#viewquestion hope to win IP Networking book
View Answer
| October 4, 2011 7:37 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
MYSQL database high availability
MSQL – <b>MySQL Backup and Recovery </b> http://www.zmanda.com/backup-mysql.html Schedule full and incremental backups of your MySQL database. Backup and Recovery Only. <b>(If you can)</b> SQL Server – <b>Database Mirroring Best Practices and Performance Considerations </b> http://technet.microsoft.com/en-gb/library/cc917681.aspx[ <b>http://technet.microsoft.com/en-us/library/dd207314.aspx</b> <b>Database mirroring requirements</b> Become familiar with the recommendations in the following list, and ensure that your databases and [...]
View Answer
| October 4, 2011 11:21 AM
CentOS, LAMP, MySQL, MySQL Database, MySQL functions
MSQL – <b>MySQL Backup and Recovery </b> http://www.zmanda.com/backup-mysql.html Schedule full and incremental backups of your MySQL database. Backup and Recovery Only. <b>(If you can)</b> SQL Server – <b>Database Mirroring Best Practices and Performance Considerations </b> http://technet.microsoft.com/en-gb/library/cc917681.aspx[ <b>http://technet.microsoft.com/en-us/library/dd207314.aspx</b> <b>Database mirroring requirements</b> Become familiar with the recommendations in the following list, and ensure that your databases and [...]
View Answer
| October 4, 2011 11:21 AM
CentOS, LAMP, MySQL, MySQL Database, MySQL functions
Finding Holes in Numerical Sequence
So Tom or anyone out there …what if I would generate a query that would bring all that I need into a table. Then use a macro to remove all the unwanted alpha codes. Then some how link that new data to the hole finding query? Anyone have any suggestion or added ideas?
View Answer
| October 3, 2011 11:27 AM
Access Datasheet, AS400 iseries, SQL, SQL Query
So Tom or anyone out there …what if I would generate a query that would bring all that I need into a table. Then use a macro to remove all the unwanted alpha codes. Then some how link that new data to the hole finding query? Anyone have any suggestion or added ideas?
View Answer
| October 3, 2011 11:27 AM
Access Datasheet, AS400 iseries, SQL, SQL Query
PHP implementation
While PHP is by no means my area of expertise, I did do a little searching for you and found a pretty good website for an overall gist PHP setup and utilization. The website is <a href=”http://www.oxxus.net/tutorials/php”>Oxxus</a> and seems to provide some pretty good information. As far as using with an I Series server, it [...]
View Answer
| October 1, 2011 7:48 AM
PHP, PHP implementation, PHP installation, PHP scripts
While PHP is by no means my area of expertise, I did do a little searching for you and found a pretty good website for an overall gist PHP setup and utilization. The website is <a href=”http://www.oxxus.net/tutorials/php”>Oxxus</a> and seems to provide some pretty good information. As far as using with an I Series server, it [...]
View Answer
| October 1, 2011 7:48 AM
PHP, PHP implementation, PHP installation, PHP scripts
Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
What is the best why to get started in DBA
I was in about the same situation when our System Admin/DBA left and I just inherited the job. That is a stressful way to start, but I learned fast. I did eventually get some training through an IBM business partner – after I had already done it for awhile. That actually makes sense from the [...]
View Answer
| September 28, 2011 8:06 PM
Access, DBA training, iSeries database, SQL
I was in about the same situation when our System Admin/DBA left and I just inherited the job. That is a stressful way to start, but I learned fast. I did eventually get some training through an IBM business partner – after I had already done it for awhile. That actually makes sense from the [...]
View Answer
| September 28, 2011 8:06 PM
Access, DBA training, iSeries database, SQL
Is there a GodMode for Windows XP?
All “God Mode” is, is all the options which are available in the control panel in a single screen. You can also have the “Fuzzy Puppy” mode by naming the folder “Fuzzy Puppy.{ED7BA470-8E54-465E-825C-99712043E01C}”. So yes, Windows XP has this same feature (as does every Windows OS) it is called the control panel.
View Answer
| April 18, 2013 1:42 PM
Microsoft .NET, Windows, XML
All “God Mode” is, is all the options which are available in the control panel in a single screen. You can also have the “Fuzzy Puppy” mode by naming the folder “Fuzzy Puppy.{ED7BA470-8E54-465E-825C-99712043E01C}”. So yes, Windows XP has this same feature (as does every Windows OS) it is called the control panel.
View Answer
| April 18, 2013 1:42 PM
Microsoft .NET, Windows, XML
Using Dropbox and Radio button with DB2400
No DB2 is a database IBMi aka i series aka As/400 provides all the tools you need to use whatever data presentation takes your fancy.
View Answer
| September 28, 2011 7:24 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
No DB2 is a database IBMi aka i series aka As/400 provides all the tools you need to use whatever data presentation takes your fancy.
View Answer
| September 28, 2011 7:24 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
SQL to query a file
Here’s some sample code i just put together quick using fake information. It just shows a generic way to embed SQL in an ILE RPG program: <pre> d SalesRec DS d Salesman 25A INZ(*blanks) d TotalSales 10S 2 INZ(0) d MaxSale 10S 2 INZ(0) d MinSale 10S 2 INZ(0) ************** c/FREE //Declare a cursor for [...]
View Answer
| September 27, 2011 7:27 PM
Open Query File, RPG, SQL, SQL Query
Here’s some sample code i just put together quick using fake information. It just shows a generic way to embed SQL in an ILE RPG program: <pre> d SalesRec DS d Salesman 25A INZ(*blanks) d TotalSales 10S 2 INZ(0) d MaxSale 10S 2 INZ(0) d MinSale 10S 2 INZ(0) ************** c/FREE //Declare a cursor for [...]
View Answer
| September 27, 2011 7:27 PM
Open Query File, RPG, SQL, SQL Query
Open IT Forum: Will HP be a worthy cloud contender?
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
