|
Home > Archive > dBASE SQL Servers > August 2005 > Not able to locate w/ selective fields & where condition
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Not able to locate w/ selective fields & where condition
|
|
| Jun S. Pomer 2005-08-22, 11:23 am |
| Hi,
In my form there is a grid and search entry field to locate the record. It
is obvious that the record is available so it is imposible not to find the
record. If I use the selective fields and "where" condition in my query, I
cannot find it, but the strange thing is that when I search its other record
or field then it is found. I need to use where condition to filter the
rowset.
Does anybody had encountered this problem? I am using FireBird database.
Thanks.
Jun
| |
| *Lysander* 2005-08-22, 11:23 am |
| In article <OyVfw8ypFHA.1484@news-server>, jspomer@softworks.com.ph=20
says...
> Does anybody had encountered this problem? I am using FireBird database.
No, and I have not heard of such problem before.
Can you give some more details?
(structure of your sql-selection-clause and an example for the value=20
that is not found by the WHERE-clause)
=20
--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| Jun S. Pomer 2005-08-22, 11:23 am |
| Hi André
I try to use the VIEW w/ where clause, but the same thing happend.
sql = "Select ACCTNO,MID,LEGALNAME
,TRADENAME from 'VW_MAMF' WHERE
POST_APP='x' order by TRADENAME"
Thanks.
Jun
"*Lysander*" <nobody@nowhere.com> wrote in message
news:MPG. 1d74136348fe21e49898
66@news.dbase.com...
In article <OyVfw8ypFHA.1484@news-server>, jspomer@softworks.com.ph
says...
> Does anybody had encountered this problem? I am using FireBird database.
No, and I have not heard of such problem before.
Can you give some more details?
(structure of your sql-selection-clause and an example for the value
that is not found by the WHERE-clause)
--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| *Lysander* 2005-08-23, 3:23 am |
| In article <AcU4QOzpFHA.1044@news-server>, jspomer@softworks.com.ph=20
says...
> sql =3D "Select ACCTNO,MID,LEGALNAME
,TRADENAME from 'VW_MAMF' WHERE
> POST_APP=3D'x' order by TRADENAME"
1.) in a view, you can not use an ORDER BY in Firebird
if you need something like a view WITH an order by, you must use a=20
selectable stored procedure
2.) if leaving out the part "order by TRADENAME" does not solve your=20
problem, try a LIKE-CLAUSE, as this:
sql =3D "SELECT ACCTNO, MID, LEGALNAME, TRADENAME from VW_MAMF WHERE=20
POST_APP like '%x'"
Tell me about the results, please.
--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| Jun S. Pomer 2005-08-23, 7:24 am |
| Hi André
Still the same result. I 'm worried with this problem. Why only specific
field? I don't think that this field is reserved word.
Thanks.
Jun
"*Lysander*" <nobody@nowhere.com> wrote in message
news:MPG. 1d74f3ac6f00afbd9898
6a@news.dbase.com...
In article <AcU4QOzpFHA.1044@news-server>, jspomer@softworks.com.ph
says...
> sql = "Select ACCTNO,MID,LEGALNAME
,TRADENAME from 'VW_MAMF' WHERE
> POST_APP='x' order by TRADENAME"
1.) in a view, you can not use an ORDER BY in Firebird
if you need something like a view WITH an order by, you must use a
selectable stored procedure
2.) if leaving out the part "order by TRADENAME" does not solve your
problem, try a LIKE-CLAUSE, as this:
sql = "SELECT ACCTNO, MID, LEGALNAME, TRADENAME from VW_MAMF WHERE
POST_APP like '%x'"
Tell me about the results, please.
--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| *Lysander* 2005-08-23, 7:24 am |
| In article <y2LrmQ8pFHA.1876@news-server>, jspomer@softworks.com.ph=20
says...
> Still the same result. I 'm worried with this problem. Why only=20
specific
> field? I don't think that this field is reserved word.
No, it is not a reserved word.
So you tried the "WHERE Post_App LIKE '%x'" and it did not deliver ANY=20
result, although there is at least 1 record with a field-value 'x....'=20
or just 'x' in the field Post_App?
1.)=20
Can you post here the structure of the table?
2.)=20
And can you post the DDL for creating the view?
Would be especially interesting to see the field-types of the Post_App=20
field in the table and in the view. Did you by any coincidence not grant=20
the select rights on the Post_App-field to all users?
3.)=20
How many records are in the table? Do you have a tool to extract the=20
"insert into" DML statements and to put them into a txt-file and post=20
here in binaries?
I'm sure that we will find the solution, don't worry.
=20
--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| Dan Barbaria 2005-08-23, 9:23 am |
| Could it be as simple as a case issue (x vs X) ?
Dan
"Jun S. Pomer" <jspomer@softworks.com.ph> wrote in message
news:AcU4QOzpFHA.1044@news-server...
> Hi André
>
> I try to use the VIEW w/ where clause, but the same thing happend.
>
> sql = "Select ACCTNO,MID,LEGALNAME
,TRADENAME from 'VW_MAMF' WHERE
> POST_APP='x' order by TRADENAME"
>
> Thanks.
>
> Jun
| |
| Jun S. Pomer 2005-08-24, 3:23 am |
| Hi Dan,
No. It is really 'x'.
Thanks
Jun
"Dan Barbaria" <daniel.barbaria at ops.org> wrote in message
news:EGVhTJ#pFHA.1420@news-server...
> Could it be as simple as a case issue (x vs X) ?
>
> Dan
>
> "Jun S. Pomer" <jspomer@softworks.com.ph> wrote in message
> news:AcU4QOzpFHA.1044@news-server...
>
>
| |
| Jun S. Pomer 2005-08-24, 3:23 am |
| Hi André,
I will prepare the detail info. Will be back asap.
Thanks.
Jun
"*Lysander*" <nobody@nowhere.com> wrote in message
news:MPG. 1d7515e985b32cc59898
6b@news.dbase.com...
In article <y2LrmQ8pFHA.1876@news-server>, jspomer@softworks.com.ph
says...
> Still the same result. I 'm worried with this problem. Why only
specific
> field? I don't think that this field is reserved word.
No, it is not a reserved word.
So you tried the "WHERE Post_App LIKE '%x'" and it did not deliver ANY
result, although there is at least 1 record with a field-value 'x....'
or just 'x' in the field Post_App?
1.)
Can you post here the structure of the table?
2.)
And can you post the DDL for creating the view?
Would be especially interesting to see the field-types of the Post_App
field in the table and in the view. Did you by any coincidence not grant
the select rights on the Post_App-field to all users?
3.)
How many records are in the table? Do you have a tool to extract the
"insert into" DML statements and to put them into a txt-file and post
here in binaries?
I'm sure that we will find the solution, don't worry.
--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
|
|
|
|
|