Select distinct *
The from mz_cfmx
Using the sqlca.
: how did this statement has always had a syntax error prompt? Wonder, everybody helps me see...
Select distinct *
Into: a
The from mz_cfmx
Using the sqlca.
And nothing strange

CodePudding user response:

Select distinct *
Into: a
The from mz_cfmx
Using the sqlca.
Also has a problem, you so it's not an error, but also can not accept value,
Sqlerrtext error will be prompted to query column with column

A good foundation embedded SQL usage in the book

CodePudding user response:

I know that is unacceptable to the value of
To look a lot of information is the representation (select distinct * from mz_cfmx using the sqlca. )
Usage is said so

CodePudding user response:

SELECT DISTINCT "column name
"FROM "table name
"
Do not use * you need to query field

CodePudding user response:

Upstairs said is very right

CodePudding user response:

Not corresponding to the concrete columns