var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to use temp table with vb data control
I have a temp table created via ADO in vb6, & want to set the record source of an ADO Data control to point to this file.
I have set the record string for the data control, at design time, to point to tempdb & at run time set the record source to the temp table:
Me.Adodc1.CommandType = adCmdText
strSql = "select * from #GridData "
Me.Adodc1.RecordSource = strSql
when I define this as the source for a data grid:
Set Me.TDBGrid1.DataSource = Me.Adodc1
I get the error: Invalid object name '#GridData'
Any advice out there on how I should be doing this?
(I have had this working for permanent files)