Page 1 of 1

runtime error on c:\hmg.3.4.4\SAMPLES\HFCL\SQL\RDD_SQL\mdb

Posted: Tue Jun 05, 2018 9:20 pm
by hmgchang
Dear Friends,

Reporting runtime error on : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\RDD_SQL\mdb
runtimeerror.JPG
runtimeerror.JPG (16.29 KiB) Viewed 2727 times
and the code :
code.JPG
code.JPG (74.5 KiB) Viewed 2727 times

Code: Select all

* RDD SQL DEMO
* Based on Harbour Compiler Contrib Samples
* Adapted for HMG by Roberto Lopez - 2009

#include "hmg.ch"

REQUEST SDDODBC, SQLMIX

#define RDDI_CONNECT          1001
 
PROC main()

	RDDSETDEFAULT( "SQLMIX" )
	SET( 4, "yyyy-mm-dd" )
	RDDINFO( RDDI_CONNECT, { "ODBC", "DBQ="  + "test.mdb;Driver={Microsoft Access Driver (*.mdb)}" } )
	DBUSEAREA( .T.,, "select * from test", "test" )

	INDEX ON FIELD->SALARY TO salary
	DBGOTOP()

	DEFINE WINDOW Win_1 ;
		ROW 0 ;
		COL 0 ;
		WIDTH 500 ;
		HEIGHT 400 ;
		TITLE 'RDD SQL' ;
		WINDOWTYPE MAIN  

		DEFINE GRID grid1
			ROW 		10
			COL 		10
			WIDTH		470			
			HEIGHT		330
			HEADERS 	{'First','Last','Salary'}
			WIDTHS		{135,135,135}
			ROWSOURCE	"TEST"
			COLUMNFIELDS	{'First','Last','Salary'}
		END GRID
		                           	
	END WINDOW

	Win_1.Center

	Win_1.Activate

RETURN   
TIA

best rgds,
Chang

Re: runtime error on c:\hmg.3.4.4\SAMPLES\HFCL\SQL\RDD_SQL\mdb

Posted: Wed Jun 06, 2018 6:22 am
by dragancesu
Are you definesd ODBC connection?

ODBC on 64-bit widnows don't work good

Re: runtime error on c:\hmg.3.4.4\SAMPLES\HFCL\SQL\RDD_SQL\mdb

Posted: Wed Jun 06, 2018 11:01 am
by mustafa
Hello Chang
View ---> viewtopic.php?f=9&t=837&p=45207#p45207

Regards
Mustafa

Re: runtime error on c:\hmg.3.4.4\SAMPLES\HFCL\SQL\RDD_SQL\mdb

Posted: Wed Jun 06, 2018 9:41 pm
by hmgchang
Thanks Dragancesu & Mustafa,

Yes, mine is win10, 64bits...

best rgds,
Chang