Results 1 to 2 of 2

Thread: Tornado- Full Screen Edit, Update Problems

  1. 04-29-2004, 06:47 AM #1
    paul mancuso
    paul mancuso is offline Registered User
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115

    Tornado- Full Screen Edit, Update Problems

    Frank,

    When trying to update in full screen mode the following error is generated:

    (312 : 7) Error
    System.Data.OleDb.OleDbException: Incorrect syntax near the keyword 'WHERE'. at System.Data.OleDb.OleDbDataReader.NextResults(IMul tipleResults imultipleResults, OleDbConnection connection, OleDbCommand command) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Tornado.RS_OleDB.Execute_SQLs(String which, String sql, Int32 recs, Int64& LRecs)

    (313 : 7) Error
    Edit SQL = UPDATE mpoPhase SET WHERE (RecordID=11 AND MPOPin='000611')

    As you can see there are no column names and expressions following the SET clause. I'm not using .dbEditUpdateSQL
    so this is Tornados construction of the UPDATE clause.

    How do I fix this so my app updates multiple records?
    Reply With Quote Reply With Quote
  2. 05-01-2004, 10:51 PM #2
    Frank
    Frank is offline Registered User
    Join Date
    Oct 2002
    Posts
    933
    Yes, typos in a few places - will send you the corrected example file and DLL.

    FK
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules