Click here to Skip to main content
15,906,567 members
Home / Discussions / Database
   

Database

 
AnswerRe: copy data from existing table to existing table Pin
Ennis Ray Lynch, Jr.19-Jul-06 9:41
Ennis Ray Lynch, Jr.19-Jul-06 9:41 
Questioncopy data from table to table Pin
md_refay19-Jul-06 9:06
md_refay19-Jul-06 9:06 
AnswerRe: copy data from table to table Pin
Ennis Ray Lynch, Jr.19-Jul-06 9:07
Ennis Ray Lynch, Jr.19-Jul-06 9:07 
QuestionNull reference exception when trying to use DataAdapter Update Pin
webbsk19-Jul-06 8:56
webbsk19-Jul-06 8:56 
AnswerRe: Null reference exception when trying to use DataAdapter Update Pin
Rabbit1726-Jul-06 3:53
Rabbit1726-Jul-06 3:53 
QuestionMicrosoft Access mdb files (OleDb) Pin
RaduCiumag19-Jul-06 4:27
RaduCiumag19-Jul-06 4:27 
AnswerRe: Microsoft Access mdb files (OleDb) Pin
Rob Graham19-Jul-06 5:12
Rob Graham19-Jul-06 5:12 
GeneralRe: Microsoft Access mdb files (OleDb) Pin
RaduCiumag19-Jul-06 8:26
RaduCiumag19-Jul-06 8:26 
I'm using the next sequence of SQL:

CREATE TABLE Table_1 ( ID char(50) PRIMARY KEY);

After the creation of the table i'm using a for cycle to add as many columns in the table as necesary. (max. 200)
The query run in the for cycle is: ALTER TABLE Table_1 ADD column_i char(50); - where "i" is the counter

I get the following error when i add more then 40 columns:
System.Data.OleDb.OleDbException: Record is too large.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
GeneralRe: Microsoft Access mdb files (OleDb) Pin
Rob Graham19-Jul-06 10:05
Rob Graham19-Jul-06 10:05 
GeneralRe: Microsoft Access mdb files (OleDb) Pin
RaduCiumag19-Jul-06 19:04
RaduCiumag19-Jul-06 19:04 
NewsBatch scripting for MS Access / Excel databases Pin
imhogan18-Jul-06 23:31
imhogan18-Jul-06 23:31 
QuestionSelect statment Pin
Amarni18-Jul-06 21:14
Amarni18-Jul-06 21:14 
AnswerRe: Select statment Pin
Colin Angus Mackay18-Jul-06 22:18
Colin Angus Mackay18-Jul-06 22:18 
GeneralRe: Select statment Pin
Amarni18-Jul-06 22:56
Amarni18-Jul-06 22:56 
GeneralRe: Select statment Pin
Subramaniam s.V.18-Jul-06 23:42
Subramaniam s.V.18-Jul-06 23:42 
GeneralRe: Select statment Pin
Paddy Boyd19-Jul-06 1:00
Paddy Boyd19-Jul-06 1:00 
QuestionUnable to Configure SQL MAIL Pin
k_bhawna18-Jul-06 20:45
k_bhawna18-Jul-06 20:45 
AnswerRe: Unable to Configure SQL MAIL Pin
Eric Dahlvang19-Jul-06 3:38
Eric Dahlvang19-Jul-06 3:38 
Questionupdate a dataBase Table with a dataSet Table [modified] Pin
cosmindp18-Jul-06 7:23
cosmindp18-Jul-06 7:23 
AnswerRe: update a dataBase Table with a dataSet Table Pin
Not Active18-Jul-06 8:39
mentorNot Active18-Jul-06 8:39 
GeneralRe: update a dataBase Table with a dataSet Table Pin
cosmindp18-Jul-06 8:46
cosmindp18-Jul-06 8:46 
QuestionDataGrids counter Pin
hamidreza_buddy18-Jul-06 6:55
hamidreza_buddy18-Jul-06 6:55 
AnswerRe: DataGrids counter Pin
Paul Conrad18-Jul-06 11:20
professionalPaul Conrad18-Jul-06 11:20 
QuestionBulk insertion of data in sql server Pin
montu337718-Jul-06 5:32
montu337718-Jul-06 5:32 
AnswerRe: Bulk insertion of data in sql server Pin
sampathkumarg19-Jul-06 8:31
sampathkumarg19-Jul-06 8:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.