SQL is
in the CONThe SELECT CARDSELLJFHEAD. CSJHTIME CSJHTIME_MIN,
CARDSELLJFHEAD. CSJHTIME CSJHTIME_MAX
The FROM CARDSELLJFHEAD

Then two textbox text box is CSJHTIME_MIN, CSJHTIME_MAX
Tag respectively wrote in min (CARDSELLJFHEAD CSJHTIME) and Max (CARDSELLJFHEAD. CSJHTIME)

The list of SQL is
The SELECT CARDSELLJFHEAD CSJHCDMNO,
CARDMAIN CDMNAME,
CARDSELLJFDETAIL. CSJDCJJE * fGetInvSign CSJHVCHR CSJDCJJE,
Cdetel cdemobile, csjhsyjid, csjhinvno
The FROM CARDSELLJFDETAIL, CARDSELLJFHEAD CARDMAIN, cardextent
WHERE CARDSELLJFHEAD. CSJHCDMNO=CARDSELLJFDETAIL. CSJDCDMNO AND
CARDSELLJFHEAD. CSJHBILLNO=CARDSELLJFDETAIL. CSJDBILLNO AND
CARDSELLJFHEAD. CSJHMKT=CARDSELLJFDETAIL. CSJDMKT AND
CARDSELLJFHEAD. CSJHCDMNO=CARDMAIN. CDMNO AND
CARDSELLJFHEAD. CSJHTIME & gt;=to_date (' csjhtime_min ', '- dd yyyy - mm HH24: MI: SS') AND
CARDSELLJFHEAD. CSJHTIME & lt;=to_date (' csjhtime_max ', '- dd yyyy - mm HH24: MI: SS') AND
Cdmno=cdeno
The order by CSJDCJJE desc

Note that csjhtime_min input is the 2007-09-20 15:00:00
Csjhtime_min input is the 2007-09-20 15:59:59 I want to take the contents of the 1 hour,,,

Hang report on system, the prompt "in condition to shout with illegal doesn't recognize operator type!"

Help me, ah, to the company,,, depressed, online, etc.,,,

CodePudding user response:

You can use some comments to determine where the problem is
This error has nothing to do with the syntax, the estimate is mixed with illegal characters

How need not alias, looked at very tired

CodePudding user response:

I tried,,, the MIN and MAX in the LIST with specific time 15:00:00. 2007-09-20. 15: : 59:59 can find and display the information,,,

I suspect that is error, CON,

CodePudding user response:

To_date (' csjhtime_min '

Is csjhtime_min variables? Why use '?

CodePudding user response:

DEBUG, the SQL statement copy out, check for errors

CodePudding user response:

Csjhtime_min is variable, you see in the CON,

SQL statements don't mistake, I test

CodePudding user response:

What I mean is obtained through the debug runtime SQL, to check whether there is problem csjhtime_min variable values

If the debug for SQL is normal, there is no reason to formal run when there will be a problem

CodePudding user response:

I can't see the DEBUG, I developed this is 2 times,,, no way to test, and can only see effect is written directly on the system,,,,

Is ok, step test, and 5555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555
Want to had a breakpoint 555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555

CodePudding user response:

Do you have QQ/add me 19007492

You know the distance I see

CodePudding user response:

The variables that you can use messagebox, shown up to see if normal

I'm sorry, I don't use QQ here