Em 28/2/2010 20:54, Viktor Szakáts escreveu:
What is the bug?
Return of function dbstruct()
DB struct: {{"F", "C", 20, 0}, {"L", "C", 20, 0}, {"S", "C", 30, 0},
{"C", "C",
30, 0}, {"S", "C", 2, 0}, {"Z", "C", 10, 0}, {"H", "@", 19, 0}, {"M",
"L", 1, 0}
, {"A", "I", 10, 0}, {"S", "I", 10, 0}, {"N", "C", 70, 0}}
The corret db struct is:
DB struct: {{"First", "C", 20, 0}, {"Last", "C", 20, 0},
{"Street","C",30, 0}, {"City", "C",30, 0}, {"State", "C", 2, 0}, {"Zip",
"C", 10, 0}, {"Hiredate", "@", 19, 0}, {"Married", "L", 1, 0}
, {"Age", "I", 10, 0}, {"Salary", "I", 10, 0}, {"Note", "C", 70, 0}}
best regards,
Itamar M. Lins Jr.
Brgds,
Viktor
On 2010 Mar 1, at 00:47, Itamar Lins wrote:
Hi!
/*
* $Id: test1.prg 12948 2009-11-20 12:45:41Z vszakats $
*/
#include "hbrddsql.ch"
REQUEST SDDODBC, SQLMIX
PROC main()
RDDSETDEFAULT( "SQLMIX" )
SET( _SET_DATEFORMAT, "yyyy-mm-dd" )
? "Connect:", RDDINFO( RDDI_CONNECT, { "ODBC", "DBQ=" + hb_DirBase() +
"\..\..\..\hbodbc\tests\test.mdb;Driver={Microsoft Access Driver (*.mdb)}" } )
? "Use:", DBUSEAREA( .T.,, "select * from test", "test" )
? "Alias:", ALIAS()
? "DB struct:", HB_VALTOEXP( DBSTRUCT() )
INKEY( 0 )
BROWSE()
INDEX ON FIELD->SALARY TO salary // problem in this line
DBGOTOP()
BROWSE()
DBCLOSEAREA()
RETURN
Return of function dbstruct()
DB struct: {{"F", "C", 20, 0}, {"L", "C", 20, 0}, {"S", "C", 30, 0}, {"C", "C",
30, 0}, {"S", "C", 2, 0}, {"Z", "C", 10, 0}, {"H", "@", 19, 0}, {"M", "L", 1, 0}
, {"A", "I", 10, 0}, {"S", "I", 10, 0}, {"N", "C", 70, 0}}
Best regards,
Itamar M. Lins Jr.
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour