Stack Overflow
Stack Overflow

Questions tagged [tablename]

143 questions
2
votes
1 answer

Entity Framework 6 tablename as FK value

I have following two DB tables. The purpose of "attributes" table is to provide user the ability to introduce more fields for existing tables at the runtime. So all user-defined attributes for all tables will be stored in one "attributes" table.…
Sadiq Khoja
  • 522
  • 1
  • 5
  • 23
2
votes
3 answers

mongoid, set_table_name & attr_accessible

I'm using rails3 edge and mongoid 2beta6 with ruby 1.9.2-head. How can I manually change the table name, just like set_table_name for ActiveRecord? For example my model Signup should use the table "users" for storage, not "signups". Another…
gucki
  • 4,582
  • 7
  • 44
  • 56
2
votes
2 answers

LINQ Select from dynamic tableName string

I want to get list of records from an entity model (I'm using EF version 5) with a particular accountID. I'm being supplied with the tableName string (this has to be dynamic) and the accountID. I'm trying the following 2 methods but none of them is…
Chris Attard
  • 31
  • 1
  • 1
  • 5
2
votes
1 answer

create a dynamic table name from current year

I'd like to create a dynamic table name which store the current year and after the table name is it possible? Because i make some summary for a company and its needed to get the current year when the table is made especially now because the next…
balage90
  • 87
  • 1
  • 11
2
votes
3 answers

Automating table/object name scan and search in SAS

OK I'll start with the problem: I have product tables being created every week which are named in the format: products_20130701 products_20130708 . . . I'm trying to automate some campaign analysis so that I don't have to manually change the table…
Charlotte Stevens
  • 91
  • 1
  • 9
2
votes
4 answers

django structure for multiple modules

I'm very new to django and python as well. I want to try out a project written in django. Let say the project have 3 modules User CRUD Forgot password login Booking CRUD Search Default (basically is for web users to view) Home page about…
Js Lim
  • 3,625
  • 6
  • 42
  • 80
2
votes
1 answer

Change table name in Entity Framework (Code First)

The context is the following: A person may belong to a group (he would be a member) and may be admin of a group. This is modeled like this in code-first: class Group { [InverseProperty("GroupsWhereIamAdmin")] public virtual…
sports
  • 7,851
  • 14
  • 72
  • 129
2
votes
3 answers

SQLiteException: near /TABLE_NAME/: syntax error

please help me. I'm getting this error: Caused by: android.database.sqlite.SQLiteException: near "values": syntax error: CREATE TABLE values (_id INTEGER PRIMARY KEY AUTOINCREMENT, name text, caption text, lines integer , photo_url text, type…
user1766287
  • 107
  • 10
1
vote
2 answers

MySQL: The easiest way to display all data from the table by getting TABLE_NAME olny (no column information) on the html page

MySQL db named "db2011" has several tables. Using php variable $tablename (the tablename is correct, the table exists in the db), how to display the data from "db2011".$tablename on the html page? Can it be done by performing just 1 query - to…
Haradzieniec
  • 9,086
  • 31
  • 117
  • 212
1
vote
0 answers

I need to include the table_schema, table_name and column_name in my query output with values

I am creating a report to identify the maximum batch_id for each table and table schema across our databases. I want it to look something like…
Ang Hart
  • 11
  • 2
1
vote
1 answer

SQL Query to find all table names on a database with MySQL

These are tables list on database MySql version…
Edward Sheriff Curtis
  • 487
  • 4
  • 17
1
vote
2 answers

How to extract all tables (including where references) within a SQL query?

I'm working on a huge database, and I have to get a list of all tables used for 100+ procedures. So far I've been able to get a query that returns all the tables that the procedure is getting data from, but no all the tables that are referenced. For…
Fernando Sagasta
  • 21
  • 3
1
vote
0 answers

SSIS Dynamic Excel Destination File Name as Tablename

I receive an excel file with the following info: SQL SERVER SCHEMA TABLENAME AdventureWorksDW Dbo DimOrganization AdventureWorksDW Dbo ... ... ... ... I want to export all columns information from the…
Peter Grins
  • 19
  • 4
1
vote
0 answers

Use common table name across inheritance in ef core

I am new to entity framework and started playing around with it. I am trying to use my usual structure that consists of a Core project that has raw properties. DataAccess extends core classes and adds any additional db specific property and the…
Neville Nazerane
  • 6,622
  • 3
  • 46
  • 79
1
vote
0 answers

Can we use table name as parameter in command text in excel?

Can we use a table name as a parameter in excel (assuming there is a cell reference with the table name) to retrieve data? I'm encountering error message if I try to do so.
Mohamed Fayyaz
  • 11
  • 1
1 2
3
…
9 10