bonjour,
Here is a table, as described by sqlcli:
sqlcli=> \DC MISESBAS
Table "JM.MISESBAS"
| Column Name | Type | Length | Nullable | KEYPOS |
| ----------- | ------------- | ------ | -------- | ------ |
| DATEMB | DATE | 10 | YES | |
| IDANIMAL | SMALLINT | 5 | NO | |
| IDMB | SMALLINT | 5 | NO | 1 |
| NBCHEVREAUX | FIXED | 1 | NO | |
| OBS | VARCHAR ASCII | 40 | YES | |
5 rows selected (17 msec)
This morning I inserted two rows with DATEMB '20040204' and '20040205'
And used sqlcli to verify...
SELECT * FROM MISESBAS WHERE YEAR(DATEMB)=2004
oups, one row, should be two
reinserted the missing row, with my gui, and manualy. Same result. (I
did not forget to commit)
Tried:
SELECT * FROM MISESBAS WHERE IDMB=428
found the first row
then tried with 429 and upper: found my 'missing' rows, and last rows
stupidly inserted.
Then tried:
SELECT * FROM MISESBAS WHERE IDMB>128
got 5 rows, should be about 300
Then I had an idea: I named the columns and got the resultset I
expected.
?????
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
