Trouble creating SQL statement from MS Access Form
I found this bit of code: Dim escapedString as String escapedString = Replace(nonescapedString, "'", "''") Basically you need to replace the text field’s single-quote to double single-quotes (similar to how in MySQL you need to do ‘ for single quotes.
View Answer
| May 10, 2013 12:56 AM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
I found this bit of code: Dim escapedString as String escapedString = Replace(nonescapedString, "'", "''") Basically you need to replace the text field’s single-quote to double single-quotes (similar to how in MySQL you need to do ‘ for single quotes.
View Answer
| May 10, 2013 12:56 AM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
Calculate Business Hours
I think maybe the clause ((Hour(DateX) >= 8 And Hour(DateX) <= 11) Or (Hour(DateX) >= 13 And Hour(DateX) <= 16)) in Function IsWorkTime is counting time between 8 & 11 and between 1 & 4 as work time. So maybe just changing the 11 to 12 will work. But I can’t be sure because it [...]
View Answer
| May 21, 2010 12:58 PM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
I think maybe the clause ((Hour(DateX) >= 8 And Hour(DateX) <= 11) Or (Hour(DateX) >= 13 And Hour(DateX) <= 16)) in Function IsWorkTime is counting time between 8 & 11 and between 1 & 4 as work time. So maybe just changing the 11 to 12 will work. But I can’t be sure because it [...]
View Answer
| May 21, 2010 12:58 PM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
MySQL brain teaser
Well, I can’t think of a way to avoid the parse-concat approach, but you can do it in one operation. <pre>UPDATE YourTable SET name = CONCAT(LEFT(name,INSTR(name,’ ‘)-1),RIGHT(name,LENGTH(name)-INSTR(name,’ ‘))) WHERE …</pre> I used the INSTR function to find the first blank space position in case it is not always in the second position, but it could [...]
View Answer
| May 19, 2010 6:52 PM
MySQL, MySQL query, SQL
Well, I can’t think of a way to avoid the parse-concat approach, but you can do it in one operation. <pre>UPDATE YourTable SET name = CONCAT(LEFT(name,INSTR(name,’ ‘)-1),RIGHT(name,LENGTH(name)-INSTR(name,’ ‘))) WHERE …</pre> I used the INSTR function to find the first blank space position in case it is not always in the second position, but it could [...]
View Answer
| May 19, 2010 6:52 PM
MySQL, MySQL query, SQL
What is a good OpenSource program for CRM?
You could try <a href=”http://www.opencrx.org/”>OpenCRX</a> or <a href=”http://civicrm.org/”>CiviCRM</a>
View Answer
| May 19, 2010 7:45 AM
CRM, Database import/export, Maximizer, OpenSource Software
You could try <a href=”http://www.opencrx.org/”>OpenCRX</a> or <a href=”http://civicrm.org/”>CiviCRM</a>
View Answer
| May 19, 2010 7:45 AM
CRM, Database import/export, Maximizer, OpenSource Software
what is base 2 to base 10?
Base 2 is binary notation working in powers of 2 and base 10 is what we use normally counting from one to ten. You can see the difference when look at the hard drive space in your operating system. An 80 GB hard drive will show up as roughly 74GB. The 6GB wasn’t used or [...]
View Answer
| May 19, 2010 6:18 AM
Base 10, Base 2, Binary, Binary data, Hard drive space
Base 2 is binary notation working in powers of 2 and base 10 is what we use normally counting from one to ten. You can see the difference when look at the hard drive space in your operating system. An 80 GB hard drive will show up as roughly 74GB. The 6GB wasn’t used or [...]
View Answer
| May 19, 2010 6:18 AM
Base 10, Base 2, Binary, Binary data, Hard drive space
DATABASES TECHNIQUES
You need to google for STAR Schemas and Snowflake Schemas.
View Answer
| May 19, 2010 5:09 AM
Database Management Systems, Database schema, Relational databases
You need to google for STAR Schemas and Snowflake Schemas.
View Answer
| May 19, 2010 5:09 AM
Database Management Systems, Database schema, Relational databases
How to add and / or delete files to modify a program’s installation?
Removing files from the CAB file probably won’t be a good idea. The installer will be looking for them and will probably throw an error if they aren’t there. Updating the Access database should be easy. Double click on the CAB file, and copy out the file. Update it as needed and drag it back [...]
View Answer
| May 19, 2010 4:47 AM
Access Database, CABextract, Deployment, Windows XP
Removing files from the CAB file probably won’t be a good idea. The installer will be looking for them and will probably throw an error if they aren’t there. Updating the Access database should be easy. Double click on the CAB file, and copy out the file. Update it as needed and drag it back [...]
View Answer
| May 19, 2010 4:47 AM
Access Database, CABextract, Deployment, Windows XP
How to get mutiple client lines to appear on a single line
Maybe a <a href=”http://www.databasedev.co.uk/crosstab_queries.html”>Crosstab query</a> could help.
View Answer
| May 18, 2010 6:43 PM
Microsoft Access
Maybe a <a href=”http://www.databasedev.co.uk/crosstab_queries.html”>Crosstab query</a> could help.
View Answer
| May 18, 2010 6:43 PM
Microsoft Access
Powerbuilder .net
It is released Check out the<a href=”http://www.sybase.com/products/modelingdevelopment/powerbuilder”> sybase site</a>. You will need to contact them on cost based on your intented use.
View Answer
| May 18, 2010 3:23 PM
PowerBuilder, Sybase
It is released Check out the<a href=”http://www.sybase.com/products/modelingdevelopment/powerbuilder”> sybase site</a>. You will need to contact them on cost based on your intented use.
View Answer
| May 18, 2010 3:23 PM
PowerBuilder, Sybase
Oracle 10g Database Housekeeping
If I were you, I would ask for clarification of what is expected. Database housekeeping could include any number of things. It might be cleaning up audit (*.aud) and trace (*.trc) files, or backing up and removing archived redo logs. It could be checking internal audit storage or making sure large tables aren’t getting too [...]
View Answer
| May 17, 2010 9:02 PM
Database housekeeping, Database maintenance, Oracle 10g, Oracle Database
If I were you, I would ask for clarification of what is expected. Database housekeeping could include any number of things. It might be cleaning up audit (*.aud) and trace (*.trc) files, or backing up and removing archived redo logs. It could be checking internal audit storage or making sure large tables aren’t getting too [...]
View Answer
| May 17, 2010 9:02 PM
Database housekeeping, Database maintenance, Oracle 10g, Oracle Database
Career switch to software testing
if you are talking about software testing, you don’t need to be expert in programming. you will at least need a basic.. like my friend, she was doing level 1 support and she switch to become a program tester and they will actually give you 1 set of document to test the software following a [...]
View Answer
| May 16, 2010 5:11 AM
Coding, IT careers, IT certification and training, Software testing
if you are talking about software testing, you don’t need to be expert in programming. you will at least need a basic.. like my friend, she was doing level 1 support and she switch to become a program tester and they will actually give you 1 set of document to test the software following a [...]
View Answer
| May 16, 2010 5:11 AM
Coding, IT careers, IT certification and training, Software testing
Oracle 9i Migration from Solaris to AIX
For migration of databases to be hasslefree without the need to recreate all the nitty gritty stuff like indexes, constraints, etc, my personal opinion would be to use the exp/imp utilities for Oracle 9i. Based on my experience with a couple of P690 machines running AIX 5.2, a 25 GB dump file could easily take [...]
View Answer
| May 13, 2010 3:31 PM
Database migration, Migration, Oracle 9i, Solaris, Solaris to AIX
For migration of databases to be hasslefree without the need to recreate all the nitty gritty stuff like indexes, constraints, etc, my personal opinion would be to use the exp/imp utilities for Oracle 9i. Based on my experience with a couple of P690 machines running AIX 5.2, a 25 GB dump file could easily take [...]
View Answer
| May 13, 2010 3:31 PM
Database migration, Migration, Oracle 9i, Solaris, Solaris to AIX
How to eliminate double-entry in Access
Can you show your code?
View Answer
| May 12, 2010 7:50 PM
Access 2007 forms, Microsoft Access, Microsoft Access import/export
Can you show your code?
View Answer
| May 12, 2010 7:50 PM
Access 2007 forms, Microsoft Access, Microsoft Access import/export
writing to a flat file/stream file
Sure, but why would you want to? I/O for stream files/flat files in the IFS is done using APIs, which are much easier to deal with in a language like RPG or COBOL. Use the right tool for the job. ============================================================ As of V5R4, ILE CL handles streamfile I/O almost the same as ILE RPG, [...]
View Answer
| May 11, 2010 8:23 PM
CL programming, Flat files, IBM i, Stream files, V6R1
Sure, but why would you want to? I/O for stream files/flat files in the IFS is done using APIs, which are much easier to deal with in a language like RPG or COBOL. Use the right tool for the job. ============================================================ As of V5R4, ILE CL handles streamfile I/O almost the same as ILE RPG, [...]
View Answer
| May 11, 2010 8:23 PM
CL programming, Flat files, IBM i, Stream files, V6R1
sending e-mail attachememt from mianframe – CSV format
I am not aware of a mainframe product to build a CSV file. After all, from where would one build such a file? Its not as if you are running EXCEL on the mainframe. Well, we did use to have VisiCalc. I suppose one could code a REXX (or some other language) to create a [...]
View Answer
| May 11, 2010 2:17 PM
CSV, mainframes
I am not aware of a mainframe product to build a CSV file. After all, from where would one build such a file? Its not as if you are running EXCEL on the mainframe. Well, we did use to have VisiCalc. I suppose one could code a REXX (or some other language) to create a [...]
View Answer
| May 11, 2010 2:17 PM
CSV, mainframes
embedding sql to rpgle
This is actually more of a math function. Get 2 fields defined as date format. From date is Jan 1st of the year desired. Thru date is your target (maybe today’s date ?) $TDATE Subdur $FDATE $DDIFF:*W I think it allows *W for Weeks. If not, use *D for Days then divide by 7 to [...]
View Answer
| May 11, 2010 1:20 AM
AS/400, Embedded SQL, RPGLE, SQL Server
This is actually more of a math function. Get 2 fields defined as date format. From date is Jan 1st of the year desired. Thru date is your target (maybe today’s date ?) $TDATE Subdur $FDATE $DDIFF:*W I think it allows *W for Weeks. If not, use *D for Days then divide by 7 to [...]
View Answer
| May 11, 2010 1:20 AM
AS/400, Embedded SQL, RPGLE, SQL Server
Create a querry to select certain records from a Acess Table
You should create one table for the JOBS, one for the TASKS and one for the JOB-TASK relations. Here’s a simplified example: <pre>JOBS job_no job_name 1 JOB ONE 2 JOB TWO TASKS task_no task_name 1 TASK ONE 2 TASK TWO 3 TASK THREE … JOB_TASK job_no task_no 1 1 1 2 1 4 1 9 [...]
View Answer
| May 10, 2010 8:46 PM
Microsoft Access
You should create one table for the JOBS, one for the TASKS and one for the JOB-TASK relations. Here’s a simplified example: <pre>JOBS job_no job_name 1 JOB ONE 2 JOB TWO TASKS task_no task_name 1 TASK ONE 2 TASK TWO 3 TASK THREE … JOB_TASK job_no task_no 1 1 1 2 1 4 1 9 [...]
View Answer
| May 10, 2010 8:46 PM
Microsoft Access
Access Calculations
Check the “Control Source” for the field. Make sure it points to the database.
View Answer
| May 10, 2010 4:47 PM
Microsoft Access
Check the “Control Source” for the field. Make sure it points to the database.
View Answer
| May 10, 2010 4:47 PM
Microsoft Access
find min/max date in access which also return their value for each record
Assuming that a unique index or pk exists on (id,date), a SQL query like this should work (but someone else might want to offer a more efficient way to do it): <pre>SELECT t1.id, t1.mindate, t2.score, t1.maxdate, t3.score FROM (SELECT id, MIN(date) mindate, MAX(date) maxdate FROM YourTable GROUP BY id) t1 JOIN (SELECT id,date,score FROM YourTable) [...]
View Answer
| May 10, 2010 4:15 PM
Microsoft Access
Assuming that a unique index or pk exists on (id,date), a SQL query like this should work (but someone else might want to offer a more efficient way to do it): <pre>SELECT t1.id, t1.mindate, t2.score, t1.maxdate, t3.score FROM (SELECT id, MIN(date) mindate, MAX(date) maxdate FROM YourTable GROUP BY id) t1 JOIN (SELECT id,date,score FROM YourTable) [...]
View Answer
| May 10, 2010 4:15 PM
Microsoft Access
Need to know equipment needed to setup a simple network to share DB
Hi there, In order to create a small network that will allow 12 computers to communicate you be glad to know you actually need very little equipment. You have 2 directions you can go in though so first thing is you have to make decision!! I will give you some options for both though so [...]
View Answer
| May 6, 2010 11:41 AM
Database connectivity, Network design, Network equipment, network setup, routers and switches
Hi there, In order to create a small network that will allow 12 computers to communicate you be glad to know you actually need very little equipment. You have 2 directions you can go in though so first thing is you have to make decision!! I will give you some options for both though so [...]
View Answer
| May 6, 2010 11:41 AM
Database connectivity, Network design, Network equipment, network setup, routers and switches
