Clearly define the NOT cashier IN 0012 0013, but still 0012 0013 collection project detail?????? Why???????????????? I am dizzy dead
CodePudding user response:
I'm deadCodePudding user response:
That is certainly not you write pb6Look at the parameter types
CodePudding user response:
Is what I write, set the same condition, 5555555555CodePudding user response:
Is "cashier" NOT IN (' 0012 ', '0013')CodePudding user response:
The same database? The same table structure?The field name of Chinese characters?
You can in the pb database drawing board under test your SQL, and see what's going on
Pb11 does not support the not likely than in the Chinese football team with a champion in the Olympic Games the possibility of even smaller, should not happen
CodePudding user response:
This is not a PB?Should be SQL server or oracle.
CodePudding user response:
After the execution of the statement and see the sqlca sqlerrtext is whatCodePudding user response:
Such a question I'm afraid you don't see is absolutely won't believe it, I am the ORACLE dbas, dry database for six years, also can be wrong?Field is not Chinese name, in the SQL execution without any error, in ORACLE SQL execution not in work. Is the query results show not PB11 in doesn't work.
CodePudding user response:
By the way is in the DATAWINDOW executionCodePudding user response:
Ha ha, even if you do the 5000 too old gentleman, are you in trouble now, isn't it?First of all, you are to write embedded SQL or with dw to retrieve the data?
Embedded SQL, the select into the implicit cursor directly after value may cause the database error,
, in turn, cause you won't marry data, it is just a reasoned that what specific errors,
After you have performed your SQL statements, executed immediately
Messagebox (' ', the sqlca. Sqlerrtext)
May be some help to you, and second, if you are a dw retrieval,
You pass parameters should be an array of strings rather than string,
There is a problem may be with the great odbc,
Not much said, you this question, this edition to find 100 people to do the same, I don't think there will be more than 100 people can be wrong,
CodePudding user response:
This version to find 100 people to do the same, I don't think there will be more than 10 people can be wrong...CodePudding user response:
Too old gentleman on the upstairs, you still ask, did I say that on the 9 floor are executed in DW, you don't believe, I plane to see why you are doing? You also don't do it? HahaForget it I deleted PB11, with my PB6 can finally? Ha ha
CodePudding user response:
This is a question of CSDN, new post, just always can't see, I now only see 9 f...CodePudding user response:
Pay attention to pick up pointsCodePudding user response:
Take a look atCodePudding user response:
Strange, no? Man still see again carefully,CodePudding user response:
LZ you are now in consult others problemsHow do not call you how refute the somebody else also said he is ORACLE dbas, for six years the database
Other people to help you analyze problems also become others' wrong
Ask others questions will point with an open mind
CodePudding user response:
Don't I use PB11 can ahCodePudding user response:
You write is dead "cashier" NOT IN (' 0012 ', '0013') or write NOT IN parameters (parameters, 1:2)?What type of data window defined parameter is?
What type of database "cashier" is?
The data window of SQL post
General indefinite number of similar parameters to dw using array type
Not in (: array_parm)
Do not omit the parentheses is must
CodePudding user response:
Khan post two years ago you · · · · · ·CodePudding user response:
The