Problems saving data in tables in Visual Basic 2008
What do you mean with “data in tables”? please describe the process and I can help you better greetings

View Answer   |  January 30, 2009  7:57 PM
Database programming, Visual Basic, Visual Basic 2008

Outlook 2003: trim leading spaces from email subject with VBA macro
Looks like this can only be fixed server-side.

View Answer   |  January 30, 2009  9:10 AM
Email, Email management, Macros, Outlook, Outlook 2003, VBA, Visual Basic for Applications

How to add value in the ComboBox from the database at RunTime?
This code is used in a Delphi form fmUserData, and is called on form.show, not create, to ensure data in combo box is up to date The application uses MySQL server for data storage cbucurr is a combo box in form fmUserData // populate the strings list for the cbucurr combobox fmUserData.cbucurr.items.clear; // make sure [...]

View Answer   |  January 30, 2009  4:35 AM
ComboBox, Database programming, RunTime

Monthly Average in Access 2007
Riaan, In Access 2007, try working with the table in Pivot table view. Open the table, go to the Views group, click the arrow and select Pivot table. Then, for example, you could add the Date field to the row field, then add the Data field you want to average to the detail area. You [...]

View Answer   |  January 30, 2009  1:41 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average

SQL Statement to update a table with set conditions on another table
You will want to use something like this. <pre> update Clientextradetails SET ClientExtraDetails.UserDefinedKey1 = ‘bro’ FROM Clients WHERE Clients.ClientRef = ClientExtraDetails.ClientRef AND Clients.ClientType = 70 AND ClientExtraDetails.UserDefinedKey1 is NULL</pre>

View Answer   |  January 29, 2009  7:06 PM
SQL, SQL statements

Adobe 9
To combine multiple PDF documents into one document: 1. Choose Create PDF > From Multiple Files from the File drop-down menu, or click the Create PDF button on the toolbar and choose From Multiple files. 2. In the Create PDF from Multiple Documents dialog box, do any of the following: • Click Browse (Windows) or [...]

View Answer   |  January 29, 2009  2:31 PM
Adobe Acrobat, Adobe Acrobat 9 Pro

Define array in Oracle
The INSTR function should help here. If you know that it will allways be 4 parts in stn, you could use a query like this: <pre>select substr(stn,1,instr(stn,’ ‘,1,1)-1) n1, substr(stn,instr(stn,’ ‘,1,1)+1,instr(stn,’ ‘,1,2)-1-instr(stn,’ ‘,1,1)) n2, substr(stn,instr(stn,’ ‘,1,2)+1,instr(stn,’ ‘,1,3)-1-instr(stn,’ ‘,1,2)) n3, substr(stn,instr(stn,’ ‘,1,3)+1,length(stn)) n4 from YourTable;</pre> If not, you could create a stored function or procedure with [...]

View Answer   |  January 29, 2009  1:58 PM
Arrays, Oracle 8i, Oracle development, SQL, VARCHAR

Delphi and Oracle stored procedures
It seems that you are having this problem since dec-2008 (<a href=”http://itknowledgeexchange.techtarget.com/itanswers/stored-procedure-in-delphi-with-oracle/”>previous question</a>) I think you will need to provide at least the following information in order to get some useful answers: - The stored procedure signature - The delphi code with which you are calling the oracle stored procedure

View Answer   |  January 29, 2009  1:26 PM
Delphi 3, Delphi 5, Delphi error messages, Delphi stored procedures, Oracle stored procedures

Security Testing Types
Ok at a basic level security testing its testing the security of the whole IT system and its data. Im guessing its not a big company or that it needs particually high security else you woudnt be asking here. There is a quick list i can think of; Physical security, lock doors, dont leave laptops, [...]

View Answer   |  January 29, 2009  11:31 AM
Information security, Security, Security testing, Security Testing Type, Testing

Business Value
When you need a new application you have two choices: buy the application or write (possibly hire more programmers) the application. To buy an application you have several considerations. First of all, you need to find the app that most closely matches your needs. Then you need to have the software demoed for you which [...]

View Answer   |  January 29, 2009  7:30 AM
Application development

How to find a specific word in a SQL table
You would have to search for the word with spaces on one side, as well as on other sides. As a second option you could use full text indexing to search for the word bob, but if you are searching for words such as “and” you’ll have to do some additional configuration to be able [...]

View Answer   |  April 18, 2013  4:42 AM
SELECT statement, SQL, SQL Query, WHERE statement

How to create a loop query in SQL.
You will probably need to create a function to achieve that, but the syntax will be different depending on the database. What database are you using ?

View Answer   |  January 28, 2009  11:22 PM
Loop query in SQL, SQL, SQL Query

SQL divisions
I found the solution by myself by simply changing the: <pre>declare @activities as integer declare @days as integer declare @media as float </pre> to <pre>declare @activities as float declare @days as float declare @media as float </pre>

View Answer   |  January 28, 2009  3:46 PM
SQL, SQL Calculations

Using the selectedIndex value in VBscript
This Question was answered on Jan 27 2009 7:26 PM GMT by Ledlincoln. The answer was given on a a VScript code using elements mentioned here. So a very good and simple answer was given thanks to Ledlincoln

View Answer   |  January 28, 2009  6:12 AM
onChange Event, passing an array to a function, SelectedIndex, VBScript, Web development

Help a beginner! What is wrong with this VBScript code?
I’m not a vbScript expert, but here’s one way of doing it: <html> <head> <script language=”vbscript”> sub getIndex(c) msgbox “you selected ” & Colors(c) & ” which means ” & colorIndex(c) end sub </script> </head> <body> <script language=”vbscript”> ‘use base index of zero on arrays Dim ColorIndex(3),Colors(3),i ColorIndex(0)=”Love” ColorIndex(1)=”Jealous” ColorIndex(2)=”Peace” ColorIndex(3)=”Leading” Colors(0)=”red” Colors(1)=”yellow” Colors(2)=”green” Colors(3)=”blue” [...]

View Answer   |  January 27, 2009  7:26 PM
Arrays, VBScript, Web development, Web forms

SQL/400
I’ll give it a shot — so someone can prove how stupid I really am. The users with *SECOFR probably have All Object authority. Normally I would say: if you change the Authority on an object (STRSQL cmd) to exclude specific ID that’s it would exclude use of that object by that user. But with [...]

View Answer   |  January 26, 2009  3:37 PM
*SECOFR, AS/400 security, AS/400 user profiles, SQL/400, Start Structured Query Language, STRSQL

Toggle button
Instead of making two buttons, why not make one button that toggles its state? You can use the current caption to see what state it was in when it was clicked, and take the appropriate actions — including switching the caption. Eg: <pre>Option Explicit Const BTN_CAP_NEW As String = “New” Const BTN_CAP_OLD As String = [...]

View Answer   |  January 26, 2009  3:20 PM
cmdNew_Click event, Software development, Toggle buttons

How to extract the IP address of a data packet and store it in the database?
is the server window, linux sun? If it’s a SUN server just use snoop. Type snoop at the command prompt and it will show you the packets as they pass through the server. Use grep to narrow things down a bit. If it’s a linux box use tcpdump at the command prompt If it’s a [...]

View Answer   |  January 26, 2009  3:17 PM
IP address, Java development, Network monitoring, Network security, packet analysis, Packet analyzers, Packet filtering

Defining a diagonal matrix in VB 6
To be able to redimension an array, you need to use a dynamic array. To define a dynamic array use a Dim, Public, Private, or Static statement with empty parentheses. For example: <pre> Private diagmatrix() as long</pre> This way, you can redimension it as needed with a ReDim statement, for example: <pre>ReDim diagmatrix(numofm, numofm) as [...]

View Answer   |  January 24, 2009  8:38 PM
Diagonal matrix, VB 6, Visual Basic, Visual Basic 6

Restoring a MySQL database
From a command prompt, you can backup your entire database using this line: mysqldump -u user_name -p your_password database_name > File_name.sql Example: Let’s assume that: Username: bobbyjoe Password: happy234 Database Name: BobsData mysqldump -u bobbyjoe -p happy234 BobsData > BobBackup.sql This will backup the database to a file called BobBackup.sql To restore the database CANNOT [...]

View Answer   |  January 23, 2009  2:15 PM
Linux, MySQL, MySQL Restore