Search Results

Search found 40393 results on 1616 pages for 'single table inheritance'.

Page 299/1616 | < Previous Page | 295 296 297 298 299 300 301 302 303 304 305 306  | Next Page >

• When naming columns in a SQL Server table, are there any names I should avoid using?

  - by Anders

  I remember when I was working with PHP several years back I could blow up my application by naming a MySQL column 'desc' or any other term that was used as an operator. So, in general are there names I should avoid giving my table columns?

  Read the article

• SQL SERVER SSAS: How do I handle a NULL date value in my fact table, so I can process my time dimens

  - by dhz

  Hello! I have a a fact table that has a column with dates loaded from an MS Access source. The thing is, some of the values are NULL and the SSAS won't let me refer my DATE dimension to it. Is it better to solve it at the SSIS stage or is there some solution at the SSAS? Thank you very much for you help.

  Read the article

• How to create a symbol table if given a grammar in a yacc file?

  - by Phenom

  I'm given a yacc file and I'm supposed to create a symbol table. What do I do after I use yacc on the file?

  Read the article

• Doctrine: Unknown table alias. Is this DQL correct?

  - by ropstah

  I'm trying to execute a query but I get an error: Unknown table alias The tables are setup as follows: Template_Spot hasOne Template Template hasMany Template_Spot Template hasMany Location Location hasOne Template I'm trying to execute the following DQL: $locationid = 1; $spots = Doctrine_Query::create() ->select('cts.*, ct.*, uc.*') ->from('Template_Spot cts') ->innerJoin('Template ct') ->innerJoin('Location uc') ->where('uc.locationid = ?', $locationid)->execute(); Does anyone spot a problem?

  Read the article

• What do these .NET auto-generated table adapter commands do? e.g. UPDATE/INSERT followed by a SELECT

  - by RickL

  I'm working with a legacy application which I'm trying to change so that it can work with SQL CE, whilst it was originally written against SQL Server. The problem I am getting now is that when I try to do dataAdapter.Update, SQL CE complains that it is not expecting the SELECT keyword in the command text. I believe this is because SQL CE does not support batch SELECT statements. The auto-generated table adapter command looks like this... this._adapter.InsertCommand.CommandText = @"INSERT INTO [Table] ([Field1], [Field2]) VALUES (@Value1, @Value2); SELECT Field1, Field2 FROM Table WHERE (Field1 = @Value1)"; What is it doing? It looks like it is inserting new records from the datatable into the database, and then reading that record back from the database into the datatable? What's the point of that? Can I just go through the code and remove all these SELECT statements? Or is there an easier way to solve my problem of wanting to use these data adapters with SQL CE? I cannot regenerate these table adapters, as the people who knew how to have long since left.

  Read the article

• Is it possible to get all triggers associated with a table using sql server 2008 clr programming?

  - by Chakkaradeep Chandran

  Hi All, Is it possible to use .net (C# SQL CLR) to find all the triggers associated with a table? And also will I be able to determine the type of that trigger? - CLR or T-SQL? Thanks, Chaks

  Read the article

• Select a random row from table, but with odds?

  - by Don

  I have a table that describes a variety of objects in my system (ie. umbrella, boots, satchel, whatever). Each one of these objects needs to have a distinct prevalence or incidence. For example, the umbrella is rarer than the boots. Based on those factors, I need to randomly select a single object (including a blank or 'no object found') based on that incidence value. Yikes. Make sense?

  Read the article

• Subsonic: How to exclude a table column so that its not included in the generated SQL query

  - by Fleents

  I need to insert a record to a table. Subsonic builds the query something like this (as far as i know): INSERT INTO Table1 (Title, Description, RowVersion) VALUES (@Title, @Description, @RowVersion) But i want to remove the RowVersion column from the SQL query bacause its autogenerated by the sql server. How can i do that?

  Read the article

• What do these C# auto-generated table adapter commands do? e.g. UPDATE/INSERT followed by a SELECT

  - by RickL

  I'm working with a legacy application which I'm trying to change so that it can work with SQL CE, whilst it was originally written against SQL Server. The problem I am getting now is that when I try to do dataAdapter.Update, SQL CE complains that it is not expecting the SELECT keyword in the command text. I believe this is because SQL CE does not support batch SELECT statements. The auto-generated table adapter command looks like this... this._adapter.InsertCommand.CommandText = @"INSERT INTO [Table] ([Field1], [Field2]) VALUES (@Value1, @Value2); SELECT Field1, Field2 FROM Table WHERE (Field1 = @Value1)"; What is it doing? It looks like it is inserting new records from the datatable into the database, and then reading that record back from the database into the datatable? What's the point of that? Can I just go through the code and remove all these SELECT statements? Or is there an easier way to solve my problem of wanting to use these data adapters with SQL CE? I cannot regenerate these table adapters, as the people who knew how to have long since left.

  Read the article

• Can you create a trigger on a field within a table?

  - by chris

  Is it possible to create a trigger on a field within a table being updated? So if I have: TableA Field1 Field2 .... I want to update a certain value when Field1 is changed. In this instance, I want to update Field2 when Field1 is updated, but don't want to have that change cause another trigger invocation, etc...

  Read the article

• How to listen to keyboard events in GWT table?

  - by Olaf Mertens

  In my GWT program I have a table that has a selected row. I'd like to move the row selection with the up- and down-keys on the keyboard. So I have to catch the key events somehow. The GWT docs handle key events in input fields only. But I don't have an input field! Is this possible at all? Maybe it is a DOM/Javascript restriction that GWT cannot work around...

  Read the article

• How to build a complex table by using CSS?

  - by Relax

  Recently i ran into a complex table implementation, for example: tr1: | td1 | td2 | td3 | tr2: | td1 | td2 | tr3: | td1 | td2 | ... As this example shows, i want td1 are fixed with different width, td3 is also width fixed but at the right, td2 are all width auto to expand when screen radio changed. I'm wondering if there is a way to do this by using CSS?

  Read the article

• Can I select a set of Data and directly insert that into a table in SQL?

  - by VJ

  Hi I guess we cannot do this but was just curious if I could do something like - Select * from Employee where EmployeeId=1 and then use the data in the above statement and directly insert into a table with just changing the employeeid...or just this way- insert into Employee ( Select * from Employee where EmployeeId=1) its probably stupid from my side...but I just felt the need to do this a lot of times...so just was curious if there was any way to achieve it..

  Read the article

• Why does compacting a Access 2000 db changes the order of records in a table?

  - by razvan

  As the question says. The table has no primary key defined. Other tables in the database do not change after compacting, and have as well no primary key defined.

  Read the article

• How can I INSERT rows into a new table and update the primary key of the transported items?

  - by ggg

  The new table has an auto-increment that I want to use for the data that I'm transferring. Here is the query I want to run. INSERT INTO `xyz_1mydata` SELECT * FROM `xyz_1production` WHERE `xyz_1production.Id` > '12000'; I don't want to replace the existing items in #_1mydata.

  Read the article

• How do you load data into a Table View when there's both a Tab Bar and a Nav Bar?

  - by editor

  I think I'm way overthinking the issue of having a Tab Bar project type and adding Nav Bar controls. I've followed some basic directions and have a demo app running fine with two tabs, each with a Table View and nav bars. But how do I load data into them? I know I need to hook up delegate and dataSource, but where?

  Read the article

• How do I modify an attribute across all rows in a table?

  - by prgmatic

  Hi folks, My apologies for asking such a novice question but, I need help building a script using either PHP or directly in MySQL that can do the following: Take the values of a column in a table (text) Change them into capitalized words (from "this is a title" to "This Is A Title") Replace the old values (uncapitalized) with the new values (capitalized). Thanks for the help and support.

  Read the article

• How do i select the 1st and then every 4th row in a html-table with nth-child()-selector?

  - by Nils

  Ok, math isn't my strong side, I admit it. All I want to do is to select the first, 5th, 9th, 13th, 17th etc row in a html-table. Can anybody with better math-skills point me in the right directionor perhaps supply a "nth-child-for-dummies" guide? I tried nth-child(1n+4) (which selects the 4th row and everyone after), and i also tried nth-child(0n+4) which selects the fourth row and nothing after that. Thanks in advance.

  Read the article

• Mysql Joins - How to know which row is retrieved from which table...?

  - by SpikETidE

  Hi everyone... Consider i am using join on three tables to get a desired result-set... Now in that result set, is there anyway that i can find out which row comes from which table...?

  Read the article

• How do I replicate a table to all nodes in a DB2 DPF instance?

  - by brianegge

  I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node?

  Read the article

• How can I detect if an iPhone is rotating while being face up in a table?

  - by OscarMk

  Hello, Is there a way to detect if an iphone lying down in a table face up is rotating?. I do realize that this kind of movement is not reported by the accelerometer and neither is it reported to the - (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation method. Is there a way to detect angle variations for the phone rotating this way?. Thank you.

  Read the article

• Is it possible to alter the table in admin interface with SQL?

  - by Eric

  In our projects table we have every version of a project. Is it possible to show only those projects where max(version_id) in the admin interface? Thanks! :) Eric

  Read the article

• IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes?

  - by Matt

  IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• Inability to delete table cells after a certain point.

  - by Sahil Lavingia

  I have built an app which has the ability to delete cells from a table, but only if there are more than two cells. If there are two or less cells, it only lets me select them. Any ideas? Here's a video to visualize it: http://slavingia.com/etc/helpme.mov

  Read the article

• How to create a database table in an installation file for a Drupal Module?

  - by Koning WWWWWWWWWWWWWWWWWWWWWWW

  I am creating a module for Drupal 7.x, and I want to create a database table when the module is installed (enabled for the first time). How can I do this? Thanks.

  Read the article

< Previous Page | 295 296 297 298 299 300 301 302 303 304 305 306  | Next Page >