Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. avanderlaan

    Question mark in corner of frame's client area

    A "question mark" icon (?) just appeared in the corner of the client area of a frame, just below the menu bar. The item shows up in both the designer IDE and in the compiled application. Can anyone tell me what this is and how to get rid of it? Thanx.
  2. avanderlaan

    Database comparison tools?

    Any recommendations for database comparison tools (schema, data, etc.) for DB/2? I'm asking about tools similar to Red-Gate SQL Compaer/SQL Data Compare for SQL Server.
  3. avanderlaan

    Import data to SQL Server from Access 1.1

    I'm sorry if this is not the appropriate forum. If so, please redirect me. I have been given custody of several MDB files. They were created with Access 1.1 which is not present anywhere on our corporate network. The original UI application front-end was written in VB3 and there is no source...
  4. avanderlaan

    'Item' could not be loaded

    The message '' could not be loaded has just started appearing after recompilation of an existing OCX. MSDN Help brings up the message line in the subject, but the 'Item' portion is blank. Code changes were tested by adding a form to the OCX project. After debugging the form was removed from the...
  5. avanderlaan

    Create an editable form using only the Adobe SDK?

    Is it possible to programatically (C++) create an editable form using only the Adobe SDK? If so, what keywords should I use to search the Adobe site & documentation. Thank you.
  6. avanderlaan

    Capture Required OCX versions at Runtime?

    Is there a way to capture the required OCX versions for an application at runtime? I am referring to the "Object" CLSID / Versions at the head of the main form when viewed with something like Notepad. Thanx.
  7. avanderlaan

    Remote Enterprise Manager functions?

    I am working on a transition plan to move a database from development to a production environment maintained by the IT department. Once the db has been moved to IT, there will be no physical access to the server. Because of an ongoing need to correct typos and data entry errors, there is a...
  8. avanderlaan

    Comparing ANSI 'string' with data returned in long varchar

    I need to compare data coming from a serial port returned by a COM object as a VARIANT array of bytes with data stored in a long varchar column in SQL Server. When I return the data in an ADO recordset and compare it with the serial data in C++ the data is identical. When I return the array of...
  9. avanderlaan

    Need Syntax Help Writing Constraint/Rule

    I have a table with the following columns -- workOrderId int, -- serialNumber char(20), -- other columns... I would like to impose a constraint on the above-named columns such that either 1) the combination workOrderId/serialNumber is UNIQUE, -or- 2) the serialNumber string must be empty. Is...
  10. avanderlaan

    Missing Output parameters from stored procedure

    I am trying to get some return values from a stored procedure but they come back empty. Can someone tell me where I went wrong? The parameters are in the cmd but are empty upon return. The stored procedure executes correctly, ignoring that there is no output. Thank you. ======== Calling code...
  11. avanderlaan

    Values of Identity column after table is recreated?

    If a populated table with an identity column as the primary key is dropped and then recreated, do the identity values reset to the seed value or do they resume based upon values in the old table? Thanx.
  12. avanderlaan

    VB Exe fails in ADO connect to AS400 w/ 80004005

    I have a VB app that is &quot;well-behaved&quot; when running in the Visual Studio IDE. It connects to the AS/400 w/0 problems. When run as a standalone executable, the &quot;Execute(<sql string>)&quot; method against the open connection returns the error 80004005 (&quot;Unspecified error&quot;)...
  13. avanderlaan

    VB Exe fails in ADO connect to AS400 w/ 80004005

    I have a VB app that is &quot;well-behaved&quot; when running in the Visual Studio IDE. It connects to the AS/400 w/0 problems. When run as a standalone executable, the &quot;Open()&quot; method returns the error 80004005 (&quot;Unspecified error&quot;) from provider=source. The VB installation...
  14. avanderlaan

    Error trying to add user-defined type to Dictionary object

    I have the following declarations: ' in module.bas Type StdsDocument lDocId As Long szDocumentNumber As String szDocumentRevision As String szDocumentName As String End Type ' in a form Dim documentDictionary As Dictionary and am trying to execute documentDictionary.Add...
  15. avanderlaan

    Function like &quot;sprintf&quot; for formatting numeric output

    I'm looking for a function like &quot;sprintf&quot; in C that creates string representations of numeric values according to a user-defined specification. For example floating point: sprintf( string, &quot;%1.5f&quot;, aFloat ) produces &quot;.12345&quot; where aFloat = 0.123451234512345...
  16. avanderlaan

    Best way to convert 1M+ row ACCESS db to SQL?

    I am looking for recommendations on the best way to convert a large ACCESS db (> 1 million rows) to an industrial strength relational engine (DB2 or SQL Server 2000). The front end is already VB. Cutover can be done when the lab facility is not working (weekend), so one-time performance may not...

Part and Inventory Search

Back
Top