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!

Register Log in
  • Congratulations strongm 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. Andy7777

    Speed optimiztion

    Hi, the help on the advanced optimizations tab is helpful. If your app does not require this stuff then try it. However, I'd always favour safety over speed.
  2. Andy7777

    Stored Procedures and command buttons

    Hi, not too sure what you want to do. Can you give us some more details?
  3. Andy7777

    Table Update

    Thanks, that works fine.
  4. Andy7777

    Table Update

    Hi Turkbear, Thanks, but I still get error ORA-01407 cannot update MaxStock to Null (I know there are no Null values in either table).
  5. Andy7777

    Table Update

    Hi, I'm an Oracle novice so any help is appreciated. I have 2 tables with fields shown below: MASTER TEMP PartNumber PartNumber MaxStock MaxStock other fields calculation fields TEMP contains a subset of parts from MASTER and I want to update the MaxStock in MASTER with the...
  6. Andy7777

    Using CAST to return Integer from SmallDateTime

    swampBoogie, Thanks for your help. I can work around it but it's not what you'd expect. Andy.
  7. Andy7777

    Using CAST to return Integer from SmallDateTime

    Also, CAST(DateTime AS INT) gives 37826 CAST(DateTime AS REAL) gives 37825.508 CAST(CAST(DateTime AS REAL) AS INT) gives 37825 DateTime = '2003-07-25 12:09:00' Why is variable to INT different from variable to REAL to INT?
  8. Andy7777

    Using CAST to return Integer from SmallDateTime

    Hi, I need to convert dates in SmallDateTime format into Intergers. When I use CAST on '25/07/2003 11.26', SQL Server returns 37825. However, Excel spreadsheet returns 37827 when I format the date. CAST through SQL Server is exactly 2 less than Excel (even when using floating point...
  9. Andy7777

    Error using ADO to Update Excel Spreadsheet

    Hi, I am using VB6 to manipulate data in an Excel Spreadsheet. If the Spreadsheet is open in Excel then I can open a Schema to view the fields (column names) OK, but if I try to create a new table (shown as a worksheet) using SQL then I get dumped out of VB with a "..tried to access...
  10. Andy7777

    Select query with Parameters

    Fazul, In VB, the code could look something like this: Dim strCity as String Dim strSQL as String strCity = Text1.text strSQL = "SELECT * FROM add WHERE City = '" & strCity & "'" cnnADO.Execute strSQL 'cnnADO is your ADO connection As City is a string, the parameter...
  11. Andy7777

    SQL-CREATE TABLE> list of datatypes for dBase, Paradox, Sql Server

    Hi, I have writen a VB app (uses ADO 2.6) that connects to various databases and spreadsheets and creates tables within them. It currently works with Access, Excel and SQL Server but I also need to connect to dBase, Paradox, Lotus123, Oracle and text files. Depending on the...

Part and Inventory Search

Back
Top