Hi,
I'm designing a windows application in visual studio 2008 and connecting to oracle 10g XE but don't know how to add, update and delete records from my database using text boxes.
Thanks in advance
tembil
Last Activity: Sep 23 '09, 06:11 AM
Joined: Feb 13 '08
Location:
-
how to add, update, delete records from oracle10gXE using text boxes in vb.net 2008
-
mysql error: The total number of locks exceeds the lock table size
Hi,
can anyone plz help me, I'm trying to insert data into a table from another table and I'm getting this error:
The total number of locks exceeds the lock table size, how can I fix this.
thanx -
mysql error: The total number of locks exceeds the lock table size
Hi,
can anyone plz help me, I'm trying to insert data into a table from another table and I'm getting this error:
The total number of locks exceeds the lock table size, how can I fix this.
thanx -
I found the problem with the query -
mysql error in query
Hi, will anyone help this statement gives me an error:
SELECT
`tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA`,
COUNT(`Location _Name_IA`), COUNT(`AMC_ID_I A`)
WHERE `tbl_address_ou t_new`.`Locatio n_Name_IA` is not null
GROUP BY `tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA` DESC;
and here's the error :
You have an error in your SQL syntax; check... -
Mysql query: How to ignore errors
Hi,
here's the query that I used I need to know how to ignore errors when executingPlease enclose any code within the proper code tags. See the Posting Guidelines on how to do that.Code:LOAD DATA infile 'myFile12_out.txt' INTO TABLE itc_db.tbl_address_out fields TERMINATED BY '|' lines TERMINATED BY '\r\n' ignore 1 lines;
MODERATOR -
Hi,
here my query:[code=mysql]
select *
from `tbl_telephone`
where LENGTH(`RSA ID`) = 13
and (
substring(`rsa id`, 1, 1) in ('0', '1', '2','3','4','5' ,'6','7','8','9 ')
)[/code]
I need to know if there's another way of doing this
thanx
Please enclose any code within the proper code tags. See the Posting Guidelines on how to do that. MODERATOR...Leave a comment:
-
select on field having specific length and starts numeric
Hi,
How do I select numeric records from a table in MySQL I need to select ID's the length must be 13 and it must be numeric, I have already selected the length in my where clause and I'm stuck with the numeric records.
Thanx in advance -
Hi
I need a text file, here's the code that I used:
[CODE=mysql](SELECT 'Surname', 'Forename 1', 'Forename 2', 'Forename 3', 'DOB', 'RSA ID', 'Other ID', 'Gender', 'Title', 'Marital Status', 'Spouse Name', 'FirstAddressUp dateDate', 'FirstAddressYe arsOfTenure', 'FirstAddressLi ne1', 'FirstAddressLi ne2', 'FirstAddressLi ne3', 'FirstAddressLi ne4', 'FirstAddressPo stCode', 'FirstAddressPr ovCode', 'FirstAddressCo untryCode', 'FirstAddresOTI nd',...Leave a comment:
-
Hi Ronald,
I need a text file that displays all column headings and the data I tried to use a union statement but it doesn't work with bigger files it only works with smaller ones.
Thanx in advance
Tembi...Leave a comment:
-
column headings with export table
Hi,
I'm trying to export data from MySQL to a text file or create a dumpfile and now I want to include column headings as well in my query how can this be done using a big file e.g a file containing more than 8 million records.
Thanx
Tembi
No activity results to display
Leave a comment: