hi,
The result of my request SQL is different according to the place of
columns in the request.
It is normal?
-> GOOD RESULT:
SELECT Vrate,Pvalue FROM
Fam_Price_TypSal_TypPrice,
Fam_Vat_TypVat_TypSal,
price,typsalle,family,vat,typprice,typvat
WHERE snom=salle
-> BAD RESULT:
SELECT Vrate,Pvalue FROM
Fam_Price_TypSal_TypPrice,
Fam_Vat_TypVat_typSal,
price,family,typsalle,vat,typprice,typvat
WHERE snom=salle
The only difference is that " typSalle " and "family" were inverted.
In the first case, I indeed have a good result with all the lines. In
the second case, I have only the first line.
----------------
DATABASE
----------------
Bo Family
- colonne FName (vstring)
Bo Price
- colonne Pval (float)
Bo VAT
- Vname (vstring)
- Vrate (float)
Bo TypPrice
- Rname (vstring)
Bo TypSalle
- Sname (vstring)
Bo TypVAT
- Wname (vstring)
Bo Fam_Price_TypSal_TypPrice
- FamPtr (Family Ptr)
- PricePtr
- TypPricePtr
- TypSalPtr
Bo Fam_Vat_TypVat_TypSal
- FamPtr
- VatPtr
- TypSalPtr
- TypVatPtr
I can send you the file vdb (84 ko) and data (2.9Mo)
Thank you very much.
olivier
_______________________________________________
Valentina mailing list
Valentina /AT/ lists D.OT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 olivier |
