VB6: Dear sir, For the following code I am getting “Run-time error’3265′: Item cannot be found in the collection corresponding to the request name or ordinal.” However, I already connected Adodc1 to my database from where I want the data. Actually, what Im trying to do is, just to get record list from particular field [...]
Answer Question | April 15, 2009 7:50 AM
ComboBox, Microsoft Access, VB 6, VB error handling, Visual Basic 6, Visual Basic runtime errors
In a data mart only architecture what will the development team(s) encounter?
Answer Question | April 13, 2009 8:14 AM
Data management, Data marts, Database architectures, Development
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]
Answer Question | April 22, 2009 2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
Answer Question | April 13, 2009 6:11 PM
MDF, NDF, SQL Server, TempDB
how can i choose the best of the network architecture to implement a large database application in a network environment?
Answer Question | April 12, 2009 1:51 PM
Database, Database approach, Database architectures
how can i design a strategy to run multiple applications on one database to ensure a conflict-free database storage?
Answer Question | April 14, 2009 1:14 PM
Database, Database administration, Database approach, Database archiving, Database Storage
I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 [...]
Answer Question | April 20, 2009 7:35 AM
C+, Embedded SQL, LIKE statement, SQL, SQL/400, SQLRPGLE
My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok [...]
Answer Question | April 12, 2009 7:44 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP
we are connect the database with the help of oledb data adapter.data are updating on screen but data not update in backend.
Answer Question | April 9, 2009 7:26 AM
Database connectivity, Database programming, Object Linking and Embedding, OLE, OLE DB
I have a database and I need the following to calculate based off a date field. My problem is that regardless if the date entered in that field is the beginning, middle, or end of month, I need another field that will produce a due date, which has to be the end of that month, [...]
Answer Question | April 13, 2009 10:27 PM
Access 2003, calculating dates
Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() ‘Sets the Date From and Date To text boxes ‘to Today’s Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today’s date into my From and To Date fields. The problem is I have these From and To [...]
Answer Question | January 2, 2012 6:29 PM
Access 2003, Access Functions, Microsoft Access
Have 2 linked databases, one with name/address/ect, the second with dates service was provided for each address. I would like to query with the result being the address and other data with the date of latest service. I don’t know the function that will result in only the latest date. I can get > greater [...]
Answer Question | April 14, 2009 3:54 PM
I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open [...]
Answer Question | April 14, 2009 6:15 AM
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE
How do I update multiple columns in a table using the BULK COLLECT… FORALL methods in PL/SQL.
Answer Question | April 19, 2013 3:11 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL
Do all versions of Microsoft SQL Server 2005 support database mirroring?
Answer Question | April 8, 2009 5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
I would like to know if there are any databases to view that work. I learn by example much better than trying to type it out and wait for a month for a response. Just wanted to know if there were some sort of repository where one could look through. I need an example of [...]
Answer Question | April 8, 2009 2:03 PM
Database, Functional databases
i am working on a project “criminl records system, i want to add criminals picture in my form,database,which database can used with this VB.NET application.plz specify how can i connect with my form…
Answer Question | April 14, 2009 10:26 AM
Application development, Image databases, Multimedia database, VB.NET, Visual Basic .NET
“I have a business that currently is set up on Access 1997. We have an option that allows staff to email directly off this data base to our customers. However this is only in an HTML format. I would like to change this to a PDF format. So essentially I am looking to change the [...]
Answer Question | April 7, 2009 7:54 AM
Access 1997, Microsoft Access, Microsoft Access 1997
what is rdbms and dbms in oracle?
Answer Question | April 6, 2009 6:51 PM
DBMS, Oracle 9i, RDBMS
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]
Answer Question | April 13, 2009 2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access