store image from a directory into oracle database using sql
Have a look at <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-insert-a-image-file-into-oracle-8i-database/”>this question/answer</a>. You will find an example of how to save a picture in the database there.
View Answer
| July 17, 2009 2:34 PM
Image databases, Oracle image storage, SQL, SQLPlus
Have a look at <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-insert-a-image-file-into-oracle-8i-database/”>this question/answer</a>. You will find an example of how to save a picture in the database there.
View Answer
| July 17, 2009 2:34 PM
Image databases, Oracle image storage, SQL, SQLPlus
Modify MS Access using iSeries RPGLE
Someone more knowledgeable than I may have an asnwer – they may need to know the versions of Access and your AS/400. — here’s what I know. I haven’t found a request from the AS/400 side. The newer versions of Access tables can be addressed through an ODBC connection. I’ve connected from early versions of [...]
View Answer
| July 17, 2009 1:51 PM
iSeries RPG programming, Microsoft Access, RPGLE
Someone more knowledgeable than I may have an asnwer – they may need to know the versions of Access and your AS/400. — here’s what I know. I haven’t found a request from the AS/400 side. The newer versions of Access tables can be addressed through an ODBC connection. I’ve connected from early versions of [...]
View Answer
| July 17, 2009 1:51 PM
iSeries RPG programming, Microsoft Access, RPGLE
Unable to restrict the display to top N records in subform in Microsoft Access 2003
If you are displaying data from a two different tables are queries on the two forms then there must be a relative field which binds the subfom with the main form. Check that the top 10 records are being filtered by the common field, if yes then the first record of the main form falls [...]
View Answer
| July 16, 2009 4:52 PM
Microsoft Access 2003, Microsoft Access 2003 forms, Microsoft Access 2003 subforms
If you are displaying data from a two different tables are queries on the two forms then there must be a relative field which binds the subfom with the main form. Check that the top 10 records are being filtered by the common field, if yes then the first record of the main form falls [...]
View Answer
| July 16, 2009 4:52 PM
Microsoft Access 2003, Microsoft Access 2003 forms, Microsoft Access 2003 subforms
data copy – paste from the same table not showing in a subform
Hi, If you are using one form with an embedded subform to display the data of two different tables, then there must be a common relative field. I think thats the issue there, when you are copying data to the sub table the data that should be in the main table is missing. This is [...]
View Answer
| July 16, 2009 4:30 PM
Database programming, Microsoft Access, Microsoft Access 2007
Hi, If you are using one form with an embedded subform to display the data of two different tables, then there must be a common relative field. I think thats the issue there, when you are copying data to the sub table the data that should be in the main table is missing. This is [...]
View Answer
| July 16, 2009 4:30 PM
Database programming, Microsoft Access, Microsoft Access 2007
IT projects
There are a number of freelance roles which would suit you and would allow you to build up a base to then contact other companies, so i would suggest you use either oDesk or ELancer and then get work on projects there.
View Answer
| July 16, 2009 3:45 PM
IT careers, IT Job Market, IT outsourcing, IT project management, QA testing, Software Test Lead
There are a number of freelance roles which would suit you and would allow you to build up a base to then contact other companies, so i would suggest you use either oDesk or ELancer and then get work on projects there.
View Answer
| July 16, 2009 3:45 PM
IT careers, IT Job Market, IT outsourcing, IT project management, QA testing, Software Test Lead
We are runing V5R1 OS400, how do I write to CSV file
Have you tried cpytoimpf to a file with only one field defined for the entire record? =================================================================================== 1. Create a physical file (CRTPF) at least as wide as the spool file 2. copy the spool file (CPFSPLF) to the physical file 3. Create a .cvs file (CPYTOIMPF) I don’t think you’ll like the outcome. Each [...]
View Answer
| July 15, 2009 5:57 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400
Have you tried cpytoimpf to a file with only one field defined for the entire record? =================================================================================== 1. Create a physical file (CRTPF) at least as wide as the spool file 2. copy the spool file (CPFSPLF) to the physical file 3. Create a .cvs file (CPYTOIMPF) I don’t think you’ll like the outcome. Each [...]
View Answer
| July 15, 2009 5:57 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400
Microsoft Access Audit Report
I submitted an answer already to this, but it never showed up… The bare bones of the problem I see as: 1. It depends on your table and field structure. 2. An historical record table is assumed. 3. May wish to use use TOP in your select query-behind-the-report. TOP 2, for example. 4. May wish [...]
View Answer
| July 14, 2009 5:21 PM
Access Database, Access reports, Audit Reports, Audits, IT audits, Microsoft Access
I submitted an answer already to this, but it never showed up… The bare bones of the problem I see as: 1. It depends on your table and field structure. 2. An historical record table is assumed. 3. May wish to use use TOP in your select query-behind-the-report. TOP 2, for example. 4. May wish [...]
View Answer
| July 14, 2009 5:21 PM
Access Database, Access reports, Audit Reports, Audits, IT audits, Microsoft Access
External document used as an Access Form?
Go to the “External Data” tab and look for the ‘Import’ section. That should be what you are looking for. It has multiple options for different files to import.
View Answer
| July 14, 2009 4:25 PM
Access 2007, Microsoft Access
Go to the “External Data” tab and look for the ‘Import’ section. That should be what you are looking for. It has multiple options for different files to import.
View Answer
| July 14, 2009 4:25 PM
Access 2007, Microsoft Access
How would be the opportunities for AS400 in future
There will always be mainframes and AS/400′s and deveolper who will deveolp the systems. When I was looking for a job six years ago, there was very few mainframe positions available, but there numerous AS/400 positions available but the numbers were dwintering because a lot of the jobs were going overseas. Now, I’m afraid if [...]
View Answer
| July 14, 2009 4:20 PM
AS/400 careers, Career development, IT careers, Mainframe
There will always be mainframes and AS/400′s and deveolper who will deveolp the systems. When I was looking for a job six years ago, there was very few mainframe positions available, but there numerous AS/400 positions available but the numbers were dwintering because a lot of the jobs were going overseas. Now, I’m afraid if [...]
View Answer
| July 14, 2009 4:20 PM
AS/400 careers, Career development, IT careers, Mainframe
Connection of Crystal Report 2008 with VB6.
You need to purchase <a href=”http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/visualstudio/index.epx”>Crystal Reports for Visual Studio .NET</a> or Crystal Reports Developer Advantage licenses.
View Answer
| July 14, 2009 12:11 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
You need to purchase <a href=”http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/visualstudio/index.epx”>Crystal Reports for Visual Studio .NET</a> or Crystal Reports Developer Advantage licenses.
View Answer
| July 14, 2009 12:11 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
Slow SQL Query
First you need to get rid of the Substring function in the where clause. Using any functions against the columns in the where clause will kill your performance as your index becomes useless. Instead you should be doing something like this. <pre>select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and AuditData.CallTo LIKE ’00500004%’ [...]
View Answer
| July 13, 2009 9:12 PM
Slow SQL Query, SQL queries, SQL query optimization
First you need to get rid of the Substring function in the where clause. Using any functions against the columns in the where clause will kill your performance as your index becomes useless. Instead you should be doing something like this. <pre>select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and AuditData.CallTo LIKE ’00500004%’ [...]
View Answer
| July 13, 2009 9:12 PM
Slow SQL Query, SQL queries, SQL query optimization
networking
Try to take as many networking classes as you can – especially ones centered about TCP/IP. Learning the basics of TCP/IP is one of the most important things you can ever do for a career in networking. Best of luck!!
View Answer
| July 13, 2009 1:19 PM
IT careers, IT education, Networking careers
Try to take as many networking classes as you can – especially ones centered about TCP/IP. Learning the basics of TCP/IP is one of the most important things you can ever do for a career in networking. Best of luck!!
View Answer
| July 13, 2009 1:19 PM
IT careers, IT education, Networking careers
Showing a substiute value in a report if conditions are met – Access
Use expression instead of field. For example, <pre>issued: IIf([Issue Date] Is Not Null;’ISSUED’)</pre>
View Answer
| July 12, 2009 3:52 PM
Access 2003, Microsoft Access, Reports
Use expression instead of field. For example, <pre>issued: IIf([Issue Date] Is Not Null;’ISSUED’)</pre>
View Answer
| July 12, 2009 3:52 PM
Access 2003, Microsoft Access, Reports
DO…LOOP and IF ELSE THEN statements
well there are other ways of writing it, it depends on what programming language your using?to answer your question,its not just the “DO..and IF ELSE THEN STATEMENTS” when creating a basic program..did you ever tried using an “Object Oriented Programming” method acronym “OOP” that would solve your problem
View Answer
| July 12, 2009 5:35 AM
Accumulators, Counters, DO LOOP statement, IF ELSE statement, LOOP statement
well there are other ways of writing it, it depends on what programming language your using?to answer your question,its not just the “DO..and IF ELSE THEN STATEMENTS” when creating a basic program..did you ever tried using an “Object Oriented Programming” method acronym “OOP” that would solve your problem
View Answer
| July 12, 2009 5:35 AM
Accumulators, Counters, DO LOOP statement, IF ELSE statement, LOOP statement
With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?
Say, you have two fields – id and name. Insert formula in the name field : <pre>=DLookUp(“[vendor name]“;”Vendor”;”[vendor id]=” & [id])</pre>
View Answer
| July 11, 2009 7:11 PM
Access 2007, Access Database, Access forms, Database design, Microsoft Access
Say, you have two fields – id and name. Insert formula in the name field : <pre>=DLookUp(“[vendor name]“;”Vendor”;”[vendor id]=” & [id])</pre>
View Answer
| July 11, 2009 7:11 PM
Access 2007, Access Database, Access forms, Database design, Microsoft Access
Need Help Regarding Network Security Certifications?
Since you are just a beginner The ideal certification for will CCNA Security 640-553 IINS , but the prerequisite for this certification is to have a valid CCNA -640-802. So you should pass the CCNA -640-802 before appearing to CCNA Security 640-553 IINS. You have one more option to be on the Security track is [...]
View Answer
| July 11, 2009 11:54 AM
Certifications, IT careers, Networking careers, Networking certifications, Security certifications
Since you are just a beginner The ideal certification for will CCNA Security 640-553 IINS , but the prerequisite for this certification is to have a valid CCNA -640-802. So you should pass the CCNA -640-802 before appearing to CCNA Security 640-553 IINS. You have one more option to be on the Security track is [...]
View Answer
| July 11, 2009 11:54 AM
Certifications, IT careers, Networking careers, Networking certifications, Security certifications
Access Subform Blank
Which version of MS Access you are using on which you area facing this issue? Also, did you created This sub form using Wizard. Do you see the sub form listed under form object? Do you see the empty sub form object appear empty on form or it don’t appear at all? If you see [...]
View Answer
| July 11, 2009 5:40 AM
Access 2003, Microsoft Access, Microsoft Access subforms
Which version of MS Access you are using on which you area facing this issue? Also, did you created This sub form using Wizard. Do you see the sub form listed under form object? Do you see the empty sub form object appear empty on form or it don’t appear at all? If you see [...]
View Answer
| July 11, 2009 5:40 AM
Access 2003, Microsoft Access, Microsoft Access subforms
Microsoft 2003 Access relationship window
The bolded fields are normally the identity fileds such as the ID. Bye The bolded field is the primary key in that table. The primary key is normally a single field, but two or more fields can act together as the primary key, so long as their combined values are unique.
View Answer
| July 8, 2009 1:27 PM
Access 2003, Microsoft Access, Relationship window
The bolded fields are normally the identity fileds such as the ID. Bye The bolded field is the primary key in that table. The primary key is normally a single field, but two or more fields can act together as the primary key, so long as their combined values are unique.
View Answer
| July 8, 2009 1:27 PM
Access 2003, Microsoft Access, Relationship window
dba deleting data
It can be, provided that the request is sent through the normal approved change process. If a developer walks up to you and asks you to delete data from a table, then its probably not an approved change. However if that request comes to you through the proper change control procedures then yes. No one [...]
View Answer
| July 8, 2009 1:07 AM
Database Administrator, DBA, SQL scripts
It can be, provided that the request is sent through the normal approved change process. If a developer walks up to you and asks you to delete data from a table, then its probably not an approved change. However if that request comes to you through the proper change control procedures then yes. No one [...]
View Answer
| July 8, 2009 1:07 AM
Database Administrator, DBA, SQL scripts
conversion from FileMaker Pro to Microsoft Access database
Well first off the previous answer was correct in that Access cannot read FileMaker files. Unless you have some very specific need to down grade the capability you probably should not be converting to Access, instead use the greater capability of FileMaker which goes beyond Access. That being said, if you really do have some [...]
View Answer
| July 7, 2009 3:06 AM
Access 2007, Access Database, Filemaker Pro, FileMaker Pro 7, Microsoft Access
Well first off the previous answer was correct in that Access cannot read FileMaker files. Unless you have some very specific need to down grade the capability you probably should not be converting to Access, instead use the greater capability of FileMaker which goes beyond Access. That being said, if you really do have some [...]
View Answer
| July 7, 2009 3:06 AM
Access 2007, Access Database, Filemaker Pro, FileMaker Pro 7, Microsoft Access
