vb 6.0 conect with access to create a report
i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id should be print [...]

Answer Question   |  December 26, 2008  6:58 AM
Microsoft Access, VB, VB 6

Hide Header In Access Report
Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page [...]

Answer Question   |  December 25, 2008  10:12 PM
Access, Access reports, Database

Scrolling Popup window by search in FoxPro 2.6
I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. [...]

Answer Question   |  December 24, 2008  10:37 AM
FoxPro, FoxPro 2.6

converting text string to numeric
I am using Access 2003. I have a table with numbers that are shown as text data. I want to convert from text to numeric. Can this be done in a table or a query?

Answer Question   |  December 24, 2008  10:53 PM
Access 2003, text to numeric

How to send the data from a Physical file to a Flat file
Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF [...]

Answer Question   |  December 23, 2008  12:45 PM
Flat files, Physical File, RPG, RPG error handling, RPG/400, RPG/400 field validation

Searching using Oracle Forms 6i
Hello i am using forms 6i.I have a form where I am working on some DMLs. When I enter data in text items and press save button, all the records inserted successfully. On save button there is commit_form on When_Button_Pressed trigger. The problem is when I open the same form, search for a specific record, [...]

Answer Question   |  May 11, 2012  9:20 AM
Data Manipulation Language, Oracle development, Oracle DML statements, Oracle Form Builder, Oracle Forms, Oracle Forms 6i

PCI Complaince
How does one become credited to do audits for PCI compliance .. what are the steps to be followed .. Does anyone know or understand the cost .. IS it a comp-any or an individual that gets a certificated or both ? what if the employees leaves does the company stay certified ?

Answer Question   |  January 25, 2010  8:55 PM
IT careers, PCI compliance, PCI Compliance and Acquisitions, PCI Compliance Careers

Script to restore database permissions during a migration to SQL Server 2005
We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I’m searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the database [...]

Answer Question   |  December 24, 2008  3:13 PM
Database permissions, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Permissions, SQL Server databases

Setting run priority on prestart jobs
We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application’s queries can have a higher priority than another application’s queries? Since each application’s queries always use the same user ID, can [...]

Answer Question   |  January 6, 2009  3:07 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT

Embedded SQL to process ALL members
Hi, I’m trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn’t seem to work anymore. In the joblog I get a CPF4268 message which says [...]

Answer Question   |  December 22, 2008  12:54 PM
AS/400, Embedded SQL, i, iSeries, Member, OVRDBF, RPG, SQL

Query performance and tuning
Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when [...]

Answer Question   |  December 29, 2008  9:34 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements

Suggestions and guidance for IT courses/career
Hi david, I m vaibahv from india i jus saw ur blog n info about ur courses. I want sum suggetions from u…..i m doing Bs.IT n i have don basic networking course(TCP/IP) n m doing job from last 4 yr but b coz of i dont have any cirtification i dont get the sallary [...]

Answer Question   |  February 18, 2009  3:36 AM
Career development, CCNA, Certifications, Cisco certifications, Cisco Certified Network Associate, IT careers, IT education, IT training, Linux administration, Linux certifications, Networking certifications

Index Strategy for existing SQL Server 2005 project
Hi All I Newly joined with new Project,My Boss told me that Create Index strategy document which in excisting Project. I don’t where to start. I prepared some documents which is basically saying about Index recomandation,When we have to creat Indexes,and so other stuff which is finding most used Indexes and Unused index on so….on. [...]

Answer Question   |  December 22, 2008  2:30 PM
Database index strategy, Index strategy, SQL Server 2005, SQL Server 2005 index strategy, SQL Server index strategy

Moving data from one DB to another DB in SQL Server 2005
Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length columns Max_Var_Size = maximum byte size of all variable-length columns Null_Bitmap = [...]

Answer Question   |  December 22, 2008  2:22 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration

Joining Tables in SQL Server
What is the difference between Outerjoin and Left outerjoin.

Answer Question   |  December 20, 2008  10:23 AM
JOIN statement, LEFT OUTER JOIN statement, OUTER JOIN statement, SQL Server development, SQL Server Query, SQL statements

Using the SQL IN clause in SQLRPGLE
Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

Answer Question   |  December 19, 2008  10:09 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement

Update a field in one table after the change on a field in another table using a trigger in SQL
I have a WODet table and after the field “Complete” is changed to “True” I need to update my SODet table field “UD3″ to “True” using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

Answer Question   |  December 18, 2008  7:08 PM
SQL, Triggers

Creating form with combo box to enter data
I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.

Answer Question   |  December 17, 2008  3:41 PM
ComboBox, Microsoft Access

Using WildCards in IIF Statement
Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don’t enter anything in the field on the form. I tried putting the following IIF statement in the Criteria: [...]

Answer Question   |  December 17, 2008  3:38 PM
Access query, IIF statement, Microsoft Access, SQL, Wildcards

Clustered and Non-clustered Index
Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]

Answer Question   |  December 17, 2008  1:51 PM
Clustered Index, Non-Clustered Index, Query optimization