Delphi - database table field with Chinese names appear problem, please solve!!!!!!-CodePudding

In a receipt of the study, I try to put a table field name changed to all Chinese, other temporary not found the problem, but in the component FDQuery SQL (TStrings) enter the following:

 Select Max (GRN) From Table

Results to the query, check fields can be directly (below), you can't do with Chinese name field? Or method is wrong? ,
!!!!!!!!! A great god, please guide!!!!!!

CodePudding user response:

You try like this:
The Select Max (GRN) as receipt number From the Table

CodePudding user response:

reference 1st floor tanqth response:

you try like this:
The Select Max (GRN) as receipt number From the Table

I was single, not number!

CodePudding user response:

refer to the second floor golden age of science and technology - 2 reply:

Quote: refer to 1st floor tanqth response:

You try like this:
The Select Max (GRN) as receipt number From the Table

I was single, not number!

That change:

 
The Select Max (GRN) as the largest receipt number From the Table

CodePudding user response:

reference tanqth reply: 3/f

Quote: refer to the second floor golden age of science and technology - 2 reply:

Quote: refer to 1st floor tanqth response:

You try like this:
The Select Max (GRN) as receipt number From the Table

I was single, not number!

That change:

The Select Max (GRN) as the largest receipt number From the Table

Thank you very much! I'll try to explain the specific what meaning be?

CodePudding user response:

cited the golden age of science and technology - 2, 4/f, reply:

Quote: refer to the third floor tanqth response:

Quote: refer to the second floor golden era of science and technology - 2 reply:

Quote: refer to 1st floor tanqth response:

You try like this:
The Select Max (GRN) as receipt number From the Table

I was single, not number!

That change:

The Select Max (GRN) as the largest receipt number From the Table

Thank you very much! I'll try to explain the specific what meaning be?

Speaks clearly, the,
https://www.w3school.com.cn/sql/sql_alias.asp

CodePudding user response:

reference 5 floor tanqth reply:

Quote: cited the golden age of science and technology - 2, 4/f, reply:

Quote: refer to the third floor tanqth response:

Quote: refer to the second floor golden era of science and technology - 2 reply:

Quote: refer to 1st floor tanqth response:

You try like this:
The Select Max (GRN) as receipt number From the Table

I was single, not number!

That change:

The Select Max (GRN) as the largest receipt number From the Table

Thank you very much! I'll try to explain the specific what meaning be?

Speaks clearly, the,
https://www.w3school.com.cn/sql/sql_alias.asp

Well, first to collect the first!

CodePudding user response:

The Select Max (GRN) as the largest receipt number From the Table

As the back is your own definition of the field names, you can define any name

CodePudding user response:

The Select Max (GRN) From Table

Select Max (GRN) as number From the Table