Search Results

Search found 20359 results on 815 pages for 'fixed length record'.

Page 80/815 | < Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >

• How to delete part of a MySQL database record?

  - by John

  I want to delete part of a record. For example, a column called "message" contains the following string: "Hi, My name is John" I want to delete just "John" from the above while retaining the "Hi, My name is" part in tact. How can this be done?

  Read the article

• Is Extended permission in Facebook need to be record by developer?

  - by Teerasej

  Hi, everyone I am developing a Flash-based application for Facebook. I read many comment that the application need to pop-up dialog for user to decide to extend their permission. The question is, who will record those decision? Facebook or the developer? because it might be a problem if user is asking the court for their privacy.

  Read the article

• Crystal Reports API - chart: "for all records" or "for each record"?

  - by Epaga

  Is there any way to determine whether a chart in Crystal Reports 2008 (using either the RAS SDK or the older RDC API) is set to display values "for each record" or "for all records"? I can get access to a CrystalDecisions.ReportAppServer.ReportDefModel.ChartObject but can't find any API there to access which type of chart it is - "for each" or "for all".

  Read the article

• How do I get 5 records before AND after a record with a specific ID?

  - by richleland

  I have a table named scores with the columns id and score. I want to access a specific record by its id as well as the 5 records before and after it. Is there a way in SQL to say "grab the score with the id of n and x items before and after it?"

  Read the article

• MS Sql Get Top xx Blog Record From Umbraco by parameter...

  - by ccppjava

  Following SQL get what I need: SELECT TOP (50) [nodeId] FROM [dbo].[cmsContentXml] WHERE [xml] like '%creatorID="29"%' AND [xml] like '%nodeType="1086"%' ORDER BY [nodeId] DESC I need to pass in the numbers as parameters, so I have follows: exec sp_executesql N'SELECT TOP (@max) [nodeId] FROM [dbo].[cmsContentXml] WHERE [xml] like ''%creatorID="@creatorID"%'' AND [xml] like ''%nodeType="@nodeType"%'' ORDER BY [nodeId] DESC',N'@max int,@creatorID int,@nodeType int',@max=50,@creatorID=29,@nodeType=1086 which however, returns no record, any idea?

  Read the article

• how to update a selectecd record in a dataset an update a onother datatable in another Adoconecion

  - by ml

  I have 2 adoconections and 2 datatables in each conecion (Local Table1_master Table1_Detail) (Network Table1_master Table1_Detail) i show thwm in a DBgrid and now i wouth like to update the (Local Table1_master Table1_Detail) from the tables in (Network Table1_master Table1_Detail) how can i upddate the selected record´s .!!! i try many ways but normaly it insert more recordes and don´t update record i use a .MDB database

  Read the article

• how to update a selected record in a dataset and update another datatable in another Adoconnection?

  - by ml

  I have 2 adoconnections and 2 datatables in each connection (Local Table1_master Table1_Detail) (Network Table1_master Table1_Detail). I show them in a DBgrid and now I would like to update the (Local Table1_master Table1_Detail) from the tables in (Network Table1_master Table1_Detail). How can I update the selected records? I have tried many ways but normally it inserts more records and doesn´t update the record. I use a .MDB database.

  Read the article

• how is this dropdown working ? on selection it displays another record.

  - by ida

  this website here: http://www.offpricecars.com/inventory2.html?F=C when you select a dropdown the record based on your selection is displayed. ive tried copying it to localhost and it wont work. ive also tryed reading its headers and cant seem to figure out how javascript is making the records display on selection. i do understand that its extension isnt really html and might be another but based on how its operating as a html file i cant seem to find anywhere on how its sending the string to show the records. thanks

  Read the article

• What's the best way for storing record's ID on web page while editing in ASP.NET MVC ?

  - by user137348

  While a record is edited,how should be the ID stored ? I could have a textbox with enabled false, but I don't like this approach. In ASP.NET I used to have a property which has saved the value in viewstate(Actually a hidden field + encrypted value). The only solution I found Is to use a hidden field. Is it save enough ? Are there any others options ?

  Read the article

• How to record sound from a microphone in VB6?

  - by Clay Nichols

  We've been recording sound for over a decade using what seems like a very clunky method using the Winmm.dll and the MCIsendString. I've read that this doesn't set the recording quality value correctly (not sure if that article was ever true or is still true). I was wondering if there is any better way to record sound.

  Read the article

• When using skip and take to page data, how can I get the total record count without a separate query

  - by Keith Myers

  I don't see how this is possible, but I really, really hate to run my query an extra time just to get the record count so I can build a pager. When I say a "pager" I simply mean the common gizmo with a link for each 10 records for example.

  Read the article

• ACCESS/VBA: How to create a ON/OFF type switch to allow record modification on a form ?

  - by Christian M

  I was using a combobox on my search form to select whether to consult or modify a record. To make it more user friendly (IMO), I put a togglebutton on a form, which controls the .AllowEdits property of my form. This way you can easily switch from reading to writing. However I run into a problem; once .AllowEdits is switched to false, the togglebutton is not clickable anymore ! What are my options ?

  Read the article

• How to delete specific record from Google Datastore (in Java) ?

  - by Srivigneshwar

  I have some records in datastore, I want to delete a specific record from the table. for example in SQL , we use delete * from table1 where name ="mike" what is the equivalent code in java (I m using Eclipse with Google appengine API plugin)? or any other method to do that?

  Read the article

• How to insert a SQLite record with a datetime set to 'now' in Android application?

  - by droidguy

  Say, we have a table created as: create table notes (_id integer primary key autoincrement, created_date date) To insert a record, I'd use ContentValues initialValues = new ContentValues(); initialValues.put("date_created", ""); long rowId = mDb.insert(DATABASE_TABLE, null, initialValues); But how to set the date_created column to "now"? To make it clear, the initialValues.put("date_created", "datetime('now')"); Is not the right solution. It just sets the column to "datetime('now')" text.

  Read the article

• Given a 1TB data set on disk with around 1KB per data record, how can I find duplicates using 512MB

  - by user288609

  There is 1TB data on a disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinite disk space?

  Read the article

• What is the best way to determine if table already has record with specific ID?

  - by iburlakov

  Hello. I have a short question. Im my current project I'm using LINQ-to-SQl. That is the best way to determine if table has record with specific ID? Thanks in advance.

  Read the article

• 1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinit

  - by user288609

  1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinite disk space?

  Read the article

• Can I get a collection of versions for versionable Doctrine record?

  - by jjbohn

  So I'm trying to find a way to get a collection of all versions of a versionable Doctrine Record. Is this possible? I could definitely build something that would do it but I wasn't sure if the functionality was already built in. Thanks in advance, John

  Read the article

• What is the correct SQL for a trigger to copy a record to an identical table?

  - by Owen

  I have two tables TABLE1 and TABLE2 with identical structures. I need a trigger to copy a record after insert from TABLE1 to TABLE2. What's the proper SQL for this?

  Read the article

• There is 1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM an

  - by user288609

  There is 1TB data on a disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinite disk space?

  Read the article

• How to count each record in each table in a SQL Server 2005 Database?

  - by Heather

  I need to know how many records are in each table in a particular database. I don't care what is in the record, they will all need to be counted. I already know how to do this for a single table as SELECT Count(1) FROM [my_table_name], but this gets a little redundant for 200+ tables.

  Read the article

• How to reduce time for taken by stored Procedure for inserting a single record?

  - by padmavathi

  We wrote a stored procedure for selecting a single record from DB at a time. Using the same stored procedure to read 2000 records it takes 4 seconds. Is there any way to optimize it? (like single stored procedure for 2000 records) Thanks & Regards Padma

  Read the article

• How to record Audio and Video at the same time into flv in Adobe air 2.0 ?

  - by Ole Jak

  How to record Audio and Video at the same time into flv in Adobe air 2.0 ? So that Video and Audio will be sinchronised? Open Source libs and Blog aricales are wellcomed!)

  Read the article

• How can I record who borrowed what for our office library?

  - by lrussell

  I am looking for suggestions for a very simple book borrowing system for our office library. For example, should we use an Excel spreadsheet, some email based system, build something ourselves, or is there a web application for this? It just needs to record the title and name of the borrower at a minimum.

  Read the article

• How can I record the audio output of the iPhone? (like sounds of my app)

  - by Flocked

  I want to record the sound of my iPhone-App. So like someone is playing something on a iPhone instrument and after that you can hear it. Is it possible without the micro?

  Read the article

< Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >