MS SQL

Pierre Sahores sc at sahores-conseil.com
Thu Apr 24 21:29:01 EDT 2014


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 :

>   put revDataFromQuery(tab, return, myDatabaseID, "SELECT p.product_id, c.category_id, d.department_id, p.name AS product_name, c.name_ascii127 AS category_name," && \
>                "d.name_ascii127 AS department_name, d.rank AS department_rank, c.rank AS category_rank, c.name AS category_title, d.name AS department_title" && \
>                "FROM" && gData["product_dbtable"] && "p INNER JOIN" && gData["product_category_dbtable"] && \
>                "pc on p.product_id = pc.product_id INNER JOIN" && gData["category_dbtable"] && "c on pc.category_id = c.category_id" && \
>                "INNER JOIN" && gData["department_dbtable"] && "d on c.department_id = d.department_id ORDER BY department_name, category_name, product_name") into dbRecordSets[" menu_r1"]

Best,

Pierre

Le 25 avr. 2014 à 00:51, Rodney Green <green.rodney at gmail.com> a écrit :

> 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 <green.rodney at gmail.com>wrote:
> 
>> 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 <green.rodney at gmail.com>wrote:
>> 
>>> 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 <pete at lcsql.com> wrote:
>>> 
>>>> 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 <http://www.lcsql.com>
>>>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>>>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>>>> 
>>>> 
>>>> On Wed, Apr 23, 2014 at 2:47 PM, Rodney Green <green.rodney at gmail.com
>>>>> wrote:
>>>> 
>>>>> 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
>>>>> hanging?
>>>>> 
>>>>> 
>>>>> On Wed, Apr 23, 2014 at 10:13 AM, Peter Haworth <pete at lcsql.com>
>>>> wrote:
>>>>> 
>>>>>> 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" <jacque at hyperactivesw.com>
>>>>>> 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 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-only email list. I see it
>>>> here all
>>>>>> the
>>>>>>> time.
>>>>>>> 
>>>>>>> --
>>>>>>> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
>>>>>>> HyperActive Software           |     http://www.hyperactivesw.com
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>> use-livecode mailing list
>>>>>>> use-livecode at lists.runrev.com
>>>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>>>> subscription preferences:
>>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>>>> 
>>>>>> _______________________________________________
>>>>>> use-livecode mailing list
>>>>>> use-livecode at lists.runrev.com
>>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>>> subscription preferences:
>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>>> 
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>>> subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>> 
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>> 
>>> 
>>> 
>> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com





More information about the Use-livecode mailing list