Does someone know some good alternative of MS Access database? For personal use, relatively small records quantity, up to 10.000 For example, music collections catalog, etc
Free, compact siz...
Hallo everybody,
I have a problem with the List Item object
in the Oracle forms.
How can I retrieve the selected item(s) from
a list ?
I didn't find any function like 'list.GET_
SELECTE...
I really need some advice on how to go about tackling an entity relationship diagram. I have to design one based on a bookshop and have to show the cardinality and optionality of each relation...
Hi All,
Its silly, but your input is apriciated:
I need to update field 'CallerNumber' where is NULL in database to become 011666666
Please correct the following query:
update dbo.Tabl...
how do i set my archive log dest to USE_DB_RECOVERY_FILE_DEST currently it is set as follows
SQL> archive log list;
Database log mode Archive Mode
Automatic archival ...
We are using Oracle 8.17 and I am trying to load data into a oracle table. Data starts going into the table and then when a commit point reached -logical record count 13077. There should be ...
We are trying to import a large text file (60MB) into an existing table in an Access database. At the end of the import wizard we receive the message "Property not found" and a notice that Ac...
I have a table which looks like this (comma delimited):
"ID","Name","Expertise"
The "Expertise" column contains data that is semi-colon delimited (e.g. Apples;Bananas;Coconuts)
I want...
I need to be able to query the system tables to find all tables containing a specific column name
Something like select * from sysobjects where column_name = 'column_name'
I don't thin...
I am trying to import a comma delimited file (.CSV) into our SQL Server 2005 Database. I am trying to use BULK INSERT. The CSV file is a FEDEX report. It has fields such as "Mon, May 1, 2008"....
I am trying to create a connection from vb 2005 to this "E:\aaPTSQL\PowerToolsSQL.mdf" sql express database. I do not want to use the data environment and I want to retrieve the data using the...
Hi,
I urgently need to calculate the number of business days in a given month. I realise that there are a number of submissions that calculate weekdays etc, but I specifically need to get the...
Hi,
I know that I can make an Identity column in SQL like this:
CREATE TABLE Yaks ( YakID smallint identity(7,2), YakName char(20) )
GO
SET IDENTITY_INSERT Yaks ON
GO
What if you h...
Hello everybody,
I have a backup file for a database and I need to create a database using this one.
I'm using MSDE and osql to manage this.
Logically, I just created a database, and tr...
Hi all,
I have Office 2003 installed on Desktop. When I try to open an access file, which is on the server, I get message "Security Warning: Unsafe expressions are not blocked " but i ca...
I am trying to call a stored procedure from Crystal Reports and I'm passing a parameter. I need the parameter to be a uniqueidentifier datatype, but it is being treated as a varchar. Is there ...
I want to connect to a Informix database through ODBC. Pl. tell me from where I can download Informix ODBC drivers (for Windows XP)
I want to download 'IBM INFORMIX 3.82 32 BIT' driver
Th...
Hi all,
i need help with some sql. I have a table with 200,000 rows of data. one of the columns ref contains non unique values. I'm only interested in these rows if the ref values are not ...
I have a 6GB database with a log file that is now 54GB. Maintenance plans are scheduled to backup the DB and truncate the log files, they appear to be successful according to history. I have...
experts, i'm in need of urgent help
users are getting this error when connecting to the database
ORA-00257: Archiver error. Connect internal only, until freed
there is plenty of room on b...
Hi to all,
I have a question. Can we remove punctuation, spaces and capitalization from the field using DB2 SQL query or not? Actually, I come to the point where I need to compare a field e...
I have three systems 1 Windows 2000 and the other 2 running Linux. The ORACLE server is a LINUX server 192.168.1.220 (MDLITTLE). The other Linux system is a client that boot from a CD that i...
Hi,
While trying to connect to the SQL server , I am getting the following wrror .
Can you please tell me what are the scnarios I will get this error and How can I rectify this error .
...
A stupid consultant we hired has created an incomplete implemetation of a data editing function we wanted added to our program. I must now complete the implementation.
The user must be able...
how can we check for NULL values for fields returned by query on MYSQL database using C-API? Is there macro parallel to NVL?
