Re: ODBC and SQL string length

Group,

	the 255 character limitiation that i was getting is specific to
	EXCEL's ODBC call level interface from VBA, the workaround from
	microsoft is to use arrays of strings to go beyond the 255 characters
	per string limit.

	dim y(10) as string
	y(1) = "select * "
	y(2) = "from mytable where myconstraints = 'blah'"
	y(3) = " group by problem_space"
	? SQLExecQuery (connectionnum:=connection, querytext:=y)

	thanks to all that responded.

Scott Hissam
Unisys Corporation
hissam_at_source.asset.com Received on Thu May 26 1994 - 19:01:46 CEST