Re: MS SQL

>>> Hi Rodney, >>> >>> i am using the Actualtech ODBC driver with Microsoft SQL server without >>> problems. >>> Just to be sure that there are no problems with newer versions of LC i did >>> a quick test right now with one of my proje

Re: MS SQL

did >> a quick test right now with one of my projects with LC 6.7.0DP2, >> Actualtech ODBC driver version 3.2.3 and MS SQL Server 2005 and 2008. >> My select query is about 70 lines contains several case statements with >> several replace statements and several joins. All is

Re: MS SQL

ualtech ODBC driver version 3.2.3 and MS SQL Server 2005 and 2008. > My select query is about 70 lines contains several case statements with > several replace statements and several joins. All is working as expected > even over VPN. > > Regards, > > Matthias > > > &g

Re: MS SQL

Hi Rodney, i am using the Actualtech ODBC driver with Microsoft SQL server without problems. Just to be sure that there are no problems with newer versions of LC i did a quick test right now with one of my projects with LC 6.7.0DP2, Actualtech ODBC driver version 3.2.3 and MS SQL Server 2005

Re: MS SQL

On Thu, Apr 24, 2014 at 3:51 PM, Rodney Green wrote: > I'm curious, does anyone have a project that uses the revDataFromQuery() > command? > Yes, but I use it with SQLite and Postgres (and used it briefly with mySQL). But I'm old enough that I'd never consider using an MS database. -- Dr. Ri

Re: MS SQL

Just a heads up, remember that SQL servers have a timeout on connections, so when you open a database, remember to close it after you are done. If it has been idle for any length of time, Livecode still thinks it is open, but the SQL server has probably terminated the connection. This has reso

Re: MS SQL

Oh THAT is what does that! I usually just convert the email to plain text before posting to the list. Maybe a good practice for all? Bob S On Apr 22, 2014, at 7:34 PM, J. Landman Gay wrote: > On 4/22/14, 6:49 PM, Kay C Lan wrote: >> I don't know if it's just your email client but what I'm se

Re: MS SQL

I use revDataFromQuery all the time, but it's to access a local (to the app) sqlite DB. Works great with SQLite I also use MS SQL Server, but only access it via custom web services. I have never had any luck connecting to it otherwise. I've heard good things about the Actual Drivers,

re: MS SQL

Auto speller typo correction : read dbRecordSets["menu_r1"] instead of dbRecordSets[" menu_r1"] > I use it all the time in most of my projects running in a > LC-Server+PostgreSQL+RevIgniter+JQuery context (no experimented against MS > SQL Server at all, sorry).

Re: MS SQL

I use it all the time in most of my projects running in a LC-Server+PostgreSQL+RevIgniter+JQuery context (no experimented against MS SQL Server at all, sorry). See below for a daily working example witch builds on the fly an HTML5/JQuery multi-hierarchical pulldown menu : >

Re: MS SQL

I'm sure there are many people who use revDataFromQuery, less so the ODBC driver you mentioned. If that ODBC driver works in Navicat, then it seems the finger is pointing at some problem between Livecode and the ODBC driver. I think you said you'd enetered a bug report so hopefully it will get re

Re: MS SQL

I'm curious, does anyone have a project that uses the revDataFromQuery() command? And does anyone use the Actual Technologies ODBC driver? On Thu, Apr 24, 2014 at 9:23 AM, Rodney Green wrote: > I'll put in a bug report for this. Does anyone have any kind of > work-around for this? Have there bee

Re: MS SQL

I'll put in a bug report for this. Does anyone have any kind of work-around for this? Have there been any updates to database in the developer previews? Maybe I'll give a DP a try. On Wed, Apr 23, 2014 at 7:53 PM, Rodney Green wrote: > I tried it in 6.6 and 6.6.1. I'm using Actual Technologies O

Re: MS SQL

I tried it in 6.6 and 6.6.1. I'm using Actual Technologies ODBC manager (demo). And I can connect successfully to the SQL server with Navicat. I'm on a Mac (10.9.2) and connecting via a VPN. On Wed, Apr 23, 2014 at 7:17 PM, Peter Haworth wrote: > That seems strange - I wouldn't expect to see fi

Re: MS SQL

That seems strange - I wouldn't expect to see field names, just the data in them. What version of LC are you using? Might be time to enter a bug report. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: MS SQL

I turned on tracing in the odbc driver and I can see field names in the data. So I'm assuming the query is working. But still can't figure out why LC is hanging. I have database checked in the stand alone settings, not sure if this matters while in LC. Any ideas how I can track down why LC is hangi

Re: MS SQL

In gmail, you can fix that by using the "Paste and match style" option on the edit menu. Pete lcSQL Software On Apr 22, 2014 7:34 PM, "J. Landman Gay" wrote: > On 4/22/14, 6:49 PM, Kay C Lan wrote: > >> I don't know if it's just your email client but what I'm seeing is an >> asterisk * around th

Re: MS SQL

On 4/22/14, 6:49 PM, Kay C Lan wrote: I don't know if it's just your email client but what I'm seeing is an asterisk * around the words get, put and return which shouldn't be there. That happens to all keywords when a colorized script is copied from the script editor and pasted into a text-onl

Re: MS SQL

It still hangs after I changed the line of code. Here's the entire script for the button. Also, this is a MS SQL server. Thanks again. *on* mouseUp *local* tDatabaseID *local* xQuery *local* rez *put* "Driver={Actual SQL Server};Server=xxx.xxx.x.x;Database=AT2005_P

Re: MS SQL

exactly what's wrong. The most basic query should look like this: put revDataFromQuery(,,tDatabaseID,"SELECT * FROM Rep_Offices") into fld"results" HTH On Wed, Apr 23, 2014 at 2:40 AM, Rodney Green wrote: > Hello, > > It's my first time using LC and

MS SQL

Hello, It's my first time using LC and MS SQL in a project. I can connect and receive a connection ID. However, I can't seem to pass any SQL commands. I try this: *get* revDataFromQuery(tab,*return*,tDatabaseID,"select top 3 * from [dbo].[Rep_Offices]") or this: *put*