I am going to build an app, that ideally would be able to query an SQL database for some data, specifically its a Microsoft SQL database (ugh, I know but I have no control over that). Is it possible to perform the query without using any plug ins or third party apps? How would I go about making that query, generally. Can anyone give any examples or just suggest and basic concept of how it would work?
I don’t have SQL experience but understand its basic concepts, I do have Filemaker experience.
I don’t know about SQL, but I have put together a few Studio apps using MySQL, and all you need to do is learn the command line instructions that access the SQL database without opening the database, and use those commands in a do shell script in your AS Studio project. For instance, in one of my projects, I use this handler to extract song titles from a music database table:
on FindTitle(search_string)
set sti to paragraphs of (do shell script ("/usr/local/mysql/bin/mysql -u root " & " -D " & "'dvd2sql'" & " -N -e \"" & "SELECT song_title from main where song_title like " & search_string & "\""))
end FindTitle
I don’t know if your MS SQL uses similar syntax, but if you search mysql here at MacScripter, you will find a few more threads on this subject that may help.