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

Reply via email to