|
|
 | | From: | Erich Zippel | | Subject: | Local SQL: Where Like | | Date: | Sun, 12 Dec 2004 11:07:49 +0100 |
|
|
 | I get dbase Internal-Error Messages and GPF when using a select with 'where
xx like '%y'
in my applications when switching from 2.21 to 2.5.
As I up to now could not track down the problem to some simple publishable
file, I just
wanted to run the question against the newsgroup in case I missed something
obvious.
(The next steps tend to be tedious, as also have to stop and restart the app
to see full effect
and I will have to corne the problem in a deep nest of classes.)
At least there is nothing similar in the QAID.
What I could establish up to now.
It hapens with the query in the .wfm contains any LIKE clause, but not for
every such form,
although de are derived from the same classes and apperently consist of the
same code.
It does only happen, when using my design.cfm.
The later calls some general features in several .cc like a index selector
and Autotype seeker
and so on. Several of those components seem to be offending individually
although they appernently are not at all similar (Autotypeseeker, a
dropdown loaded with predefined filters from a table, a dropdown loading
existing files for reports, a requery for a LIKE search [my
initial source of problem] all of them already when loading the form and not
while using.
I already ruled out any mismatch/inconsistencies in the ´'"'-section.
Erich Zippel
|
|
| | From: | Howard Mintzer | | Subject: | Re: Local SQL: Where Like | | Date: | Sun, 12 Dec 2004 09:55:50 -0500 |
|
|
| Erich,
I use the following 2 lines in one of my forms
cFilter = Upper(Trim( This.Value ))
q.sql := [select * From services where Upper(services."svc_name") LIKE
"%]+cFilter+[%"]
and I just tested it with ver 2.5 and i don't get any crashes.
Sorry, wish i could help more...probably its another peice of your code
that causes the problem.
Erich Zippel wrote:
>I get dbase Internal-Error Messages and GPF when using a select with 'where
>xx like '%y'
>in my applications when switching from 2.21 to 2.5.
>
>As I up to now could not track down the problem to some simple publishable
>file, I just
>wanted to run the question against the newsgroup in case I missed something
>obvious.
>(The next steps tend to be tedious, as also have to stop and restart the app
>to see full effect
>and I will have to corne the problem in a deep nest of classes.)
>At least there is nothing similar in the QAID.
>
>What I could establish up to now.
>It hapens with the query in the .wfm contains any LIKE clause, but not for
>every such form,
>although de are derived from the same classes and apperently consist of the
>same code.
>It does only happen, when using my design.cfm.
>The later calls some general features in several .cc like a index selector
>and Autotype seeker
>and so on. Several of those components seem to be offending individually
>although they appernently are not at all similar (Autotypeseeker, a
>dropdown loaded with predefined filters from a table, a dropdown loading
>existing files for reports, a requery for a LIKE search [my
>initial source of problem] all of them already when loading the form and not
>while using.
>I already ruled out any mismatch/inconsistencies in the ´'"'-section.
>
>Erich Zippel
>
>
>
>
|
|
| | From: | Erich Zippel | | Subject: | Re: Local SQL: Where Like | | Date: | Sun, 19 Dec 2004 07:56:16 +0100 |
|
|
| Thanks Howard,
I was afraid it would be. Jus wanted to check for any known problems before
digging deep, deep, deep.
Erich
"Howard Mintzer" schrieb im Newsbeitrag
news:x5pcttF4EHA.1732@news-server...
> Erich,
> I use the following 2 lines in one of my forms
>
> cFilter = Upper(Trim( This.Value ))
> q.sql := [select * From services where Upper(services."svc_name") LIKE
> "%]+cFilter+[%"]
>
> and I just tested it with ver 2.5 and i don't get any crashes.
>
> Sorry, wish i could help more...probably its another peice of your code
> that causes the problem.
>
> Erich Zippel wrote:
>
>>I get dbase Internal-Error Messages and GPF when using a select with
>>'where xx like '%y'
>>in my applications when switching from 2.21 to 2.5.
>>
....
>>
>>Erich Zippel
>>
>>
|
|
| | From: | Judith Bai | | Subject: | Re: Local SQL: Where Like | | Date: | Mon, 13 Dec 2004 09:36:00 -0500 |
|
|
| Erich Zippel Wrote:
> I get dbase Internal-Error Messages and GPF when using a select with 'where
> xx like '%y'
> in my applications when switching from 2.21 to 2.5.
>
Erich,
When I see this kind of behavior, I usually recompile all the object files. I do it with C++ .obj, but it applies to dBL .obj files as well. I know it's not easy when having plenty of source files. but it may be the only way to solve this problem.
Judith Bai
dBI
|
|
|
