Stack Overflow
Stack Overflow

Questions tagged [tablename]

143 questions
0
votes
1 answer

Getting list of table names from database in Android application

I am trying to get a list of table names from an SQLite database. I manage to get this, but I also get temporary table names like 'android_metadata' and 'sqlite_sequence'. I want to exclude these 2. However, I can't get it to work…
user820913
  • 623
  • 4
  • 12
  • 23
0
votes
1 answer

Pass table name using parameter in SQL Server stored procedure

I want to create a stored procedure that will update a table. The procedure will join two tables and I want to pass the table name using a variable (@tablename). This error is generated: Must declare the table variable "@tablename". My…
Stephen
  • 23
  • 1
  • 6
0
votes
1 answer

Rails HBTM join_table overwirting table_name

I'm running Rails 2.3.2 and doing: class StandardWidget < ActiveRecord::Base has_and_belongs_to_many :parts, :join_table => "widgets_parts", :association_foreign_key => "widget_custom_id" end class Part < ActiveRecord::Base …
ma11hew28
  • 121,420
  • 116
  • 450
  • 651
0
votes
1 answer

Oracle table SAMPLE no longer updates

A few years ago, my Oracle table called SAMPLE stopped accepting update or insert commands. I finally found that if I renamed the table all would work, so it appears SAMPLE may be a protected word, yet I don't see it on the Oracle reserved or…
beanmf
  • 493
  • 5
  • 7
0
votes
0 answers

get classes with tablename associated sqlalchemy

I have a file EE_log_declarative.py with all the classes declared, generated by sqlacodegen engine --outfile declarative_model.py, that looks like the below, which imports as well all the data types as classes, like BigInteger, Boolean, ForeignKey,…
jcardoso
  • 1
  • 2
0
votes
1 answer

Laravel Pivot table not found

My goal. I have 3 Laravel models: user, campaign and campaign_players. I want to get info about a user, and also the campaigns he/she is playing. The problem. When I run this query : $campaigns = user::with(['campaigns_playing'])->where('id',…
Olof84
  • 919
  • 4
  • 14
  • 29
0
votes
1 answer

sqlite - subquery for table name

I use SQLite. How can I use something like this: INSERT INTO ( SELECT `table_name` FROM `tables` WHERE `id`=1)(`data_column_name`) VALUES ('some data') Thanks for help
Sven Richter
  • 413
  • 3
  • 8
  • 15
0
votes
0 answers

How do I dynamically reference changing table names after the FROM keyword in MYSQL

I am not sure how to get the syntax of this right. So I have a cursor that loops through a table User.Persona and captures the Id column. So each Id is stored into the variable cur_id with every iteration of the cursor. And each Persona Id will…
truffle
  • 455
  • 1
  • 9
  • 17
0
votes
2 answers

DataGridView.DataMember throws error when assigned a two-part name. i.e. Sales.StoreContact

My problem is outlined here: https://support.microsoft.com/kb/314043 Microsoft says: "This behavior is by design." and no workaround is provided. I need a workaround. I have a dataset which is populated correctly with the contents of the table name…
user323186
  • 95
  • 1
  • 3
  • 9
0
votes
3 answers

SQL Server : getting certain table names from query

Is it possible to display just certain table names in the query: USE [WebContact] SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'memberEmails' Most of the time I would need all the table names but there are curtain…
StealthRT
  • 10,108
  • 40
  • 183
  • 342
0
votes
2 answers

SQL/JDBC : select query on variable tablenames

I'm using Oracle DB and I would like to write a SQL query that I could then call with JDBC. I'm not very familiar with SQL so if someone can help me, that could be great ! Here is the problem. I have a table MY_TABLE wich contains a list of another…
user442462
  • 1
0
votes
1 answer

Synonyms in hyperfilesql and reserved keyword user

How can I create a synonym in HyperFileSQL? I have a table named USER and I cannot Access it via ODBC. I can't rename it, so I want to create a synonym for it. How do I do this?
nawfal
  • 21
  • 3
0
votes
1 answer

Get Table and Field names used to create a query in Access VBA

I am trying to get a list of the tables and fields that are used to produce queries in an access database. I am able to identify the fields found in a query output but not the fields used to design the query. In other words, is it possible to obtain…
mccdo
  • 55
  • 3
  • 11
0
votes
0 answers

Dynamic table name in Excel SQL query

I couldn't find any solution to set a SQL query in Excel with a dynamic table name which is in one of the cells in the workbook. LEFT JOIN [param!$a$5] B ON B.LOGICALREF = H.ACCFICHEREF param!a5 has the name of the table. More info : i have…
Umut K
  • 1,364
  • 12
  • 25
0
votes
1 answer

mysql 5.6 change lower_case_table_names won't work

My os is windows 7 and mysql version is 5.6.20; I opened my.ini, add lower_case_table_names=2 as a line below [mysqld], save and quit; Selected with show variables like '%lower_case_table_names%'; and the request is lower_case_table_names 2, I…
user5157189
  • 1
  • 1
1 2 3
…
9 10