Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Updating FileMaker Pro SequeLink Database With Parameters

Posted on 2012-03-13
1
Medium Priority
?
480 Views
Last Modified: 2012-06-21
I'm updating a FM Pro database via the ADODB namespace. I didn't make this code originally, but it uses string concatenation in a RecordSet to update the database. Personally, I'd rather use parameters, like in SQL, because it makes the code a million times easier to read. I've had a bunch of small problems concatenating so far and it's becoming frustrating.

I looked up the documentation, which you can view here.

The specific page that explains how to do it is here. But that looks completely different from what we're doing. It doesn't look like they're using the ADODB namespace like we are.

So, from the code below, how would I add parameters? Or would I need to switch to what the documentation is using?

Dim connection As New Connection()
        Dim record_set As New Recordset
        Dim test As New Command
        connection.Open(My.Settings.FMPDSN) 'FM connection string for SequeLink
        
        record_set.Open("UPDATE Traveler SET TestResult = '1', BurnInDate = '" & record.Item("Date_Test") & "'" & " WHERE Service_Order_ID = '" & record.Item("CSO_N").ToString & "'", connection)
      
        connection.Close()

Open in new window


Thanks
0
Comment
Question by:weirddemon
1 Comment
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 1000 total points
ID: 37717728
Here are couple of examples showing use of parameters

http://support.microsoft.com/kb/195047

http://www.freevbcode.com/ShowCode.asp?ID=3687
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question