Visual Basic Q&A

As a software engineer, I focus on .NET, especially asp.net, C#, WCF and so on, and I am also very interested in Search Engine Optimization.

Entries Tagged ‘SymptomsWhen’

BUG: Font Changes After Open Stored Procedure in Data View

Symptoms
When you open a Data View Stored Procedure Design window, the font of theData View window changes to the font of the Code window.
Resolution
To restore the font, you have to exit Visual Basic and restart.

BUG: Error in CoolBar Event Can Cause Hanging or Exception

Symptoms
When using a CoolBar control, your compiled application hangs or generatesan exception error or invalid page fault (IPF.)
Resolution
An unhandled error occurred in one of the CoolBar’s Events.

BUG: DataGrid Does Not Handle Special Filter Constants Correctly

Symptoms
When the filter of an ADO Recordset object is set to one of the special constants, such as adFilterPendingRecords, the bound DataGrid control still displays all of the rows in the Recordset. If the filter is set to specify a particularfield, such as “State = ‘CA’,” the DataGrid displays only the rows that are specific to that filter.
Resolution
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

BUG: Data Control NoMatch Equals True Returns Error

Symptoms
When the NoMatch method of the Data Control returns “True,” the Seek methodwill report a run-time error “No Current Record.”
Resolution
The user can work around this problem by trapping the Data Control’s errorevent and repositioning to an existing record after the seek failure.

PRB: Exceeded Limits on Array Sizes of User Defined Types

Symptoms
When compiling code that has user-defined types containing arrays ofvariable-length strings you may get this error:

“Fixed or static data can’t be larger than 64K”
Resolution
You exceeded the data limitations of a user-defined type. As stated in theProgrammer’s Guide for Microsoft Visual Basic version 4.0:
No variable of a user-defined type can exceed 64K, though the sum ofvariable-length strings in a user-defined type may exceed 64K(variable-length strings occupy only 4 bytes in the user-defined type;the actual contents of a string are stored separately. User-definedtypes can be defined in terms of other user-defined types, but the totalaggregate size of the types cannot exceed 64K.

PRB: Error Assigning Non-Opened Recordset to ADODC

Symptoms
When you attempt to set an ActiveX Data Objects (ADO) Data Control’sRecordset object to a previously dimensioned ADO Recordset the followingerror is returned:

Run-time error ‘3704′:
The operation requested by the application is not allowed if the objectis closed.
Resolution
This error occurs when the recordset has not been opened yet.