MS Access query to show records that contain dates that differ by 1 year
I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a [...]

Answer Question   |  April 8, 2010  2:04 AM
Access, DATEDIFF, Microsoft Access 2003, Microsoft Access query, Query

MS Access Datasheet sorting using Runtime
In Access 2000 runtime is it possible to enable some quick an easy sorting on a DataSheet view in a subform?  I am currently using a ComboBox to achive this, but it would be more intuitive for the users to just be able to click on the column heading like one would do in Windows [...]

Answer Question   |  April 2, 2010  6:23 PM
Access Datasheet, ComboBox, Microsoft Access 2003, RunTime

leading zeros on numeric
In RPG how can I have a numeric field that keeps leading zeros?

Answer Question   |  April 2, 2010  12:58 PM
leading Zero, Numeric, RPG

ADO Connection to MaxDb
Using VBA (Excel 2007) I am trying to connect to MaxDb using the following connection string sapconn.Open “DRIVER={MaxDB};” _ & “SERVER=sapdevsrv_DEV_00;” _ & “DATABASE=200;” _ & “UID=AMJAD_PBL;” _ & “PWD= ;” But it’s generating an error saying [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified For your convenience the system [...]

Answer Question   |  March 31, 2010  1:15 PM
ADO Connection, VBA, VBA: ADO Connection to MaxDB

When is Test Strategy document prepared?
When is Test Strategy document prepared? Is it prepared before or after test plan? How is it different from Test Plan ? What are contains of Test Strategy Document?

Answer Question   |  December 29, 2010  6:55 AM
Software testing, Test Strategy

DR/HA questions with SQL Server design
Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring [...]

Answer Question   |  March 31, 2010  10:16 PM
SQL Server, SQL Server availability, SQL Server backup and restore

MySQLi and PHP problem with code
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]

Answer Question   |  April 9, 2010  10:02 PM
Concatenate, Database, MySQL, PHP, table

How to create a (visual) window baseclass without xaml
Hi, I want to create a window baseclass that contains 3 elements: - a ribbon control (ie devcomponents wpf ribbon) - a region to contain child form controls - a statusbar This way, all windows that inherit from this window will automatically provide these controls (and soms functions). I created a lookless windowbase.cs file that [...]

Answer Question   |  March 30, 2010  9:08 PM
baseform, C#, child, code behind, Inheritance, Template, visual, window, wpf

call php script from CL – slow
Hello, i try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH        CMD(&CMD) i try to send an email in the php script and i was wondering why it takes about 5-8 seconds to send the mail. So i tried to find out where the script is slow. [...]

Answer Question   |  March 31, 2010  12:45 PM
CL, i5, PHP, Qshell

Substring Query SQL
Hi All, I’m trying to build a query to join names in one table to abbreviated names in another table. So for example I have – Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the [...]

Answer Question   |  March 30, 2010  12:44 AM
SQL, SQL Server query optimization

Assembly injection/hook c#
I’m trying to inject/hook (or whatever method is the best) into a .net assembly exe. My objective is to extend the CollectionChanged event of all listviews. I’ve tried to use reflector to find some info on the assembly but it is obfuscatored and I’m not very skilled reading il code : ) So any help [...]

Answer Question   |  March 30, 2010  10:00 PM
.NET, C#

Ajax based multiserver GUI for MySQL?
I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

Answer Question   |  March 30, 2010  7:32 PM
Ajax, MySQL, MySQL admin

XPPRT1.dll threading
Running an app called LiquorPOS which uses this dll and, after malware infestation, has lost its threading. Is anyone familiar with this software? The error is ‘not found’, though 3 instances occur on the machine in the system mgr, application, and credit card directories. The system manager does open, just not the app — wondering [...]

Answer Question   |  April 5, 2010  1:26 AM
Alaska software, FoxPro, LiquorPOS, MerchantPOS

Creation of array for input of data
Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ‘;’. There would be a maximum number of 10 entries [...]

Answer Question   |  March 29, 2010  1:08 AM
Array, LOOP statement, Update records, VBA

HOW TO CONNECT VS2005 TO SQL2005
Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005    

Answer Question   |  March 29, 2010  3:59 AM
SQL, SQL Server 2005, Visual Studio 2005

connecting flash 8 project into visual c++ application
I am writing this application is visual c++ which i want to encluprate flash movie into it, how do i do that please.

Answer Question   |  March 29, 2010  2:31 PM
C++, MSVT, SWF

passing array as parameter to stored procedure in mysql
how to passing array as parameter to stored procedure in mysql?

Answer Question   |  April 9, 2010  6:53 AM
MySQL, MySQL Query Browser

LISTBOX
I load list box with file data of 5 elements(k2,k2,k3,k4,k5) with up to 10000 results I get the sum of these elements to be some integer(3,6,7,8,9,11) I write a code to eliminate some results like this If (k1+k2+k3+k4+k5) <> 3 or (k1+k2+k3+k4+k5) <> 6 or If (k1+k2+k3+k4+k5) <> 7 or (k1+k2+k3+k4+k5) <> 8 or If (k1+k2+k3+k4+k5) <> 9 or (k1+k2+k3+k4+k5) <> 11  then listbox.add(k1 ” ;” [...]

Answer Question   |  March 29, 2010  12:40 AM
VB.NET, VB.NET 2005, VB.NET 2008

LISTBOX
I get some data into listbox from base through SQL The number of data ranges from 8 to 15(b1,b2,b3,b4,b5,b6,b7,b8,……b15) which gives up to 1000 results. If it 8 data(b1,b2,b3,b4,b5,b6,b7,b8) I want to have only results where  sum of any 7 data of 8 or 7 data of( 9,10,,,,,15) data are some integer (25,26,35,39,41 etc) In one word I want to add data to listbox only [...]

Answer Question   |  March 27, 2010  12:17 AM
VB, VB.NET, VB.NET 2005, VB.NET 2008

Sql Server 2005 ensure columns sum within a table
how can i ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

Answer Question   |  March 29, 2010  11:47 PM
SQL, SQL Server 2005