Search Results

Search found 32757 results on 1311 pages for 'database cursor'.

Page 134/1311 | < Previous Page | 130 131 132 133 134 135 136 137 138 139 140 141  | Next Page >

• How do I update a cumulative field in a Rails database (using ActiveRecord or Mongoid)?

  - by picardo

  I want to update a field in a database table that has to have a cumulative value. So basically I need to find the current value of the field and update it using a new number. My first inefficient try at this (in Mongoid) is: v = Landlord.where(:name=>"Lorem") v.update_attributes(:violations=>v.violations + 10) Is there a simple method than making one query to read, then sum up, and another query to write?

  Read the article

• How to design database tables (MySQL) for multiple users ?

  - by Hisyam

  i would like to know the best way to design database tables for multiple users, like any website that requires a user log in before they can start posting anything. Should my code create individual tables for every users or something different?

  Read the article

• Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performa

  - by Templar

  Our software must be able to run on SQL Server 2000 and 2005. To simplify development, we're running our SQL Server 2005 databases in compatibility level 80. However, database performance seems slower on SQL 2005 than on SQL 2000 in some cases (we have not confirmed this using benchmarks yet). Would upgrading the compatibility level to 90 improve performance on the SQL 2005 servers?

  Read the article

• Add database add-in in Monodevelop 2.2.2 on Windows ?

  - by user301089

  I have the problem I just installed the new Monodevelop 2.2.2 on Windows but I haven't the database add-in and I cannot add-in with the basic repository. Are-there other repository for that ? Thanks with advance. Narglix

  Read the article

• Fluent Nhibernate napping to existing database with primary key in joining table of a many to many r

  - by Todd

  I have an existing database with a many to many relationship however the joining table has a primary key ID and 2 foreign keys to do the join. Is it possible to configure the mapping files to handle this? at the moment i am stuck. Thanks

  Read the article

• Where to find an SQL database for medical information?

  - by iamrohitbanga

  Where can I find sample data of medical information? Data on medicines, diseases, etc. and preferably in a format easy to import into an SQL database.

  Read the article

• How to prevent updating duplicate rows in SQLite Database?

  - by CSharperWithJava

  I'm inserting new rows into a SQLite table, but I don't want to insert duplicate rows. I also don't want to specify every column in the database if possible. I don't even know if this is possible. I should be able to take my values and create a new row with them, but if they duplicate another row they should either overwrite the existing row or do nothing.

  Read the article

• Make a final call to the Database when user leaves website (ASPX)?

  - by Jisaak

  I have a system set up to lock certain content in a database table so only one user can edit that content at a time. Easy enough and that part is working fine. But now I'm at a road block of how to send a request to "unlock" the content. I have the stored procedure to unlock the content, but how/where would I call it when the user just closes their browser?

  Read the article

• How can I frequently/automatically compare the structure of the same Database?

  - by Pitming

  Does anyone know a tool that automatically compares the structure of a database and gives a report of what was changed? If it can be integrated into a CruiseControl, even better. By structure I also mean functions and stored procedures. Which is probably not clear at first sight ;-) The idea was to integrate that into a cruise control server

  Read the article

• How to use C# to parse a glossary into database?

  - by Yaaqov

  This should be a simple one, but I'm a beginner with C#. Given a glossary list in the following format: aptitude ability, skill, gift, talent aqueous watery arguably maybe, perhaps, possibly, could be How can I parse this, and insert into a database table in the format: TABLE: Term_Glossary ================================================ Term_Name | Term_Definition | ================================================ aptitude | ability, skill, gift, talent | ------------------------------------------------ aqueous | watery | ------------------------------------------------ arguably | maybe, perhaps, possibly, could be| ================================================ Any help would be appreciated - thanks.

  Read the article

• VS2010 Database Compare. How do you create a *.DBSchema extensioned file?

  - by George

  I'd like to take a snapshot of my database, make some changes and then use the db compare functionality to identify the changes, and who knows, maybe even generate scripts to make the change. I'd like to avoid having to backup the current db and restore it as a separate db just to have a "before" snapshot. I'm guessing I shouldn't have to. Obsviously, I'm clueless about db projects and am looking to be pointed in the right direction. ty!

  Read the article

• How to use Triggers for Logging History of database change in MySQL?

  - by Parth

  How to use Triggers for Logging History of database change in MySQL? If yes, then is it possible to create a sepearte db for trigger tables for tracking history of other Db tables??

  Read the article

• How to convert rows of a database query to a XML file?

  - by EASI

  I am developing a Delphi application that needs to pick up the rows from a period of work and convert them to a single XML file in order to upload to a 3rd party web-service. Is there any component or library available to do that? If not, what is the best approach of code to build that DB2XML conversor? I noticed that most XML questions are about how to convert it to another type of data. Note: the database will be MySQL or Firebird.

  Read the article

• Is there a "best" or more popular database for standalone Java app?

  - by Tom Brito

  Is there a "best" or more popular database for standalone Java app? I'm currently writing by hand, but I would like to know what is commonly done, if there is something that is commonly done.

  Read the article

• Do you know a database written in Perl with DBI interface?

  - by Aftershock

  Hi, Do you know a database written in Perl with DBI interface? Or what can be used if there is no MySql or Postgresql installed? Thank you.

  Read the article

• How do I remove the first 8 characters from a Microsoft Access database field?

  - by Gavin O'Brien

  Hi, I've got an Access '07 database that imports data from text files. The problem is one of the fields that is taken in comes with a date value before a place value that I don't need. For example, the field comes in like so: 01012010DUBLIN whereas I need it to just display DUBLIN. I'm stumped on this and any help would be greatly appreciated Thanks.

  Read the article

• With database table design, Is there an advantage of using special naming convention for a Many-to-m

  - by Jian Lin

  Whenever there is a many-to-many relationship, I think there will be immediately a many-to-many table needed (also called a junction table). Is there any advantage of using special naming convention for these tables, as opposed to the other 1 to many tables? Or are there popular special naming conventions used by companies designing database tables?

  Read the article

• How can I create a model in Powerdesigner which can generate create script for different database?

  - by MemoryLeak

  I just want to create the model once, and then use it in any kind of database, without the need to modify the model. What I should do with the data type ? I found there is numeric and other kind of data types. What does that correspond to in mysql or access ?

  Read the article

• IOC are at the class level, but what about database conflicts?

  - by mrblah

  With IOC I understand you can substitue implementations out by merely editing a configuration file etc. BUT, what happens when the classes are married to particular database tables and sprocs, you can't just swap out an implementation since the classes/entities are tied to particular tables and stored procedures. Am I right here?

  Read the article

• How do you store a trie in a relational database?

  - by blank

  I have a prefix trie. What is the recommended schema for representing this structure in a relational database? I need substring matching to remain efficient.

  Read the article

• How do you find out which database links are used in queries for the Oracle RDBMS?

  - by JavaRocky

  I would like to find out if any and which database links are being used, for a schema, and in which tables. Is it possible via the data dictionary somehow? Is this possible with the Oracle RDBMS?

  Read the article

• How to monitor the change of the database so as to flush the treeview?

  - by jack

  target: whenever the table in the database changes, the treeview will reload the new contents of the table. Is there any good methods to solve this problem? thank u

  Read the article

• What's the quickest way to dump & load a MySQL InnoDB database using mysqldump?

  - by Josh Schwartzman

  I would like to create a copy of a database with approximately 40 InnoDB tables and around 1.5GB of data with mysqldump and MySQL 5.1. What are the best parameters (ie: --single-transaction) that will result in the quickest dump and load of the data? As well, when loading the data into the second DB, is it quicker to: 1) pipe the results directly to the second MySQL server instance and use the --compress option or 2) load it from a text file (ie: mysql < my_sql_dump.sql)

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• Java: Storing information from database. What collections are appropriate?

  - by garvy

  I write an application in Java. I get form a database a table (clients) which contains fields like: name | surname | adress What is the best solution to store this data in my app? Should I create an object for each client and store these objects in a list or set? The table contains about 100 records and it's already sorted. Thanks in advance.

  Read the article

< Previous Page | 130 131 132 133 134 135 136 137 138 139 140 141  | Next Page >