• MS Access 2002 Excessive Growth

    I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower which I...

    Rbrucejones60 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • Query in SQL400

    Hi, I want one query in SQL400, I will give small example? Suppose there are two tables,    TAb1                Tab2 1.CMP                 1.CMP 2.Item NO           2. Item NO 3.Status              3.Warehouse 4.Quantity          ...

    ssssssssssssssss115 pointsBadges:
  • Difficult SQL query, is this possible?

    Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth -------------------------------------- That's the end of the second table....

    David Phillips35 pointsBadges:
  • error in grid xml: each dimension must be used once and only once

    Hello, I've got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can't get data. It shows #NAZEV? instead numbers and popups Error window 'Hyperion Smartview for Office' with message "Error in grid...

    KAZAN5 pointsBadges:
  • Getting same text output on .NET (Windows 7) as in .NET CF (Windows CE)

    Dear all, I currently working on an application which reproduces screen outputs of an embedded device (running Windows CE) on a Windows 7 .NET application. On the mobile device a .NET CF application is running. It has a normal GUI. It also contains many texts. My job is to create a .NET application...

    BitEater5 pointsBadges:
  • Database connectivity from Oracle Forms

    We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

    Ms123115 pointsBadges:
  • Error during run time

    Dear experts, I am developing a website in ASP.NET using C# and I am facing the following error :  Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies...

    Biggner10 pointsBadges:
  • AS400 SNDDST with Dynamic from address

    kindly anyone please tell me, how to change dynamic FROM email address in the SNDDST command.I have task to change the from address in the SNDDST based on parameter user sent.I checked in the internet with option to configure TCP using WRKDIRE.But i want the dynamic from address for the particular...

    hamsinee130 pointsBadges:
  • Microsoft Visual Basic error

    I was using a floor plan sent to me by an architect, and after I opened it I started getting a notice every time I opened any other drawing, either mine or an architect's. I get this warning box that says: !Microsoft Visual Basic Object library invalid of contains references to object definitions...

    Waynepew15 pointsBadges:
  • End-user awareness education for company newsletter

    I have been given the task of developing user awareness 1-pager fact sheets to be distributed on a monthly basis in our company newsletter and posted on our intranet. I can write these from scratch but was hoping not to have to reinvent the wheel. Help?

    CalendarGirl0 pointsBadges:
  • sql query

    any one explain this query: select regexp_substr(char_name,'[^,]+',1,level)as row_id from char_change connect by level<=(select length(replace(char_name,',',null)) from char_change); this query is used to get the string value and print the row wise.

    Gowriking65 pointsBadges:
  • How to Upload Image into SQL Server 2005

    Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.

    BrownAsakpa20 pointsBadges:
  • Avoid Dulpicacy while entering Data in SQL db using VB6 as front end

    Iam beginner in Vb & SQL. I am entering data like MemberName(txtMemberName.text) in sql database through VB6 front end form. I can enter same data in this field. Can any body help me in avoiding the duplicacy of the data. Following is my code on Save button :- Private Sub btnSave_Click() If...

    ITAdministrator5 pointsBadges:
  • Order by clause in SQL Server subqueries

    why the "order by" clause in sub queries must be associated with "top" clause in sql server..??

    Karthikharve5 pointsBadges:
  • How to print selected data in VB 6 Data Report

    we were about to create a system that generate eport such as daily weekly monthly and annual... and we dont know how to do it.. plz.. help us..

    It3ckat5 pointsBadges:
  • condition based color changing of labels

    Imports System.Data.OleDb Imports System.Data Imports System.Threading Imports System.Data.SqlClient Public Class Form1     Dim bm As BindingManagerBase     Dim ds As New DataSet     Dim adp As OleDb.OleDbDataAdapter     Sub showrecord(ByVal pos As Integer)         Button1.Text =...

    Mahaveer5 pointsBadges:
  • Code Impact Analysis Tool

    Hi, Need a tool to do the impact analysis of .net/java/com code files and should produce the matched code/classes/objects/methods/references etc. for a particular database hit (stored-procedure or select/insert/update query)

    Kvrao5 pointsBadges:
  • Colored CL Source

    How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?

    Farmboy6920 pointsBadges:
  • Animated gif problem in VB.net?

    In the application I'm developing I need to present the user with a splash screen. In that splash screen I used an animated spinning wheel gif image to let the user know that he/she has to wait. But when I insert the gif and run the application the splash screen displays but the gif only...

    Obhasha0795 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following