Jump to content

Error inserting SQL statement into FileMaker 8 via ODBC from Visual Basic 6


gblasko
 Share

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am receiving an error when trying to insert in the following SQL statement via the FileMaker ODBC Driver from within Visual Basic 6.

The SQL Insert Statement is this:

Insert INTO timer (PassingTime, TransponderID, Hits, Strength, LocationID) VALUES (44796001, 'LK-99381', 0, 0, '123')

The Table within FileMaker appears to be correct with the following setup

Table Name: timer

Field Name Type

PassingID Number - Auto enter Serial

PassingTime Number

TransponderID Text

Hits Number

Strength Number

LocationID Text

The error i receive within Visual Basic is this:

Error -2147467259 ([DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver] The statemnet contained an escape clause not supported by this database driver.)

The code within Visual Basic looks like this...

Dim cnFM As New ADODB.Connection

Dim rsPassingInfo As New ADODB.Recordset

Dim strSQL As String



strSQL = ... Build SQL Statement here....

       

    cnFM.CursorLocation = adUseClient

    cnFM.ConnectionString = "DSN=" & ProgramVar.strFMDSNName & ";Uid=" & ProgramVar.strFMUserID & ";Pwd=" & ProgramVar.strFMPasswordID & ";"

    cnFM.Open

    cnFM.CommandTimeout = 600

   

    cnFM.Excute (strSQL)

   

    cnFM.Close

    Set cnFM = Nothing



The code errors out on the cnFM.Excute (strSQL) line.



Using this same code above and with the excute statement i can run normal Select statements just fine (i.e. Select * from timer).  



The insert statement:




Insert INTO timer (PassingTime, TransponderID, Hits, Strength, LocationID) VALUES (44796001, 'LK-99381', 0, 0, '123')

Can be excuted just fine when using Microsoft Query app.

Any help would be great!

Thanks,

Greg Blasko

Edited by Guest
Link to comment
Share on other sites

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.