Stack Overflow
Stack Overflow

Questions tagged [multi-table]

138 questions
0
votes
1 answer

EntityFramework Mutli-Table Many-to-Many

I'm working with EF4.1 Code First and am trying to create some Many-to-Many relationship tables where there tables would need to be linked. Please see small snippet of code beloow: class Event { int EventId { get; set; } ICollection…
Tomasz Iniewicz
  • 4,379
  • 6
  • 42
  • 47
0
votes
1 answer

Getting grouped data in column format rather than by rows from a MySQL query

It's difficult to make a more descriptive title for this. I've spent a couple of hours on it now and figured best to just ask someone! I have 3 tables, which look something like this Locations: id | name 1 | Plymouth 2 …
Jamie Hartnoll
  • 7,231
  • 13
  • 58
  • 97
0
votes
2 answers

Android Sqlite multiple cursor for multiple table

I have a SQLite database with multiple table however some table are linked and some are not but what i want is to read from one table and write to another table concurrently ... so my question is here that can i have two different cursor pointing to…
Vipin Sahu
  • 1,441
  • 1
  • 18
  • 29
0
votes
2 answers

Crystal Report multi table failure

I'm still new to C# and reports, and in order to take baby steps, I started with a Crystal Report using one table. Eventually I figured it out and it worked brilliantly. Then I added another table to the report. I haven't changed anything in my…
user1339124
  • 33
  • 1
  • 4
-1
votes
1 answer

Union tables with same prefix in postgresql

I have number of tables with prefix "tb_" in a schema (not public) in postgres database. I want to create a new table as union of all these tables with prefix "tb_". All the tables have same structure and no duplicates. I could do it manually using…
Jio
  • 578
  • 3
  • 8
  • 27
-1
votes
1 answer

How to select data in multiple table and view it in day-wise?

I have developed an Employees Lunch Break-Time Tracker where the employee has to punch in/out before and after their lunch break time. I calculated the total break in minutes and saved it in the DB. I provided a report to the HR department of all…
Borgy ES
  • 11
  • 9
-1
votes
1 answer

Update table if value in another table is met

I have two tables: one is called PMWO and the other table is called PMWO_DTL PMWO has a field named ARCHIVED PMWO_DTL has a field named WO_OPEN I need to set ARCHIVED to 'Y' when WO_OPEN equals 'N' the two tables can be linked by the…
Beso90
  • 3
  • 1
-1
votes
2 answers

SQL Server : SELECT Column A from Column B

First, I hope the topic title wasn't too vague, I'm not really sure how to describe this issue. I have been handed an inventory database that was grown and developed by a few generations of people with varying levels of skill. Now it have tons of…
Toaster
  • 93
  • 1
  • 7
-1
votes
1 answer

How to get multi table and paste to multi dropdowListFor on view

I'm newbie ASP.NET MVC. I have many table such as (Country, State and city). I want to put value in these DropDownListFor in one view. Could you help me please. Sorry for my bad question and bad English skill.
Ich-Bullet Puen
  • 91
  • 1
  • 4
  • 11
-1
votes
2 answers

SQL adding prices to produce table of cakes

I really hope someone can help me with this sql query, been racking my brain but I know it's possible...This is my current query and produces the right format: DECLARE @Price1 NVARCHAR(20), @Price2 NVARCHAR(20), @Price3 NVARCHAR(20), @Price4…
ookie
  • 138
  • 11
-1
votes
1 answer

Avoiding duplicate rows being inserted in where unizue rows are obtained from two tables

I have a two tables such as customer_name and customer_phone, but the unique customer is identified from the combination of all the four columns from two of the tables. Since we have multiple souce systems inserting into the below tables at the…
Vinal S
  • 1
-1
votes
2 answers

Setting up 2 table with SQLOpenHelper throw error

I'm trying to rebuild my databaseHandler since I need to use 2 tables. I followed the answer given here : Multiple Table SQLite DB Adapter(s) in Android? but this is giving me the following issue : Attempt to invoke virtual method…
Alexandre
  • 1,259
  • 2
  • 15
  • 25
-1
votes
1 answer

Multi table query issue

I'm really stuck on this SQL question on my hw assignment. I was wondering if any of you can help me. These are the questions that I'm stuck on... I really don't know which queries to go with to grab data from two different tables for example: get…
Anthony Sawah
  • 57
  • 1
  • 7
-1
votes
1 answer

Android sqlite multi table populate

I m working on Android SQLite. My problem is that How do I work with many sqlite tables, with which I have two activity being populated and layout with gridview and listview, each of these invoke different table.
Morliz
  • 1
-1
votes
2 answers

Multi-table generic query model for CakePHP

I have approximately 25 join queries I need to build to run in a project on CakePHP. It is much faster to just work in MySQL WorkBench or phpMyAdmin building the queries, and then drop into PHP code than to use the screwed up cakePHP model parms…
OldManRiver
  • 128
  • 1
  • 6
1 2 3
…
9
10