Search Results

Search found 7884 results on 316 pages for 'ben record'.

Page 189/316 | < Previous Page | 185 186 187 188 189 190 191 192 193 194 195 196  | Next Page >

• Message reason why Execute method failed

  - by waanders

  I use the DAO method Execute to delete some records. If this fails this is clear by checking RecordsAffected (it will be 0). But is it possible to get the error message (for instance, to log or to show to the user)? I've try to delete the records by hand in the Table grid I get a clear dialog message, e.g. "The record cannot be deleted or changed because tabel x includes related records".

  Read the article

• On Update: Auto Update Date/Time Field

  - by Abs

  Hello all, Is there an equivalent of MySQLs on update field for SQL server? With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated. What I am looking for is to have a date/time field and every time I update a record it updates the field with the date/time it was updated automatically? If it doesn't exist, I guess I'll have to go manual. Thanks all

  Read the article

• get data using junction table with linq-sql confused :$

  - by raklos

  Im using linq-sql .I have 3 tables. e.g Project, People and a ProjectsPeople(fk's ProjectID and PeopleID) (junction) Table. given a set of peopleIDArray (an array of ints as people ID's) how can i get only Projects that have atleast one of the peopleId's associated with them? i.e there will be atleast one (may be more) record in the ProjectsPeople table that will have a ProjectId and an id from the peopleIDArray ) thanks

  Read the article

• What I need to know for writing a Camera Component

  - by Delphawi

  I want to write a component that uses 2 webcams (1 integrated in my laptop , the other is a USB webcam) What do I need to know (or have) to build a component to deal with the cameras (capture , record , movement recognition , and other image and video processing) ? and how ? (with C++ or Delphi) I just need to know the concepts and main techniques , any good resources or source codes would be great :) Thank you .

  Read the article

• How do I sync recorded voice to animation on the iPhone

  - by drfence

  I want to record voice and sync that up with animation on the iphone as a user touches the screen. Are there apis that will help me accomplish this? I've not done anything like this so I"m having a hard time visualizing the type of algorithm that would help me accomplish this.

  Read the article

• Django - count date between

  - by DJPy

  I have many record in my database wich contains datetime field (e.g. 2010-05-23 17:45:57). I want to count all records between e.g. 15:00 and 15:59 (it all can by from other day, month or year). How can I do this?

  Read the article

• Mysql filling in missing dates

  - by bsandrabr

  I have the following query SELECT * FROM attend RIGHT OUTER JOIN noattend ON attend.date = noattend.date2 WHERE attend.date BETWEEN '2010-02-01' AND '2010-04-01' AND attend.customerid =1 ORDER BY date DESC LIMIT 0 , 30 Attend is the table with customerid noattend is the table with a row for each date (date2) I followed the advice in other questions to right outer join it to create values where there is no record in attend but it still isn't filling in the empties any help much appreciated

  Read the article

• Relationship problem?

  - by dilip

  I have four tables Tag=id,tag_name Image=Id,Image_name TagImage=Id,tag_id,Image_id ImageStudent=id,Image_id,student_id And I want to find a record using student id and tag name. What relationship do I use?

  Read the article

• How to assemble a WAV file?

  - by David

  I'm doing an educational project in which 1) I record voice commands on a separate device and after appropriate processing etc... 2) I send 16-bit samples encapsulated in UDP packets over Ethernet to the PC. After receiving the packets and "extracting" data (samples) from them, I need to assemble the samples to a WAV file. Any example code? Any suggestions?

  Read the article

• IS NULL vs = NULL in where clause + MSSQL

  - by Nev_Rahd

  Hello How to check a value IS NULL [or] = @param (where @param is null) Ex: Select column1 from Table1 where column2 IS NULL = works fine If I want to replace comparing value (IS NULL) with @param. How can this be done Select column1 from Table1 where column2 = @param = this works fine until @param got some value in it and if is null never finds a record. How can this achieve?

  Read the article

• Entity Relationships - Can a weak entity take part in a 'one to many' relationship as the 'one'

  - by jonos

  Hi, With the following entity relationship structure I'm struggling to figure out if the relationship between the LOAN and ITEM is valid? The weak entity of Loan uses a partial key of 'loan_dateLeant' and the primary keys from CUSTOMER and ITEM to form its primary key. However LOAN has a 'one to many' relationship with ITEM as a loan can consist of more than one item. But surely this means that if more than one item is loaned, then the loan record will have two item_id values for part of its primary key?

  Read the article

• how to do this in MySql Query??

  - by deep

  ID NAME AMT 1 Name1 1000 2 Name2 500 3 Name3 3000 4 Name1 5000 5 Name2 2000 6 Name1 3000 consider above table as sample. am having a problem in my sql query, Am using like this. Select name,amt from sample where amt between 1000 and 5000 it returns all the values in the table between 1000 and 5000, instead I want to get maximum amount record for each name i.e., 3 name3 3000 4 name1 5000 5 name2 2000

  Read the article

• Marking deleted records in DB tables

  - by Emanuil

  Sometimes you want to mark a DB table record as deleted instead of deleting it permanently, right? How do you do that? So far I've been using a boolean "deleted" field.

  Read the article

• implement multithreading

  - by Neo

  how to to implement multithreading where one thread updating UI and other one is reading the database record in windows application Any guidelines really appreciated...

  Read the article

• SQL Server, View using multiple select statements

  - by phil

  I've banging my head for hours, it seems simple enough, but here goes: I'd like to create a view using multiple select statements that outputs a Single record-set Example: CREATE VIEW dbo.TestDB AS SELECT X AS 'First' FROM The_Table WHERE The_Value = 'y' SELECT X AS 'Second' FROM The_Table WHERE The_Value = 'z' i wanted to output the following recordset: Column_1 | Column_2 'First' 'Second' any help would be greatly appreciated! -Thanks.

  Read the article

• vb.net datadrig view get each cell value

  - by Gbolahan

  hello i'm trying to get the first value of a datagrid cell value but it keeps looping trough and returns the last value. here is the code: Dim cell As DataGridViewCell txtoccupier.Text = "" Try For Each cell In dgvREcord.CurrentRow.Cells() txtoccupier.Text = cell.Value.ToString Next Catch ex As Exception MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Try End Try record eample: id name email 1 test [email protected] it returns only [email protected] but i want to get only the id which is 1 thanks for your help

  Read the article

• How to append to the beginning of a text fle in g++

  - by Phenom

  I want to write to a file without overwriting anything. It is a text file containing records. When I delete a specific record, I do not actually remove it from the file, I just put information in the header saying that it is deleted. How can I do this?

  Read the article

• i m new to sharepoint , where coding take place in sharepoint application as other normar asp.net a

  - by girish

  hello, i m new to sharepoint and bit confuse, i don't understand where coding take place in sharepoint as other asp.net application. how it work if i have to create a page for adding record to database.

  Read the article

• Mysql dynamic query

  - by pradeep

  I have two table in mysql one tbl_a which has one int column id, second tbl_b which has one column song_ids in which data stored seapated by comma like 1,2,3,4 i want to select all id like this select * from tbl_a where id in (select song_id from tbl_b) but its giving me no record as its varchar HOW to do it in mysql

  Read the article

• help with sql-server query - dates

  - by Gold

  hi i have this table: id|date 1 | 10/11/2009 2 | 13/11/2009 1 | 20/12/2009 3 | 21/12/2009 1 | 30/12/2009 if i stand on the last record (id=1) and i need to see the last date where id=1 is appear -- will show me: 1 | 20/12/2009 what query will do it ? thank's in advance

  Read the article

• SSIS - user variable used in derived column transform is not available - in some cases

  - by soo

  Unfortunately I don't have a repro for my issue, but I thought I would try to describe it in case it sounds familiar to someone... I am using SSIS 2005, SP2. My package has a package-scope user variable - let's call it user_var first step in the control flow is an Execute SQL task which runs a stored procedure. All that SP does is insert a record in a SQL table (with an identity column) and then go back and get the max ID value. The Execute SQL task saves this output into user_var the control flow then has a Data Flow Task - it goes and gets some source data, has a derived column which sets a column called run_id to user_var - and saves the data to a SQL destination In most cases (this template is used for many packages, running every day) this all works great. All of the destination records created get set with a correct run_id. However, in some cases, there is a set of the destination data that does not get run_id equal to user_var, but instead gets a value of 0 (0 is the default value for user_var). I have 2 instances where this has happened, but I can't make it happen. In both cases, it was just less that 10,000 records that have run_id = 0. Since SSIS writes data out in 10,000 record blocks, this really makes me think that, for the first set of data written out, user_var was not yet set. Then, after that first block, for the rest of the data, run_id is set to a correct value. But control passed on to my data flow from the Execute SQL task - it would have seemed reasonable to me that it wouldn't go on until the SP has completed and user_var is set. Maybe it just runs the SP, but doesn't wait for it to complete? In both cases where this has happened there seemed to be a few packages hitting the table to get a new user_var at about the same time. And in both cases lots of data was written (40 million rows, 60 million rows) - my thinking is that that means the writes were happening for a while. Sorry to be both long-winded AND vague. A winning combination! Does this sound familiar to anyone? Thanks.

  Read the article

• remove field name from object validation message

  - by Colin G

  I've got a simple active record validation on an object using this within a form: form.error_messages({:message => '', :header_message => ''}) This in turn outputs something like "FieldName My Custom message" What i need to do is remove the field name from the error message but leave my custom message. Can anyone point me in the right direction for this.

  Read the article

• Encoding Video on the iPhone

  - by Dave

  Im trying to record the contents of the iPhone screen to video , in the app I'm working on there able to create a little animation. I'm just not sure how to encode the screen contents/animation to video? The problem with using something like ffmpeg is that its LGPL which can lead to licensing issues, is there a better option?

  Read the article

• WHERE condition accross multiple rows

  - by Chris G

  I have this table... -------------------------------------- | user_id | status | status_date | -------------------------------------- | 1 | Current | 2012-08-01 | | 1 | Referral | 2012-03-14 | | 2 | Referral | 2012-04-23 | | | | | -------------------------------------- How would I query to find a distinct user_id who has a referral date before 2012-06-30 AND either a current date of after 2012-06-30 or no current status record at all? Database is MySQL.

  Read the article

• OpenID and Google hosted domains

  - by John Leidegren

  I get an "The remote name could not be resolved: 'mine.com'" When using this open ID identifier: https://www.google.com/accounts/o8/site-xrds?hd=mine.com And it's true, that the mine.com DNS record doesn't exist. But I'm wondering why it goes to look there in the first place. All I want to be doing is to check if the user can login to our hosted domain. Is that really so hard?

  Read the article

< Previous Page | 185 186 187 188 189 190 191 192 193 194 195 196  | Next Page >