| |

VerySource

 Forgot password?
 Register
Search
Author: cctvgun

Data view cannot display data

[Copy link]

2

Threads

12

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-6 09:24:01
| Show all posts
Found it, wait a minute, I execute it
Reply

Use magic Report

2

Threads

12

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-6 09:27:01
| Show all posts
After execution is complete, no data is displayed
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-1-6 09:48:01
| Show all posts
That is the problem of your where condition. Are the two tables related through the fields you wrote, and the condition is wrong, there must be no data ...
WHERE ("contract". "Gsxm" = "project". "Xmbm")
Reply

Use magic Report

2

Threads

12

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 Japan

 Author| Post time: 2020-1-6 10:06:02
| Show all posts
xmbm is the primary key of the project, do the gsxm and xmbm fields need to be set to the contract's foreign key?
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-1-6 10:45:01
| Show all posts
Having a primary foreign key and whether to set the relationship are two different things, see if the xmbm and gsxm data in the two tables are the same
Reply

Use magic Report

2

Threads

12

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-6 11:00:01
| Show all posts
Ok, got it, i double checked, thanks again
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list