Oracle RR Date Format
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)

Answer Question   |  August 9, 2011  8:43 AM
Oracle 9i, Oracle RR date format, SQL

Application with VSFlexGrid1 in VB6
Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = “select * from _ Location where ItemNo” If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset, adLockOptimistic if MyItem.Recordcount [...]

Answer Question   |  May 27, 2009  8:35 AM
VB6, Visual Basic 6, VSFlexGrid

Purpose of creating SQL Server stored procedures at run time
Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it’s effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

Answer Question   |  June 3, 2009  7:33 AM
RunTime, SQL Server 2000, SQL Server development, SQL Server stored procedures

Thread culture
Hi there I am new in programming, I was wondering if you kindly help me please what is Thread culture in the software? and what is doing?, picture shows Thread culture in the software more appreciated Thank you in advance

Answer Question   |  May 27, 2009  7:10 AM
Localization, Software development, Thread culture

adding url’s to the links toolbar in IE via script
daily I have to add a couple of url’s to the links toolbar for every new computer that comes into our office. it’s simple to drag and drop manually but time consuming and tedious. does anyone know how I can have this done automatically with a simple batch file or vbs script?

Answer Question   |  May 29, 2009  6:55 PM
Batch files, Internet Explorer, VBScript

Workflows and Properties
We would like to use SharePoint workflow for reviewing and approving our invoices. However, we would like to add a budget field in this process so that the approver can add the budget at the workflow level and then approve as opposed to going into the Edit Properties screen. But we’d also like this data [...]

Answer Question   |  March 26, 2013  5:36 PM
SharePoint, SharePoint Workflow, Workflow

Database Issues – Trying to prove that something has to be done
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]

Answer Question   |  September 20, 2010  2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables

SQL update a column to remove a certain character
I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the ‘*’ is preventing me from doing this. So how do I update or alter the table so that I [...]

Answer Question   |  April 19, 2013  1:41 PM
SQL, SQL tables

test director 8.0 installation error
Iam new to software field just finished st course I try to install test director 8.0 on windows server 2003 enterprise edition set goes up to login details page when i select next it displays unknown user name or bad pass word can any body help me get out of this problem thanks in advance [...]

Answer Question   |  May 26, 2009  1:38 PM
Test Director, Test Director 8.0, Test Director Installation, Testing software, Windows Server 2003, Windows Server 2003 Enterprise Edition

Netgear DG834 fails to block sites using HTTPS
Using a netgear dg834 we have set a block for www.facebook.com this works fine if the users attempts to contact through HTTP but if they do an HTTPS access then this bypass’s the filter and allows them access. Any help would be greatly appreciated.

Answer Question   |  May 26, 2009  11:31 AM
HTTPS, NetGear blocking, Netgear DG834, Network security, Router configuration, User restrictions

Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]

Answer Question   |  May 26, 2009  10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors

Crystal Reports database
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]

Answer Question   |  October 28, 2011  8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming

J2ME mobile application development
Can some other Programing language be used For Development of Mobile Application ?

Answer Question   |  May 26, 2009  6:23 AM
J2ME, Mobile development

SQL error
DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,’ALL’,A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND A.SCHEME=DECODE(:INPSCHEME,’ALL’,A.SCHEME,:INPSCHEME) AND A.ACCOUNTNO=DECODE(:INPACCOUNTNO,’ALL’,A.ACCOUNTNO,:INPACCOUNTNO) AND T.BANK=A.BANK AND T.BRANCH=A.BRANCH AND T.MODULE=A.MODULE AND T.SCHEME=A.SCHEME AND T.ACCOUNTNO=A.ACCOUNTNO AND T.ACCOUNTISN=A.ACCOUNTISN) loop while c1.NEXTDUEDATE<=c1.REVIEWDATE c1.NEXTDUEDATE:=add_months(c1.NEXTDUEDATE,1) dbms_output.put_line(c1.BANK||’ ‘||c1.BRANCH||’ ‘||c1.MODULE||’ ‘||c1.SCHEME||’ ‘||c1.ACCOUNTNO||’ ‘||c1.ACCOUNTISN||’ ‘||c1.NEXTDUEDATE||’ ‘||c1.REVIEWDATE); end loop; END; ORA-06550: line 16, column 1: PLS-00103: [...]

Answer Question   |  May 28, 2009  5:49 AM
ORA-06550, Oracle error messages, SQL

XML Sitemap URLs
I created an xml sitemap and in order for it to be valid, I had to replace the ampersands in my url’s (&) with an escpape entry like @amp; Google now excepts it, but if I click on that URL it doesn’t work Doe it ulitmately show the url to search engine users in the [...]

Answer Question   |  May 26, 2009  3:14 AM
Web development, XML and XML schema, XML Sitemap

Dymo Printer programmatically with VB.NET
For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as [...]

Answer Question   |  May 26, 2009  12:52 PM
D1L, DymoPrinter, LWL, Microsoft Access 2007, VB.NET, Visual Studio 2005

Java on AS/400
Hi All,I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.

Answer Question   |  June 3, 2009  11:01 AM
ERP, i5, Java, M3 ERP, OS/400

Delphi application freezing on search
We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

Answer Question   |  May 26, 2009  9:56 AM
Delphi 5.0, Oracle development, TAdvStringGrid

Visual Basic How to pass current record in a form to a Word template with VSTO?
How can I pass a current rocord in a Visual Basic 2005 form to a Word template using VSTO. Database is in Access.

Answer Question   |  May 26, 2009  9:35 AM
Visual Basic, Visual Studio 2005, Visual Studio Tools for Office

how to return entire table records using mysql database functions
how to return entire table records using mysql database functions

Answer Question   |  June 24, 2012  5:14 AM
MySQL functions