Search Results

Search found 17140 results on 686 pages for 'records management'.

Page 374/686 | < Previous Page | 370 371 372 373 374 375 376 377 378 379 380 381  | Next Page >

• clearing an entire column in access

  - by I__

  is there a way to clear an entire column in a datasheet in access? i can just right click on it and delete it but that will affect the structure, i just need to clear all the records. how do i do this? perhaps the question i should be asking is how do i clear the entire contents of a datasheet in access?

  Read the article

• Hibernate's version values in Grails app

  - by xain

  I'm looking at a database dump file, and I see many records in various tables with their version number set in values other than 0 (even 94 in one case). I understand it has to do with hibernate locking strategy, but my concern is that today is Sunday, and the site has almost no visitors so is: is this normal ? Or is there a known hibernate bug or even some programming malpractice producing this ?

  Read the article

• reclaim unsued space in sql 2008

  - by opensas

  I have a table with more than 300.000 records, that weights approximately 1.5 GB In that table I have three varchar(5000) fields, the rest are small fields I issue an update, setting those three fields to '' An after a shrink (database and files) the database uses almost the same space as before... DBCC SHRINKDATABASE(N'DataBase' ) DBCC SHRINKFILE (N'DataBase' , 1757) DBCC SHRINKFILE (N'DataBase_log' , 344) any idea?

  Read the article

• Setting Rails Checkbox from Another Model

  - by Kevin

  I have a checkbox that belongs to "Foo" class. I have another "Preferences" class that sets the default for what that checkbox should be. I tried using f.check_box :email_preference, :value => preferences.email_preference but it doesn't work. I use this page to do new record creation as well as edit, so obviously for new records I would want to take the preferences.email_preference setting as a default, then for editing the record use the foo.email_preference. Any suggestions?

  Read the article

• Delete all data for a kind in Google App Engine

  - by yogurtearl

  I would like to wipe out all data for a specific kind in Google App Engine. What is the best way to do this? I wrote a delete script (hack), but since there is so much data is timeout's out after a few hundred records.

  Read the article

• Multiple values in a column

  - by Adnan

  Hi I need some advice regarding multiple records. I have a table with fields username,*message* and message_to. the scenario could be of sending same message to multiple users in a go. What do you suggest? will it be efficient to save all recipients in a single column with comma separated values or I add multiple entries ? Thanks /A

  Read the article

• how does sql count work?

  - by ria

  I would like to understand how exactly does sql count work. Is it a whole table scan that happens or is it some property of the table that is read. However I feel a table scan would be an overhead in case of huge tables with lots of records.

  Read the article

• How many objects can LINQ used to create per second ?

  - by MemoryLeak

  I used Linq to insert objects into database.But if i used threads to simultanously create 20 object within 1 second, then system will fail to add 20 objects into database. And I found it is not because of the sql server 's limit. so the only possible is Linq, any one have idea ? How can I create 20 records or more in 1 second within 1 second ?

  Read the article

• Return dataset in dataflow

  - by praveen

  Hi All, Could I get ideas on retrieving the dataset using lookup method. Basically, my scenario as I have source data needs to lookup for other source table and on matching column from source I need to get all the records from other source data. its a one to many relations. I tried Lookup but gives only one record on matching condition, OLE DB command don't retrieve any data as it will do only Insert/Update operations. Thanks prav

  Read the article

• MySQL Query For Copying Contents Into Another Field, Same Row

  - by Rob Adler

  Is there a single query (subqueries in it are allowed) where I can copy the content of one field into another field, per row. Example: price, and priceBackup Records: 45.55 47.77 45.55 copies into priceBackup for that specific row, 47.77 copies into priceBackup for that specific row. I do have a primary key, auto increment on it under 'id'. Thanks guys!

  Read the article

• Displaying Longitude and Latitude values stored in a SQLite db as a Route on a MapView in Android (N

  - by LordSnoutimus

  I am currently in the process of creating an application that records current location of a mobile device in intervals, displaying the route as a coloured line on the device in real-time. At the same time the application is storing the longitude and latitude in a SQLite database as I want the user to be able to bring up that specific route again. The route has a primary key and each waypoint is linked to that route by a foreign key. What would be the easiest way to display the saved route on the map?.

  Read the article

• Most suitable collection for multithreading requests?

  - by Raj Aththanayake

  I have ~10,000 records would like to keep in a collection in memory and execute LINQ queries against it. This collection should be available for all the users in the application domain and can access concurrently. I’m looking for a .NET collection that supports multithreading can query asynchronously and efficiently without any threading issues. Any suggestions on deciding a collection for this?

  Read the article

• How to access map value when its key contains a dot in JSTL ?

  - by Manuel

  Hi, when my Map contains key with dot in their name I cannot access the corresponding value directly with the usual code: ${recordForm.map['records.key']} Is there a way to escape the dot? Or do I have to resort to loop through all values and check against the key? (I know the iteration works). Thanks!

  Read the article

• Gestion del vencimiento de listas y documentos en sharePoint

  - by vizcaynot

  Hello: Can I do the following with SharePoint 2007: 1) Create lists (records) and document libraries with content that is in force for a certain amount of days and after that, they automatically expire? How? 2) When searching for words in a SharePoint site where there are lists and documents, SharePoint displays results similar to Google, would it be possible that Sharepoint tell me what documents are no longer current? How? Thank you very much.

  Read the article

• A single button should be used in all the forms.

  - by mugamath

  i need to use a single button for all forms in a vb.net project. The single button should be called in the forms to perform operations. For eg., In a form i need to save, update the records. When i call the button, save and update buttons should be appeared at runtime using the single button. guide me....

  Read the article

• what is the difference between plugin and library?

  - by fayer

  i wonder what the difference between a library and a plugin is? if a component creates a database (maybe comes with a .sql file or creates through a method) could it still be a library or is it called a plugin or module? cause i am creating a address book component and it provides methods to insert and read records in database. i don't know if i should put it in library folder or plugin folder. please shed a light on this. thanks

  Read the article

• How to select a random record from a MySQL database?

  - by Bruce

  I am using the following query to select 1 random record - SELECT name FROM table WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM table ) ORDER BY id LIMIT 1 but it gives me the same set of records every time I call it. How do I get better random record?

  Read the article

• Chain of Responsibility Pattern: is it a good practice to have interdependent handlers?

  - by wei

  I have this scenario: I have a chain of query handlers, the first is to query the cache, if the cache can't answer it or the answer is stale, then hit a database, if it can't find the answer or the answer is stale again, then query a remote web service. But I am not sure if this is the right way to use this pattern, since the work flow is pretty much fixed, and the cache and database handlers depend on the next step's return result to refresh its records.

  Read the article

• SQL select from data in query where this data is not already in the database?

  - by Michael

  I want to check my database for records that I already have recorded before making a webservice call. Here is what I imagine the query to look like, I just can't seem to figure out the syntax. SELECT FROM (1,2,3,4) WHERE id NOT IN table.id Is there a way to do this? What is a query like this called?

  Read the article

• cakephp: how to make NOW() work in search condition ?

  - by kaklon

  I'm trying to get all records with date greater then now. I tried this but it doeasnt work: $all_dates = $this->TourDate->find('all', array('conditions' => array('TourDate.date >=' => 'NOW()'), 'order' => array('TourDate.date ASC'))); If I replace NOW() with the current date it works. Why's that?

  Read the article

• MongoDB equivalent of SQL "OR"

  - by Matt

  So, MongoDB defaults to "AND" when finding records. For example: db.users.find({age: {'$gte': 30}, {'$lte': 40}}); The above query finds users = 30 AND <= 40 years old. How would I find users <= 30 OR = 40 years old?

  Read the article

• where can I get these kind of exercises to solve?

  - by flash

  Recently I did a Java programming exercise successfully which was sent by a recruiting firm, The problem statement goes like this 'There are two text files FI(records abt files and directory information) and FS(containing blocks of data) which represent a file Index and file System respectively and I was supposed to write a static read method in a class which will read the file from the FS depending upon the path string provided using FI' My question is where can I get these kind of exercises to solve, the complexity should be above average to tough.

  Read the article

• Python: Comparing specific columns in two csv files

  - by coder999

  Say that I have two CSV files (file1 and file2) with contents as shown below: file1: fred,43,Male,"23,45",blue,"1, bedrock avenue" file2: fred,39,Male,"23,45",blue,"1, bedrock avenue" I would like to compare these two CSV records to see if columns 0,2,3,4, and 5 are the same. I don't care about column 1. What's the most pythonic way of doing this? EDIT: Some example code would be appreciated.

  Read the article

• SQL server partitioning

  - by durilai

  I have a table that has millions of records and we are looking at implementing table partitioning. Looking at it we have a foreign key "GroupID" that we would like to partition on. Is this possible? The Group will have more entries added to it, so as new GroupID's are added can the partition's be made dynamically?

  Read the article

• How I can Optimize this mySQL transaction within java code?

  - by worldpython

  Dear All, I am new to MySql database. I've large table(ID,...). I select ID frequently with java code and.And that make a heavy load on transaction select from tableName where ID=someID notes: 1.Database could be 100,000 records 2.I can't cache result 3.ID is a primary key 4.I try to optimize time needed to return result from query. Any ideas for optimization ? thanks in advance

  Read the article

< Previous Page | 370 371 372 373 374 375 376 377 378 379 380 381  | Next Page >