Questions tagged [multi-table]
138 questions
0
votes
0 answers
Seeding Data from One Table to Another Table
I want to seed data from ProformaInvoice table to BTBPending table. What I did everything is right but in ProformaInvoice table it is being reference with ItemBreakDown& StyleBreakDown tables using foreign key.
The problem is when I send data from…
Masum Rayhan
- 5
- 3
0
votes
0 answers
Insert Data into Particular Rows from a Different Controller
I have two tables, InHandOrder & ExpRegistry. These table have a common column OrderNo.
When I insert data into the ExpRegistry table, it checks if InHandOrder table's OrderNo is equal to ExpRegistry table's OrderNo; if so, some of the column will…
Masum Rayhan
- 5
- 3
0
votes
0 answers
I have added the following code to add extra tab in woocommerce single product page. And the extra tab is used for to create questions and and answers
add_action( 'wp_enqueue_scripts', 'child_enqueue_styles', 15 );
function custom_questions_answers_tab( $tabs ) {
$tabs['questions_answers'] = array(
'title' => __( 'Questions & Answers', 'text-domain' ),
'callback' =>…
0
votes
0 answers
creating excel worksheete with multiple tabs off of two fixed sets of data
I'm trying to create a excel workbook with multiple tabs in pandas and seems I'm getting stuck on something so simple, yet confusing (for myself) for-loop. Thank you in advance.
dataset = [1,2,3,4,5,6]
dataset2 = [a,b,c,d,e,f]
rows = [x,y,z]
First…
BPD
- 3
- 1
0
votes
1 answer
springbroot 404 when using multi-modei
I want set two different tables.i have try this first model with corresponding service,controller and respository.Everythings is fine but when i use the same code with only changing the model,and develop a set of service,controller and…
user20112858
- 79
- 1
- 6
0
votes
1 answer
Program error-file in use in visual foxpro
i have to do some forms in visual fox pro 9 for a school project, and if i try to use multiple tables in one form occurs the error> file in use, even if i try to use the command "use thistable" "use secondtable" before the code, then i can…
0
votes
1 answer
XSLT combine multiple list from one file to table
I need help with merging several tables of one file into one output.
The files that I get processed perfectly according to the XSLT schema that is listed below. But today I received an interesting file that was not processed as I wanted.
source…
Vladimir
- 5
- 2
0
votes
2 answers
LINQ Left Outer Join Multiple Tables with Group Count and Row Concatenation
Can someone help with below please? I simplified the table/column names, etc. I search everywhere but the answers I get are incomplete solutions for the results I want to achieve below. New to LINQ so please be kind. :-)
TABLES
Parent (ParentId,…
niki b
- 989
- 3
- 10
- 30
0
votes
1 answer
Can I use Restaurant and Category Table many to many relation in Product Model using Laravel? and How can I add update Categories_Restaurants table?
Restaurant Table
id ---> PK
Name
Address
City
Phone
Latitude
Longitude
Categories Table
id-->PK
section_id ---> FK
parent_id ---> for categories and sub-categories
category_name-->
slug
categories_restaurants_table
id-> PK
category_id -->…
Hit4Development
- 1
- 1
0
votes
3 answers
LINQ multi-table query - only 2 of 3 tables are returned
QUERY: I want to return all restaurants with a CUISINE__BANE = cusisineName regardless of the city in which they are located. My query returns the RESTAURANT and CITY tables but not the CUISINE table. Your help is greatly appreciated!
public…
SUSAN
- 51
- 1
- 6
0
votes
1 answer
R: A way to filter based on values in another table?
I have two tables that have the following structures. Table 1, which I will call the Summary Table, is a list of category-values with a…
David Inman
- 95
- 7
0
votes
1 answer
search inside two access tables from C# form
this is my code, How can I search inside Table1 and Table2 with same textbox1.text value, by the other words:
// [Table1]
| name | age |
| -------- | -------------- |
| aaa | 12 |
| bbb | 13 |
|…
Aiman
- 1
- 5
0
votes
0 answers
Missing some column names on a multiple table query
I have two tables in MySQL taba and tabb.
I am using mysqli with PHP
The qry stmnt is $result = $this->$conn->query(select * from taba inner join tabb on colx=coly );
The rows returned are correct however I am not getting all the columns back.
In…
joe_evans
- 120
- 5
0
votes
0 answers
How to get values of selected items id in CheckBox in ASP.NET CORE?
I have 3 table. first one for Movie , second one for Category, third one(MovieCategor) its hold MovieId and Category Id
I want to insert Movie and choose the category. I list to category like checkbox to page View. How to make insert for Movie and…
pederli
- 1
- 1
0
votes
2 answers
Does DB2 implement multi-table indexes?
I'm afraid this functionality may not exist [yet]. I wanted to use an index that spans multiple tables in DB2. I know Oracle and SQL server implement them (with more or less options) and that PostreSQL doesn't seem to implement them yet.
Note: I…
The Impaler
- 45,731
- 9
- 39
- 76