Can we use TRIM in WRKQRY?
Yes, you use the VARCHAR function when defining your field <pre>VARCHAR(x9jbno)||’/'||VARCHAR(x9jbus)||’/'||VARCHAR(x9jbnm) </pre>
View Answer
| March 26, 2009 3:19 PM
TRIM function, Work with Query, WRKQRY
Yes, you use the VARCHAR function when defining your field <pre>VARCHAR(x9jbno)||’/'||VARCHAR(x9jbus)||’/'||VARCHAR(x9jbnm) </pre>
View Answer
| March 26, 2009 3:19 PM
TRIM function, Work with Query, WRKQRY
UNC alternative
Put all of the files under the same folder structure and use relative pathnames. Otherwise, using the servername in the UNC is the best way. The server could have a different IP address at a point in time if hardware fails and another server provisioned in its place.
View Answer
| March 26, 2009 3:15 PM
Excel macros, Excel worksheets, Microsoft Excel, UNC, UNC path
Put all of the files under the same folder structure and use relative pathnames. Otherwise, using the servername in the UNC is the best way. The server could have a different IP address at a point in time if hardware fails and another server provisioned in its place.
View Answer
| March 26, 2009 3:15 PM
Excel macros, Excel worksheets, Microsoft Excel, UNC, UNC path
Eclipse not running on Windows Vista
What error messages are you getting ? Please provide more information about your environment, the version of Eclipse you are using, and the specific problems you are having.
View Answer
| March 26, 2009 1:29 PM
Eclipse, Vista compatibility, Windows Vista
What error messages are you getting ? Please provide more information about your environment, the version of Eclipse you are using, and the specific problems you are having.
View Answer
| March 26, 2009 1:29 PM
Eclipse, Vista compatibility, Windows Vista
OnChange Filter to first Value Request
The reason there is an “Any” option in the first place is probably trigger the onchange event needed by the other dropdowns. What I would do is get rid of the “Any” option so that the select box has only a single option that is already selected to your country, and then move the onchange [...]
View Answer
| March 25, 2009 7:56 PM
JavaScript, onChange Event, PHP, Web development
The reason there is an “Any” option in the first place is probably trigger the onchange event needed by the other dropdowns. What I would do is get rid of the “Any” option so that the select box has only a single option that is already selected to your country, and then move the onchange [...]
View Answer
| March 25, 2009 7:56 PM
JavaScript, onChange Event, PHP, Web development
Functions in JavaScript
You need to test t1 and pb for null before accessing the value property, e.g. var t1 = document.getElementById(“tot1″); var x; if (t1 != null) { x = t1.value; } The value property always returns a string, so it will never be null, because string objects return empty string but not null.
View Answer
| March 25, 2009 7:47 PM
JavaScript, JavaScript functions, Web development
You need to test t1 and pb for null before accessing the value property, e.g. var t1 = document.getElementById(“tot1″); var x; if (t1 != null) { x = t1.value; } The value property always returns a string, so it will never be null, because string objects return empty string but not null.
View Answer
| March 25, 2009 7:47 PM
JavaScript, JavaScript functions, Web development
update text box using Javascript
Is customerEmail the id of your text box input? If you’re using a form you’re probably using the name attribute and not the id attribute. If your text box is named customerEmail then you should access it as document.[form name].[input name].value = xxx, where input name is customerEmail.
View Answer
| March 25, 2009 7:41 PM
JavaScript, Web development
Is customerEmail the id of your text box input? If you’re using a form you’re probably using the name attribute and not the id attribute. If your text box is named customerEmail then you should access it as document.[form name].[input name].value = xxx, where input name is customerEmail.
View Answer
| March 25, 2009 7:41 PM
JavaScript, Web development
Embedded SQL in an RPG FREE program
Yes – you’ve missed something. Your Select statement needs an Order By clause. You may not need seperate Views — views aren’t, by the way, Logical files. You shouldn’t need to use LF’s at all. The SQL-Query engine will find the best index. You may find your performance needs you to create indexes. Records missing [...]
View Answer
| March 25, 2009 7:23 PM
Embedded SQL, RPGILE, SQL
Yes – you’ve missed something. Your Select statement needs an Order By clause. You may not need seperate Views — views aren’t, by the way, Logical files. You shouldn’t need to use LF’s at all. The SQL-Query engine will find the best index. You may find your performance needs you to create indexes. Records missing [...]
View Answer
| March 25, 2009 7:23 PM
Embedded SQL, RPGILE, SQL
Subtracting two numbers
You will need to provide more information. What database are you using ? What are your table structures ? When you say ‘value(1:30am)’, you mean something like the following ? <pre>SELECT value FROM yourTable WHERE otherColumn = ’1:30′</pre>
View Answer
| March 25, 2009 7:20 PM
SQL, SQL macros, SQL Query
You will need to provide more information. What database are you using ? What are your table structures ? When you say ‘value(1:30am)’, you mean something like the following ? <pre>SELECT value FROM yourTable WHERE otherColumn = ’1:30′</pre>
View Answer
| March 25, 2009 7:20 PM
SQL, SQL macros, SQL Query
Can you force a user input in a SQL statement, then have the statement continue running
It’s probably possible if you give users direct access to the SQL CLI prompt, but that’s a very bad idea. What are you trying to accomplish, specifically? You should always take in input, make sure to sanitize it, and only then incorporate it into the SQL command and run that. <a href=”http://xkcd.com/327/”>xkcd</a> has a humorous [...]
View Answer
| March 25, 2009 3:21 PM
SQL, SQL Server development, SQL statements
It’s probably possible if you give users direct access to the SQL CLI prompt, but that’s a very bad idea. What are you trying to accomplish, specifically? You should always take in input, make sure to sanitize it, and only then incorporate it into the SQL command and run that. <a href=”http://xkcd.com/327/”>xkcd</a> has a humorous [...]
View Answer
| March 25, 2009 3:21 PM
SQL, SQL Server development, SQL statements
Data type in VB.NET
I believe you can do this with a class in VB.Net. I’ve never written it to a file, however, you should be able to do that as well. Simply create a new class and setup properties to contain the data you need to store, then you treat the object (and it’s associated data) as a [...]
View Answer
| March 25, 2009 2:58 PM
DataType, VB 6, VB 6.0, VB.NET
I believe you can do this with a class in VB.Net. I’ve never written it to a file, however, you should be able to do that as well. Simply create a new class and setup properties to contain the data you need to store, then you treat the object (and it’s associated data) as a [...]
View Answer
| March 25, 2009 2:58 PM
DataType, VB 6, VB 6.0, VB.NET
Delete duplicate values in Microsoft Access
delete * from TABLE1 where TABLE1.id in (select tb1.id from TABLE1 as tb1, TABLE1 as tb2 where tb1.columnA=tb2.columnA And tb1.id>tb2.id) this query will do the job, in case each record has an ID i tested it before sending, no matter how many dupplication you have it will delete it ———————————- 1. SELECT distinct * into [...]
View Answer
| March 25, 2009 2:26 PM
Database programming, Delete duplicates, Duplicate records, Microsoft Access
delete * from TABLE1 where TABLE1.id in (select tb1.id from TABLE1 as tb1, TABLE1 as tb2 where tb1.columnA=tb2.columnA And tb1.id>tb2.id) this query will do the job, in case each record has an ID i tested it before sending, no matter how many dupplication you have it will delete it ———————————- 1. SELECT distinct * into [...]
View Answer
| March 25, 2009 2:26 PM
Database programming, Delete duplicates, Duplicate records, Microsoft Access
VB6 handlers Help
You didn’t say whether this code is working or not. Just a couple of comments: - ERROR1, ERROR2, etc… are meaningless, you should replace that messages. - You have all of your code in the Form_Load event, so the program will start and will immediately take and save the picture, and will disconnect the cam, [...]
View Answer
| March 25, 2009 2:01 PM
VB 6, VB 6.0, VB6
You didn’t say whether this code is working or not. Just a couple of comments: - ERROR1, ERROR2, etc… are meaningless, you should replace that messages. - You have all of your code in the Form_Load event, so the program will start and will immediately take and save the picture, and will disconnect the cam, [...]
View Answer
| March 25, 2009 2:01 PM
VB 6, VB 6.0, VB6
SQL – Pass the result of the first query as the second query select column name
You will need dynamic SQL to achieve that. What database are you using ? what version ? In Sql Server, this would be one way to do it: <pre>DECLARE @selectStmt nvarchar(4000), @field nvarchar(100) SELECT @field = CASE WHEN fld_type1 = ‘A’ THEN ‘VAL_ALPHA1′ WHEN fld_type1 = ‘D’ THEN ‘VAL_DATE1′ ELSE ‘VAL_NUM1′ END FROM table1 SET [...]
View Answer
| March 25, 2009 3:06 AM
Dynamic SQL, SELECT statement, SQL
You will need dynamic SQL to achieve that. What database are you using ? what version ? In Sql Server, this would be one way to do it: <pre>DECLARE @selectStmt nvarchar(4000), @field nvarchar(100) SELECT @field = CASE WHEN fld_type1 = ‘A’ THEN ‘VAL_ALPHA1′ WHEN fld_type1 = ‘D’ THEN ‘VAL_DATE1′ ELSE ‘VAL_NUM1′ END FROM table1 SET [...]
View Answer
| March 25, 2009 3:06 AM
Dynamic SQL, SELECT statement, SQL
Difference between delay threat and denial threat
Not really sure what you are referring to here, details would be appreciated. Taking a stab, here is information on <a href=”http://en.wikipedia.org/wiki/Denial-of-service_attack”>Denial-of-Service threats.</a> ————————- Never heard of a delay threat, but a denial of service attack is an attempt to overload a service so that it becomes in accessable to other users. There are several [...]
View Answer
| March 25, 2009 1:39 AM
E-commerce, Security threats, Web security, Web servers, Web site security
Not really sure what you are referring to here, details would be appreciated. Taking a stab, here is information on <a href=”http://en.wikipedia.org/wiki/Denial-of-service_attack”>Denial-of-Service threats.</a> ————————- Never heard of a delay threat, but a denial of service attack is an attempt to overload a service so that it becomes in accessable to other users. There are several [...]
View Answer
| March 25, 2009 1:39 AM
E-commerce, Security threats, Web security, Web servers, Web site security
BroadVision Software License Fees
A sales rep would be the best choice.
View Answer
| March 24, 2009 10:19 PM
BroadVision, BroadVision 8.0
A sales rep would be the best choice.
View Answer
| March 24, 2009 10:19 PM
BroadVision, BroadVision 8.0
SQL Data Types Conversions
Don’t know what your numeric date field looks like 6, 7, 8 digits 20090321 perhaps??? You didn’t say Oracle or SQL/Server or something else. convert(datetime,’20040508′,112) the SQL convert datetime function changes a character string into a date time. The last parameter is the format of the incoming string — 112 is CCYYMMDD. Hope this helps [...]
View Answer
| March 24, 2009 3:55 PM
ERP, iSeries, iSeries Data Transfer, SQL, SQL Data Types
Don’t know what your numeric date field looks like 6, 7, 8 digits 20090321 perhaps??? You didn’t say Oracle or SQL/Server or something else. convert(datetime,’20040508′,112) the SQL convert datetime function changes a character string into a date time. The last parameter is the format of the incoming string — 112 is CCYYMMDD. Hope this helps [...]
View Answer
| March 24, 2009 3:55 PM
ERP, iSeries, iSeries Data Transfer, SQL, SQL Data Types
How to connect my application using Visual Studio 2005 to a SQL Server database?
You need to create a SQLConnection object as well as a SQLDataReader object as well as a SQLCommand object and use them to execute the SQL Statement in the SQLCommand object against the SQLCOnnection object and put the output into the SQLDataReader object. Here are some examples: Visual Basic .NET <pre>Dim cnn As SqlConnection = [...]
View Answer
| March 24, 2009 2:44 PM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005
You need to create a SQLConnection object as well as a SQLDataReader object as well as a SQLCommand object and use them to execute the SQL Statement in the SQLCommand object against the SQLCOnnection object and put the output into the SQLDataReader object. Here are some examples: Visual Basic .NET <pre>Dim cnn As SqlConnection = [...]
View Answer
| March 24, 2009 2:44 PM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005
Excel 2003 Help: How to delete duplicates from specific colums and criteria
How do you do this manually? Because that’s all a macro is. Sounds like: <ol> <li>Add work column (let’s say M) with formula =B2=F2=K2 copied down to end.</li><li>Delete rows where M is TRUE.</li><li>Delete the work column</li> </ol> I’d generally do the deleting by converting the formula to value, replace FALSE with “” (clear the contents). [...]
View Answer
| March 24, 2009 2:50 AM
Excel 2003 macros, Microsoft Excel 2003, Microsoft Excel 2003 macros, VBA, Visual Basic for Applications
How do you do this manually? Because that’s all a macro is. Sounds like: <ol> <li>Add work column (let’s say M) with formula =B2=F2=K2 copied down to end.</li><li>Delete rows where M is TRUE.</li><li>Delete the work column</li> </ol> I’d generally do the deleting by converting the formula to value, replace FALSE with “” (clear the contents). [...]
View Answer
| March 24, 2009 2:50 AM
Excel 2003 macros, Microsoft Excel 2003, Microsoft Excel 2003 macros, VBA, Visual Basic for Applications
How do I install Java on gOS?
gOS is an ubuntu based linux operating system. This <a href=”http://onubuntu.blogspot.com/2006/09/java-runtime-on-ubuntu.html”>link</a> will help you with the installation. There are others in the Ubuntu forums.
View Answer
| March 23, 2009 10:45 PM
good OS, gOS, Java, Ubuntu Linux
gOS is an ubuntu based linux operating system. This <a href=”http://onubuntu.blogspot.com/2006/09/java-runtime-on-ubuntu.html”>link</a> will help you with the installation. There are others in the Ubuntu forums.
View Answer
| March 23, 2009 10:45 PM
good OS, gOS, Java, Ubuntu Linux
Tables, queries, and database with Visual Basic 6
1) <b>Usually</b>, you add tables to your database at design time, not at runtime from the application. You can read and insert/update data into the database with SQL. 2) Are you using Access ? what version ? are you getting some error when trying to navigate the records ?
View Answer
| March 23, 2009 1:50 PM
Database connectivity, VB 6, Visual Basic, Visual Basic 6
1) <b>Usually</b>, you add tables to your database at design time, not at runtime from the application. You can read and insert/update data into the database with SQL. 2) Are you using Access ? what version ? are you getting some error when trying to navigate the records ?
View Answer
| March 23, 2009 1:50 PM
Database connectivity, VB 6, Visual Basic, Visual Basic 6
