Home > Back-end >  About Delphi query the database no data results
About Delphi query the database no data results

Time:10-06

There is no specific data only the column name

CodePudding user response:

Well, this is difficult, you add some more points

CodePudding user response:

Brother, this problem should not bad, I use other tables are found out, is to built a table was useless, I just registered this number points what haven't understood

CodePudding user response:

"Is the new one table useless", this new list, add the data?

CodePudding user response:

Insert the data

CodePudding user response:

reference 4 floor xuhong887 response:
insert data

Table data, is the problem query is

The table structure, query statement

CodePudding user response:

reference 1st floor sonicer response:
well, this is difficult, you add some more points



refer to the second floor xuhong887 response:
brother, this problem should not bad, I use other tables are found out, is to built a table was useless, I just registered this number points what didn't understand


According to experience, really want to solve this problem, need answer patiently, step by step to understand you, at the same time, to guess where you might have some description of problems, and some other topics not related problems, and then could be LZ is not responsible for, is not willing to help people, etc., etc.
So, this problem will be very hard, have to back more points

CodePudding user response:

With qry1 do
The begin
The Close;
SQL. The Clear;
SQL. The Add (' select * from test3 ");
The Open;
end;
There is a table in the database with data

CodePudding user response:

What is the control display data?? Whether data showed that the control set in the right column names in it??

CodePudding user response:

DBString display, can display column names, data is not

CodePudding user response:

With qry1 do
The begin
The Close;
SQL. The Clear;
SQL. The Add (' select * from test3 ");
The Open;
Showmessage (inttostr (recordcount));//see a value not
end;

If you have, is looking for data display control problems
No data may be: 1 check wrong table; 2 error library

CodePudding user response:

Well, I went to under test

CodePudding user response:

Tried, there is no data, but I plugged in the pl/SQL data, during the test

CodePudding user response:

No data may be: 1 check wrong table; 2 errors in the library

Check the wrong database???
Do you have the data to data table to change a name, try your program can perform well

CodePudding user response:

references 9 f xuhong887 response:
DBString, according to the column name can show, no data is


DBString?? This is which control?? Not DBEdit?? Or DBGrid??

CodePudding user response:

Oh oh, DBGrid

CodePudding user response:

I guess there is no permission to insert data, pl/SQL off each time there is no data to check the time, only after the insert data

CodePudding user response:

Through a database backend write SQL statements to see whether there is data, if any inspection according to related components set if there is a problem,

CodePudding user response:

Check whether there is data in the database!

CodePudding user response:

LZ is datesource didn't even right

CodePudding user response:

"If LZ datesource didn't even right", - column can show that the DataSource is right


One possibility is that even the wrong database

Another possibility is your qry1 set filter and filtered=true
  • Related