on 29/4/01 23:36, Vincent MERCEY at vmercey /at/ noos DO.T fr wrote:
> Thanks for your previous answer.
>
> Sorry, do not take me for a stupid boy but when I do that :
>
> (in the constructor)
> mYear= new VString( "theYear", 30,-16 ) 'kV_IsMethod
>
> I create a new database from scratch
>
>
> (in the searching method)
> theTable.mYear.SetMethod( "Year(DateNaissance)" )
I thin mistake is that you must assign Method text right after constructor,
BEFORE you create field:
mYear= new VString( "theYear", 30,-16 ) 'kV_IsMethod
mYear.SetMethod( "Year(DateNaissance)"
so Valentina will know that this is Method but not real field.
You can use any text of empty, never mind
and change it later when you need.
> crsr = SQLSelect("SELECT RecID,Nom,Prenom FROM theTable WHERE theYear
> = 1958")
>
> I am sure there is a record (database has only 1 record) with a DateTime
> value set to a date in 1958.
> I do not get any result (crsr.recordCount = 0).
>
> What is wrong with my code ?
>
> --
> Vincent MERCEY
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on /at/ lists DO.T macserve.net
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Ruslan Zasukhin |
