OK... quickly.. I know what the problem is... However, I don't know how to work around it... I'm working on an advanced search query... And I'm trying to create one query, instead of calling...
I'm trying to determine the best way to run a parameterized query using Pervasive.Data.SqlClient.DLL v2.10.1.2
The code below is working, but the question mark style of sending parameters d...
In MS Access, is converting from string to number and vice versa, possible in a Join itself? For instance, joining two tables on a column which is formatted as text in one table, number in a...
Im using MYSQL 5.0 and was wondering if it was possible to connect to multiple databases using one query. like below. The databases are on the same server but godaddy(host) forces the userna...
I am trying run a query on an MSSQL database to list some details of some cars that are stored in a table called cars. But I only want to list cars that have their state currently set to eithe...
Experts,
I have been working with mwvisa1 at this related question:
http://www.experts-exchange.com/Q_24692237.html#a25215161
I am now having a problem with the Username signed in to ma...
When you export tables or a whole database from the phpmyadmin, the file has all the commands like create table, insert, etc.
Is there a software program to automatically save a csv with th...
I am trying to duplicate the Employee forms and Table in a Project Management Database from Access and i cant seem to get everything to connect right. I want to be able to create a list of Con...
I have an interesting situation. Please do not laugh but are company is still using MAS90 for our "sudo" ERP system. Well we also utilize TM1 (IBM Cognos) for our budgeting tasks. We recent...
I got a function In Excel named Days360. I same function I need to apply in VB 6 also.
Any body can replay how can I apply.
Experts,
I have a couple of old client databases that I need to merge into one.
Each contains 2 bits of information that I need to extract, the first is the order number and the second...
Hi,
I have a MS SQL table with the column:
ExpireTime time(7) hhmmss
I need a query that will select everything from the table where ExpireTime is less than the current time.
Help on an Oracle query please.....
This is just an example, the actual tables are very different but the principle is the same.
Two Oracle tables, jobs and progress.
Columns:
jobs: jobn...
i need to create a java (spring/hibernate) program, where persistent data are stored on a database i.e. mysql.
The problem is as follows. i need that while the application is on the compute...
I want to prevent duplicated enty in my table.
for example
1 john mayer
2 john mayer jonh@mayer.com
3 adem smith
4 adem smith
5 sara ...
I am having a hard time remembering how to save my Dataset to a SQL Database once I am done making all my changes. The app as most do, loads the database into the dataset at startup, but I ca...
Trying to convert .accdb table to SQL 2005. Standard table. Nothing fancy. I'm not too familiar with SSMA so it could be something I'm doing. I'm using the wizard that starts when you open SSM...
hey,
i add and delete records from a data base via a web portal, the issue i have is that when i add the records i want them to be inserted at the bottom but it doesn't happen all the time a...
Can you give me a good book for beginners that teaches how to use TOAD for oracle/sql?
I heard that TOAD is very common and most likely most companies have it. Is there a special version of T...
A customer upgraded to acess 2007 and now the report querry will not run
I tracked it down to it not liking the date range #mm/dd/yyyy# also tried yyyy-mm-dd but acess converts it back to the...
I want to know how to attach a MS SQL 2005 Database to MS SQL 2003 Server.
Hi,
is there any means to be able to query from two (2) lotus notes databases. i have a live & an archive where depending on a search criteria, i'd want to be able to query on both databas...
What is the logic to know when to break a SQL Server data file into a Filegroup with many sub-files, for better performance in Windows Server 2003? At what point, does performance deteriorate,...
I am trying to setup a Login form in a Visual Basic Windows application. I have two roles, an Admin Role and Technician Role. The Admin Role will be 1 and Technician Role will be 0. I have ...
I have a few update statement those are not working when I am in IIS, but working fine in development server.
Any help will be greately appreciated,. Thanks in advance.
