Search Result

fiaworkz · Jan 23 '12, 03:55 AM

I've been working for this for more than an hour
Hope someone helps me.
Here's my code

Code:

Try

            Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\LBHdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
            con.Open()
            cmd.Connection = con

...

Cleo Millet · Oct 4 '11, 10:59 PM

I'm still fairly new to MySQL and I've been given a task by my lecturer that I just can't make work. She wants us to use SET to add a row to a table instead of the regular VALUE method. Here's my code and the error I received:

Code:

mysql> INSERT INTO Instructors
-> SET FacId = 96
-> SET FirstName = 'Chris'
-> SET LastName = 'Explorer'
-> SET HomePhone = '555-1492';

ERROR 1064 (42000):

...

Niheel · Sep 10 '11, 11:17 PM

One of my applications collects a lot of data and is outputting it to a group of analysts that view it in all sorts of ways. To speed up things we've been using a lot of indexes on our main tables.

At some point, i wonder what kind of problems we can run into with all these indexes we've created.

What's the a good number of indexes for tables with over 10 million rows? Do the number of indexes have an impact on queries...

Bob Zander · Aug 21 '11, 03:47 AM

What if I have a large data set and want to insert more than 1 row at time? Is there a way to do it with the INSERT query? or do I have to use another QUERY?

Omar Awan · Jul 7 '11, 02:12 PM

I have an unbound control "CC_Security_1_ TextBox" that gets its data from a crosstab query tied to the form. What i need is code that would update the table "CC Security" which has two columns: User and CC Security Rule when someone changes the data on the form.

I'm using an AfterUpdate event that i haven't completed, but can't find a related topic on bytes to help me finish it, so i thought i'd ask. ...

Steve Carr · May 26 '11, 09:59 AM

I have added a bookmark to a Word template and successfully added a table to the document.

However, I now want to add another table below the one I have just created.

I used this code to locate the bookmark

Code:

Range oWordRange = _oDocument.Bookmarks.get_Item(ref oBookMark).Range;

I thought that I could move the range down a line by using this code.

Code:

_oWordRange.InsertParagraph();

...

Kat Choi · Feb 9 '11, 01:39 PM

create sequence A

insert into T1(a,b) values(nextval for A, "data");
insert into T2(a,b) values(prevval for A, "data);

I am running a multiple threads java application.

The first field of table T1 and T2 should be the same if nobody issue a NEXTVAL for A in between.

My question is how can I ensure nobody(other threads, or other DB2 user) can issue a 'nextval for A'...

Daniel Halvorse · Jan 22 '11, 11:19 PM

hi I am working on an application that manages the data in a access database. but i cant seem to get past this error.

When i try to run it it says:
"Syntax error in INSERT INTO statement" syntax error, I have made all the fields in database TEXT(255) so it cant be that.

any help regarding this will be much appreciated, i am new to datasets and would love any help or guides i can get on the matter....

matt sheeyd · Jan 11 '11, 05:13 AM

Hey,
I need to insert a an item from my drop down into MySQL. However at the moment i am getting all the values and i need to know if theres a way to submit the values individually.

Code:

<?php 
$sql="SELECT name, no FROM test";
 echo "<select name=\"name\">";  
 echo "<option size=75>name | no</option>"; 
  if ($result=mysql_query($sql)) {

...

Eduard Satn · Jan 5 '11, 03:29 PM

i have an acces database an i want to insert a new record from a textbox.

My acces database has 2 fields :
Cod_criteriu - autoincrement;
denumire - text;

the folowing code comes from a form in which i have a text box and a buton from which i want to insert.

private void button1_Click(o bject sender, EventArgs e)
{
this.categoriiT ableAdapter.Ins ertQuery(textBo x1.Text);...

Wayne L · Jul 23 '10, 03:40 PM

I have a table with Field1, Field2
Field Two may have 2 or more duplicate values. I want to insert a 0 (zero) in field one in a new row after the duplicate values in field 2.

11111
11111
0
22222
22222
22222
0

ORB30 · Jul 13 '10, 11:42 AM

Hello all

Im having an issue trying to insert a variable in to a database.
This variable is the math result of 3 fields of the form, a division multiplied by a number.

So far is returning always 0 so i thought you might gime me a hand here

This is the cold below :

Code:

// declare variables to be inserted
$venzini_kinisis_1 = ($_REQUEST['15']/$_REQUEST['8']) * $_REQUEST['1'];

...

NDayave · Jun 8 '10, 01:31 PM

How do,

I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.

What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.

I am aware of the problems of inserting blank records to tables. I say this as the other forums I have searched all reply with disbelief...

fbartolom · Mar 23 '10, 03:24 PM

Hullo,

I have a quite simple piece of code that returns a syntax error in the query execution: Have you got any idea about what might be wrong?

Code:

         public void SQLCommandWithParam(string name, byte[] image)
            {
            OleDbCommand sqlCommand1 = new OleDbCommand();
            System.Data.OleDb.OleDbConnection myOleConnection = new System.Data.OleDb.OleDbConnection();

...

TheSmileyCoder · Mar 13 '10, 07:36 PM

I need to update a record in a table if the record allready exists, but if it does not exist, I need to insert the record.

Is there a 1-step SQL way of doing this?

I can easily perform the 2 step approach, of using a dLookup to determine if it exists, and based on that do either the Insert or Update, I'm just trying to work smarter, not harder :P

Other Info: Access 2003, Split frontend/Backend, both Access....

Search Result

VB.net MS SQL inserts but NOT Updating

How to use SET to Update a Pre-exiting Table

Right amount of indexes to use on a big table?

How do you insert more than one row at a time?

Need Unbound Textbox fed from crosstab query to insert/delete table data

Inserting a table in Word after another table

How to keep the newly generated sequence value unchanged for insert?

How to fix "Syntax error in INSERT INTO statement" using OLEDB?

How to insert one item from PHP drop down?

Someone can help me with insert sequence in c#?

Table insert question

How to insert a variable in a database which is calculated by 3 form fields

Inserting blank records to query result for label printing

Syntax error in OLEDB Insert statement with parameters

Update if Record exist, otherwise Insert