Printable View
Hi,
I have to write a SQL to insert records into my table(The table has
a large amounts of fields,more than 100).
The SQL is a CString, but it is too big and exceeds the
maxium length of a CString. Please help me how can I
create a string with any huge length? Code examples would
be more appreciated.Or any method I can use to solve this problem?
Thanks a lot.
wang
"exceeds the maxium length of a CString"
really?
CString hasn't maxium length.it use "new" internal
Well...sorry but this is not true...to keep track of the length 'CString' uses an integer...thus it can only hold up to INT_MAX - 1 (2,147,483,646) characters... :cool:Quote:
Originally posted by FINIX
"exceeds the maxium length of a CString"
really?
CString hasn't maxium length.it use "new" internal
wangnanjing, please do not cross-post your questions to several forums. Thank you very much...
Quite true, this is a limit imposed in CString::AllocBuffer by an ASSERT.Quote:
Well...sorry but this is not true...to keep track of the length 'CString' uses an integer...thus it can only hold up to INT_MAX - 1 (2,147,483,646) characters...
But FINIX is right. An "Out of memory" exception may be thrown when try to allocate memory for INT_MAX-1 characters.
I think the point is being missed. I really doubt the CString is 2.1 gigs of data....can we get to the real issue please?
Who did that huge SQL statement?
Somehow it was made by some erudite designer(s), dragging/dropping
some squares and arrows, then automatically generated the SQL statement? :D
Anyhow, that statement must be reviewed to be optimized, parsed in few smaller, and so on.
You can see from my previous post, that if somebody can solve the problem as you wish,Quote:
The SQL is a CString, but it is too big and exceeds the
maxium length of a CString. Please help me how can I
create a string with any huge length?
for sure you'll have got problem with the memory.
That's it!
Umm yea....what I said...Quote:
Originally posted by ovidiucucu
Who did that huge SQL statement?
Somehow it was made by some erudite designer(s), dragging/dropping
some squares and arrows, then automatically generated the SQL statement? :D
Anyhow, that statement must be reviewed to be optimized, parsed in few smaller, and so on.
You can see from my previous post, that if somebody can solve the problem as you wish,
for sure you'll have got problem with the memory.
That's it!
Go ahead...or what was the reason of the post?Quote:
Originally posted by Mick_2002
...can we get to the real issue please?
I do not see that....'CString' has a limit...disregarding whether 'new' is used or not...Quote:
Originally posted by ovidiucucu
But FINIX is right.
I don't know, what was the reason for the post?Quote:
Originally posted by Andreas Masur
Go ahead...or what was the reason of the post?
Well...joking is okay sometimes...but there is a fine line between sometimes and too many times... ;)Quote:
Originally posted by Mick_2002
I don't know, what was the reason for the post?
Who was joking?Quote:
Originally posted by Andreas Masur
Well...joking is okay sometimes...but there is a fine line between sometimes and too many times... ;)
How do you create your string??
If it is something like this:
CString str = "very huge string";
you can do the following:
CString str = "string shorter";
str += "the rest of the string";
I think the point of Mick's post is it is very unlikely that the CString
is really 2.1G so something else must be going on.
And here I thought that was obvious :)Quote:
Originally posted by souldog
I think the point of Mick's post is it is very unlikely that the CString
is really 2.1G so something else must be going on.
You may try:Quote:
How do you create your string??
Good luck!Code:CString str( _T('A'), INT_MAX-1 );
However:
2,147,352,576 == unreserved virtual memory (accessible by a process (NT)).
2,147,483,646 == INT_MAX - 1
Also I think, we are on a wrong path.
wangnanjing, would you, please, clarify your problem?
I don't know how that would help if the length is really exceeded.Quote:
Originally posted by irona20
How do you create your string??
If it is something like this:
CString str = "very huge string";
you can do the following:
CString str = "string shorter";
str += "the rest of the string";
In fact this seems interesting. Consider this code for CString
So what happens if the sum of the lengths exceeds the size of int?PHP Code:// NOTE: "operator+" is done as friend functions for simplicity
// There are three variants:
// CString + CString
// and for ? = TCHAR, LPCTSTR
// CString + ?
// ? + CString
void CString::ConcatCopy(int nSrc1Len, LPCTSTR lpszSrc1Data,
int nSrc2Len, LPCTSTR lpszSrc2Data)
{
// -- master concatenation routine
// Concatenate two sources
// -- assume that 'this' is a new CString object
int nNewLen = nSrc1Len + nSrc2Len;
if (nNewLen != 0)
{
AllocBuffer(nNewLen);
memcpy(m_pchData, lpszSrc1Data, nSrc1Len*sizeof(TCHAR));
memcpy(m_pchData+nSrc1Len, lpszSrc2Data, nSrc2Len*sizeof(TCHAR));
}
}
CString AFXAPI operator+(const CString& string1, const CString& string2)
{
CString s;
s.ConcatCopy(string1.GetData()->nDataLength, string1.m_pchData,
string2.GetData()->nDataLength, string2.m_pchData);
return s;
}
here
Am I seeing thingsPHP Code:int nNewLen = nSrc1Len + nSrc2Len;
if (nNewLen != 0)
{
AllocBuffer(nNewLen);
Speculation :) I'd like to see what is going on first....Quote:
Originally posted by souldog
I don't know how that would help if the length is really exceeded.
In fact this seems interesting. Consider this code for CString
So what happens if the sum of the lengths exceeds the size of int?PHP Code:// NOTE: "operator+" is done as friend functions for simplicity
// There are three variants:
// CString + CString
// and for ? = TCHAR, LPCTSTR
// CString + ?
// ? + CString
void CString::ConcatCopy(int nSrc1Len, LPCTSTR lpszSrc1Data,
int nSrc2Len, LPCTSTR lpszSrc2Data)
{
// -- master concatenation routine
// Concatenate two sources
// -- assume that 'this' is a new CString object
int nNewLen = nSrc1Len + nSrc2Len;
if (nNewLen != 0)
{
AllocBuffer(nNewLen);
memcpy(m_pchData, lpszSrc1Data, nSrc1Len*sizeof(TCHAR));
memcpy(m_pchData+nSrc1Len, lpszSrc2Data, nSrc2Len*sizeof(TCHAR));
}
}
CString AFXAPI operator+(const CString& string1, const CString& string2)
{
CString s;
s.ConcatCopy(string1.GetData()->nDataLength, string1.m_pchData,
string2.GetData()->nDataLength, string2.m_pchData);
return s;
}
here
Am I seeing thingsPHP Code:int nNewLen = nSrc1Len + nSrc2Len;
if (nNewLen != 0)
{
AllocBuffer(nNewLen);
thank you very little
Well, I don't think that the SQL statment are so huge.
I had this problem once:
I have to split my string because I get an error in runtime. So, maybe it is the same error.Code:CString strAux = "SELECT DISTINCT \
GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
GenInfArbolesCF.nGIAR_COMPORT, \
GenInfArbolesCF.nGIAR_TIPOEJE, \
GenInfArbolesCF.nGIAR_PROFUN, \
GenInfArbolesCF.sGIAR_NODO, \
MasterTreesStructure.NodeCode, \
MasterTrees.TreeNumberOfLevels,\
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder \
FROM GenInfInforme INNER JOIN \
GenInfInformeDetalles ON \
(GenInfInformeDetalles.sINFO_CODIGO = GenInfInforme.sINFO_CODIGO) \
INNER JOIN Users ON (Users.UsuarioID = GenInfInforme.sINFO_USUARIO)\
INNER JOIN \
GenInfArbolesCF ON \
(GenInfInformeDetalles.sIDET_VISTA = GenInfArbolesCF.sGIAR_VISTA \
AND \
GenInfInformeDetalles.sIDET_CONSULTA = GenInfArbolesCF.sGIAR_CONSULTA \
AND \
GenInfInformeDetalles.sIDET_USUARIO = GenInfArbolesCF.sGIAR_USUARIO \
AND \
GenInfInformeDetalles.sINFO_CODIGO = GenInfArbolesCF.sGIAR_CODIGO) \
INNER JOIN \
MasterTrees ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTrees.TreeMasterCode) \
INNER JOIN \
MasterTreesStructure ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTreesStructure.TreeMasterCode) ";
strAux += "WHERE ((GenInfInforme.bINFO_PRIVADO = 0 AND Users.GrupoID = '%s') OR \
GenInfInforme.sINFO_USUARIO = '%s') AND \
((GenInfArbolesCF.nGIAR_TIPOEJE = 2) OR \
((GenInfArbolesCF.nGIAR_TIPOEJE < 2) AND \
((MasterTrees.TreeNumberOfLevels - 1) \
> MasterTreesStructure.NodeLevel))) AND \
((GenInfArbolesCF.nGIAR_COMPORT = 0) OR \
((GenInfArbolesCF.nGIAR_COMPORT > 0) AND \
((MasterTrees.TreeNumberOfLevels - MasterTreesStructure.NodeLevel \
- 1) >= GenInfArbolesCF.nGIAR_PROFUN))) \
ORDER BY GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder";
I didn't mean that to be related to this guys problem. I mean is that a bug in CStringQuote:
Originally posted by Mick_2002
Speculation :) I'd like to see what is going on first....
thank you very little
What was the runtime error? The char looks proper to meQuote:
Originally posted by irona20
Well, I don't think that the SQL statment are so huge.
I had this problem once:
I have to split my string because I get an error in runtime. So, maybe it is the same error.Code:CString strAux = "SELECT DISTINCT \
GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
GenInfArbolesCF.nGIAR_COMPORT, \
GenInfArbolesCF.nGIAR_TIPOEJE, \
GenInfArbolesCF.nGIAR_PROFUN, \
GenInfArbolesCF.sGIAR_NODO, \
MasterTreesStructure.NodeCode, \
MasterTrees.TreeNumberOfLevels,\
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder \
FROM GenInfInforme INNER JOIN \
GenInfInformeDetalles ON \
(GenInfInformeDetalles.sINFO_CODIGO = GenInfInforme.sINFO_CODIGO) \
INNER JOIN Users ON (Users.UsuarioID = GenInfInforme.sINFO_USUARIO)\
INNER JOIN \
GenInfArbolesCF ON \
(GenInfInformeDetalles.sIDET_VISTA = GenInfArbolesCF.sGIAR_VISTA \
AND \
GenInfInformeDetalles.sIDET_CONSULTA = GenInfArbolesCF.sGIAR_CONSULTA \
AND \
GenInfInformeDetalles.sIDET_USUARIO = GenInfArbolesCF.sGIAR_USUARIO \
AND \
GenInfInformeDetalles.sINFO_CODIGO = GenInfArbolesCF.sGIAR_CODIGO) \
INNER JOIN \
MasterTrees ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTrees.TreeMasterCode) \
INNER JOIN \
MasterTreesStructure ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTreesStructure.TreeMasterCode) ";
strAux += "WHERE ((GenInfInforme.bINFO_PRIVADO = 0 AND Users.GrupoID = '%s') OR \
GenInfInforme.sINFO_USUARIO = '%s') AND \
((GenInfArbolesCF.nGIAR_TIPOEJE = 2) OR \
((GenInfArbolesCF.nGIAR_TIPOEJE < 2) AND \
((MasterTrees.TreeNumberOfLevels - 1) \
> MasterTreesStructure.NodeLevel))) AND \
((GenInfArbolesCF.nGIAR_COMPORT = 0) OR \
((GenInfArbolesCF.nGIAR_COMPORT > 0) AND \
((MasterTrees.TreeNumberOfLevels - MasterTreesStructure.NodeLevel \
- 1) >= GenInfArbolesCF.nGIAR_PROFUN))) \
ORDER BY GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder";
I didn't look...should I look? :) Given the number of bugs in MFC I do not doubt it :)Quote:
Originally posted by souldog
I didn't mean that to be related to this guys problem. I mean is that a bug in CString
I don't renember, it was three years ago :) I only renember I had to split my string.Quote:
Originally posted by Mick_2002
What was the runtime error? The char looks proper to me
For wangnanjing
If your problem is really an SQL statement, something like "SELECT blabla,... FROM...",
If you can zip and attach it here, then there is no problem. For sure, somebody will help you.
I have a supposition. Somehow your "SQL" is a long binary field in a recordset,
and you had some problems trying to put it in a CString ???
Heh it's ok Irona...given the number of responses, it will be three years before the original poster responds :)Quote:
Originally posted by irona20
I don't renember, it was three years ago :) I only renember I had to split my string.
Do you know any software stuff without bugs?Quote:
Originally posted by Mick_2002
I didn't look...should I look? :) Given the number of bugs in MFC I do not doubt it :)
Yes? That means it does nothing.
Yep...it's called any code I write...what you never heard of FVT or UNIT testing...wow imagine that....Quote:
Originally posted by ovidiucucu
Do you know any software stuff without bugs?
Yes? That means it does nothing.
EDIT: does it piss me off to no end that you have that attitude? yes it does.
Sorry man, you must throw it away!Quote:
Originally posted by Mick_2002
Yep...it's called any code I write...what you never heard of FVT or UNIT testing...wow imagine that....
Or it's insufficient tested, or nobody use it except you.
Keep in mind: nothing is perfect.
I hope no offense, Just :D :D :DQuote:
Originally posted by Mick_2002
EDIT: does it piss me off to no end that you have that attitude? yes it does.
Wow...geez, I've never coded for the big boys :) Why don't you try your attitude when coding for medical devices? Hmm? Maybe your NIBP isn't what your NIBP is? hmm? Maybe somebody makes a descision based on your cardiac calcs? Maybe then your dead :)Quote:
Originally posted by ovidiucucu
Sorry man, you must throw it away!
Or it's insufficient tested, or nobody use it except you.
Keep in mind: nothing is perfect.
Stupidity is no offense, it's called darwinism :)Quote:
I hope no offense, Just :D :D :D
I wrote some code for medical applications, but for sure I you don't know my atitude about coding.Quote:
Originally posted by Mick_2002
Wow...geez, I've never coded for the big boys :) Why don't you try your attitude when coding for medical devices?
I think we must leave this discussion. We can fight for something better.
Good luck and keep ahead, young man! ;)
I was being sarcastic.Quote:
Originally posted by ovidiucucu
I wrote some code for medical applications, but for sure I you don't know my atitude about coding.
I think we must leave this discussion. We can fight for something better.
Good luck and keep ahead, young man! ;)
/GE Medical or GEMMS (ain't that a farking GEM)
Yes.I have the same situation as you. Because there are more than 100 fields in one single table of my DB, it makes the select and insert SQL very very long.Quote:
Originally posted by irona20
Well, I don't think that the SQL statment are so huge.
I had this problem once:
I have to split my string because I get an error in runtime. So, maybe it is the same error.Code:CString strAux = "SELECT DISTINCT \
GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
GenInfArbolesCF.nGIAR_COMPORT, \
GenInfArbolesCF.nGIAR_TIPOEJE, \
GenInfArbolesCF.nGIAR_PROFUN, \
GenInfArbolesCF.sGIAR_NODO, \
MasterTreesStructure.NodeCode, \
MasterTrees.TreeNumberOfLevels,\
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder \
FROM GenInfInforme INNER JOIN \
GenInfInformeDetalles ON \
(GenInfInformeDetalles.sINFO_CODIGO = GenInfInforme.sINFO_CODIGO) \
INNER JOIN Users ON (Users.UsuarioID = GenInfInforme.sINFO_USUARIO)\
INNER JOIN \
GenInfArbolesCF ON \
(GenInfInformeDetalles.sIDET_VISTA = GenInfArbolesCF.sGIAR_VISTA \
AND \
GenInfInformeDetalles.sIDET_CONSULTA = GenInfArbolesCF.sGIAR_CONSULTA \
AND \
GenInfInformeDetalles.sIDET_USUARIO = GenInfArbolesCF.sGIAR_USUARIO \
AND \
GenInfInformeDetalles.sINFO_CODIGO = GenInfArbolesCF.sGIAR_CODIGO) \
INNER JOIN \
MasterTrees ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTrees.TreeMasterCode) \
INNER JOIN \
MasterTreesStructure ON \
(GenInfArbolesCF.sGIAR_ARBOL = MasterTreesStructure.TreeMasterCode) ";
strAux += "WHERE ((GenInfInforme.bINFO_PRIVADO = 0 AND Users.GrupoID = '%s') OR \
GenInfInforme.sINFO_USUARIO = '%s') AND \
((GenInfArbolesCF.nGIAR_TIPOEJE = 2) OR \
((GenInfArbolesCF.nGIAR_TIPOEJE < 2) AND \
((MasterTrees.TreeNumberOfLevels - 1) \
> MasterTreesStructure.NodeLevel))) AND \
((GenInfArbolesCF.nGIAR_COMPORT = 0) OR \
((GenInfArbolesCF.nGIAR_COMPORT > 0) AND \
((MasterTrees.TreeNumberOfLevels - MasterTreesStructure.NodeLevel \
- 1) >= GenInfArbolesCF.nGIAR_PROFUN))) \
ORDER BY GenInfInforme.sINFO_CODIGO, \
GenInfInformeDetalles.sIDET_VISTA, \
GenInfInformeDetalles.sIDET_CONSULTA, \
GenInfInformeDetalles.sIDET_USUARIO, \
GenInfArbolesCF.sGIAR_ARBOL, \
MasterTreesStructure.NodeLevel, \
MasterTreesStructure.NodeTreeOrder";
Actually,I tried this way:
CString sqlcmd1("SELECT [CONTINUOUS_FURNACE_NAME],[FURNACE_TYPE],[FURNACE_HEATING_TYPE],[IMAGE_PATH],[CONTINUOUS_FURNACE_TYPE],[OVERALL_W],[OVERALL_H],[WORK_SPACE_W], [WORK_SPACE_H],[ENTRY_OPENNING_AREA],[END_OPENNING_AREA],[MUFFLE],[BELT WIDTH],[BELT_MOVING],[BELT_UNIT_WEIGHT],[FURNACE_ EFFICIENY],[BELT_RETURN],[SHELL_COOLING_WATER_RATE],[THROU_AIR_FLOW],");
CString sqlcmd2("[ZONE_NUMBER],[Z1_LENGTH], [Z1_TRANSITION], [Z1_ATMOSPHERE], [Z1_FAN_HP],[Z1_ATMOSPHERE_FLOW],[Z1_CONNECTED_INPUT],[Z1_THROU_METAL_AREA],[Z2_LENGTH], [Z2_TRANSITION], [Z2_ATMOSPHERE], [Z2_FAN_HP],[Z2_ATMOSPHERE_FLOW],[Z2_CONNECTED_INPUT],[Z2_THROU_METAL_AREA],[Z3_LENGTH], [Z3_TRANSITION],[Z3_ATMOSPHERE], [Z3_FAN_HP],[Z3_ATMOSPHERE_FLOW],[Z3_CONNECTED_INPUT],[Z3_THROU_METAL_AREA],[Z4_LENGTH], [Z4_TRANSITION], [Z4_ATMOSPHERE], [Z4_FAN_HP],[Z4_ATMOSPHERE_FLOW],[Z4_CONNECTED_INPUT],[Z4_THROU_METAL_AREA],[Z5_LENGTH], [Z5_TRANSITION],[Z5_ATMOSPHERE], [Z5_FAN_HP],[Z5_ATMOSPHERE_FLOW],[Z5_CONNECTED_INPUT],[Z5_THROU_METAL_AREA],[Z6_LENGTH], [Z6_TRANSITION],[Z6_ATMOSPHERE], [Z6_FAN_HP],[Z6_ATMOSPHERE_FLOW],[Z6_CONNECTED_INPUT],[Z6_THROU_METAL_AREA],[Z7_LENGTH], [Z7_TRANSITION],[Z7_ATMOSPHERE], [Z7_FAN_HP],[Z7_ATMOSPHERE_FLOW],[Z7_CONNECTED_INPUT],[Z7_THROU_METAL_AREA],[Z8_LENGTH], [Z8_TRANSITION],[Z8_ATMOSPHERE], [Z8_FAN_HP],[Z8_ATMOSPHERE_FLOW],[Z8_CONNECTED_INPUT],[Z8_THROU_METAL_AREA],[Z9_LENGTH],[Z9_TRANSITION],[Z9_ATMOSPHERE],[Z9_FAN_HP],[Z9_ATMOSPHERE_FLOW],[Z9_CONNECTED_INPUT],[Z9_THROU_METAL_AREA],[Z10_LENGTH],[Z10_TRANSITION],[Z10_ATMOSPHERE],[Z10_FAN_HP],[Z10_ATMOSPHERE_FLOW],[Z10_CONNECTED_INPUT],[Z10_THROU_METAL_AREA],");
CString sqlcmd3("[HFACE_TOP1_THICK],[HFACE_TOP1_MAT],[HFACE_TOP2_THICK],[HFACE_TOP2_MAT],[HFACE_TOP3_THICK],[HFACE_TOP3_MAT],[HFACE_TOP4_THICK],[HFACE_TOP4_MAT],[HFACE_TOP5_THICK],[HFACE_TOP5_MAT],[HFACE_side1_MAT],[HFACE_side1_THICK],[HFACE_side2_MAT],[HFACE_side2_THICK],[HFACE_side3_MAT],[HFACE_side3_THICK],[HFACE_side4_MAT],[HFACE_side4_THICK],[HFACE_side5_MAT],[HFACE_side5_THICK],[HFACE_Bottom1_MAT],[HFACE_Bottom1_THICK],[HFACE_Bottom2_MAT],[HFACE_Bottom2_THICK],[HFACE_Bottom3_MAT],[HFACE_Bottom3_THICK],[HFACE_Bottom4_MAT],[HFACE_Bottom4_THICK],[HFACE_Bottom5_MAT],[HFACE_Bottom5_THICK] FROM [CONTINUOUS_FURNACE_DB]");
sqlcmd += sqlcmd1 ;
sqlcmd += sqlcmd2;
sqlcmd += sqlcmd3;
I printed out the sqlcmd at rumtime, it's a correct SQL.
But when it came to execute the sqlcmd, it throws a rumtime error like:[Microsoft][ODBC Microsoft access driver] Too few parameters.Expected 73. What's this?
Anyway,I am so grateful that so many nice people posting here.
Thanks!
wang
CString sqlcmd1("SELECT [CONTINUOUS_FURNACE_NAME],[FURNACE_TYPE],[FURNACE_
HEATING_TYPE],[IMAGE_PATH],[CONTINUOUS_FURNACE_TYP
E],[OVERALL_W],[OVERALL_H],[WORK_SPACE_W], [WORK_SPACE_H],[ENTRY_OPENNING_AREA],[END_OPENNING
_AREA],[MUFFLE],[BELT WIDTH],[BELT_MOVING],[BELT_UNIT_WEIGHT],[FURNACE_ EFFICIENY],[BELT_RETURN],[SHELL_COOLING_WATER_RATE
],[THROU_AIR_FLOW],");
CString sqlcmd2("[ZONE_NUMBER],[Z1_LENGTH], [Z1_TRANSITION], [Z1_ATMOSPHERE], [Z1_FAN_HP],[Z1_ATMOSPHERE_FLOW],[Z1_CONNECTED_INP
UT],[Z1_THROU_METAL_AREA],[Z2_LENGTH], [Z2_TRANSITION], [Z2_ATMOSPHERE], [Z2_FAN_HP],[Z2_ATMOSPHERE_FLOW],[Z2_CONNECTED_INP
UT],[Z2_THROU_METAL_AREA],[Z3_LENGTH], [Z3_TRANSITION],[Z3_ATMOSPHERE], [Z3_FAN_HP],[Z3_ATMOSPHERE_FLOW],[Z3_CONNECTED_INP
UT],[Z3_THROU_METAL_AREA],[Z4_LENGTH], [Z4_TRANSITION], [Z4_ATMOSPHERE], [Z4_FAN_HP],[Z4_ATMOSPHERE_FLOW],[Z4_CONNECTED_INP
UT],[Z4_THROU_METAL_AREA],[Z5_LENGTH], [Z5_TRANSITION],[Z5_ATMOSPHERE], [Z5_FAN_HP],[Z5_ATMOSPHERE_FLOW],[Z5_CONNECTED_INP
UT],[Z5_THROU_METAL_AREA],[Z6_LENGTH], [Z6_TRANSITION],[Z6_ATMOSPHERE], [Z6_FAN_HP],[Z6_ATMOSPHERE_FLOW],[Z6_CONNECTED_INP
UT],[Z6_THROU_METAL_AREA],[Z7_LENGTH], [Z7_TRANSITION],[Z7_ATMOSPHERE], [Z7_FAN_HP],[Z7_ATMOSPHERE_FLOW],[Z7_CONNECTED_INP
UT],[Z7_THROU_METAL_AREA],[Z8_LENGTH], [Z8_TRANSITION],[Z8_ATMOSPHERE], [Z8_FAN_HP],[Z8_ATMOSPHERE_FLOW],[Z8_CONNECTED_INP
UT],[Z8_THROU_METAL_AREA],[Z9_LENGTH],[Z9_TRANSITI
ON],[Z9_ATMOSPHERE],[Z9_FAN_HP],[Z9_ATMOSPHERE_FLO
W],[Z9_CONNECTED_INPUT],[Z9_THROU_METAL_AREA],[Z10
_LENGTH],[Z10_TRANSITION],[Z10_ATMOSPHERE],[Z10_FA
N_HP],[Z10_ATMOSPHERE_FLOW],[Z10_CONNECTED_INPUT],
[Z10_THROU_METAL_AREA],");
CString sqlcmd3(" [HFACE_TOP1_THICK],[HFACE_TOP1_MAT],[HFACE_TOP2_TH
ICK],[HFACE_TOP2_MAT],[HFACE_TOP3_THICK],[HFACE_TO
P3_MAT],[HFACE_TOP4_THICK],[HFACE_TOP4_MAT],[HFACE
_TOP5_THICK],[HFACE_TOP5_MAT],[HFACE_side1_MAT],[H
FACE_side1_THICK],[HFACE_side2_MAT],[HFACE_side2_T
HICK],[HFACE_side3_MAT],[HFACE_side3_THICK],[HFACE
_side4_MAT],[HFACE_side4_THICK],[HFACE_side5_MAT],
[HFACE_side5_THICK],[HFACE_Bottom1_MAT],[HFACE_Bot
tom1_THICK],[HFACE_Bottom2_MAT],[HFACE_Bottom2_THI
CK],[HFACE_Bottom3_MAT],[HFACE_Bottom3_THICK],[HFA
CE_Bottom4_MAT],[HFACE_Bottom4_THICK],[HFACE_Botto
m5_MAT],[HFACE_Bottom5_THICK] FROM [CONTINUOUS_FURNACE_DB]");
sqlcmd += sqlcmd1 ;
sqlcmd += sqlcmd2;
sqlcmd += sqlcmd3;
I MessageBox the sqlcmd at rumtime, it's correct.
But when it came to execute the sqlcmd, it throws a rumtime error like:[Microsoft][ODBC Microsoft access driver] Too few parameters.Expected 73.
What's this?
Anyway,I am so grateful that so many nice people here.
Thanks!;)
You might get better help in a database forum.
You can debug SQL using Access or SQL Server.
Why didn't you post this in the thread you started earlier?
First, I would make the command easier to handle:
Note what I did. I seperated each column into a seperate line. In C and C++, you can have express a long string by breaking up the string into individual strings. This makes your code easier on the eyes, and easier to see if there is any problem with your SQL statement. It also makes this not necessary:Code:CString sqlcmd;
sqlcmd = "SELECT [CONTINUOUS_FURNACE_NAME],"
"[FURNACE_TYPE],"
"[FURNACE_HEATING_TYPE],"
"[IMAGE_PATH],"
"[CONTINUOUS_FURNACE_TYPE],"
"[OVERALL_W],"
"[OVERALL_H],"
"[WORK_SPACE_W],"
"[WORK_SPACE_H],"
"[ENTRY_OPENNING_AREA],"
"[END_OPENNING_AREA],"
"[MUFFLE],"
"[BELT WIDTH],"
"[BELT_MOVING],"
// etc.
I don't know why you did this when CString can work correctly.Code:sqlcmd += sqlcmd1 ;
sqlcmd += sqlcmd2;
sqlcmd += sqlcmd3;
Also, in your other post, you mentioned you used MessageBox to "print the query". This is not a good idea. Again, you are relying by sight to see if the SQL query is valid. It is just too large a query to really know if it will work without actually testing it. Did you test the query, not just print it out? Instead, do the following:
If you run in the debugger, the entire command will show up in the Output Window of VC++. Now copy and paste the string you see in the output window and place it into some program that accepts SQL queries (Access, SQL Server, whatever). Did the query work? If it doesn't, then you see what is wrong with the query you built, not what is wrong with CString. If it does work, then the problem is not with CString, but some other database/OBDC related issue.Code:sqlcmd = YourLongCommand;
OutputDebugString( (LPCTSTR) sqlcmd );
Regards,
Paul McKenzie
[Merged threads]
wangnanjing, please keep the same question within the same thread. Thank you very much.
Thanx for the tips guys,
Is their a difference between using OutputDebugString() and the TRACE macro?
Also is there a way to see unicode characters in the Output Window, since some queries may contain Unicode strings?
If it were me, I would look at the documentation of OutputDebugString() and the TRACE macro and if I was unsure of what the TRACE macro does I would look at the TRACE macro source to see what it does. Then if there was something in particular I did not understand I would ask something about that.Quote:
Originally posted by panayotisk
Is their a difference between using OutputDebugString() and the TRACE macro?
I sure don't understand what "difference" you are asking. Perhaps you are asking which is easier to use. The TRACE macro includes a formatting capability that you don't get if you use OutputDebugString directly, but that difference is obvious when the documentation is read.
Yes, that difference is quite obvious.Quote:
...but that difference is obvious when the documentation is read.