The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

xQL Edits - DB.xql


  • Subject: xQL Edits - DB.xql
  • From: "Neil Frost" <neil@xxxxxxxxxxxxx>
  • Date: Fri, 25 Feb 2005 11:14:45 -0000


Hi,



Been trying to get xQL to edit my MS Sql tables for the telephone calls.



The problem I was getting, was the incoming calls would be added but not
the answered time and the complete time.

On Outgoing calls the fact that a call was made and the time of it was
recorded but not the number.



Worked it out that the edit's were not working. Had a quick look around and
it seems that SQL uses the "update" command instead of
"edit".

Changed my meteor (or JohnB's) script to use update instead of edit but it
still didn't work.



Looking at the schema for DB.XQL it doesn't support the command update.



Is there anyway to change this at all so that xQL can update SQL instead of
just adding, please....



Thanks as always....



Neil



[Non-text portions of this message have been removed]



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx

xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.