[Feedback request] New docs for dbLib

2019-04-29 Thread Andre Garzia via use-livecode
Hey Friends, I've been working on a new release for dbLib for a while and part of it is producing better documentation. Even though it is not yet complete, I think that the new documentation is good and it might already be valuable for people here as it applies to the current release.

Re: dBLib

2014-09-12 Thread Dave Kilroy
I've used dbLib with a Firebird db to pull in data from a table where the date field used a "-mm-dd" format, and as long as I made sure to follow this format there was no problem: dbWhere "CREATEDATE >", tDate --other statements building the SELECT statemen

Re: dBLib

2014-09-12 Thread Peter Haworth
On Fri, Sep 12, 2014 at 9:50 AM, Terence Heaford wrote: > put merge("select sum(amountColumn) as totalValue from amountColumn where > amountColumn < 0 and date >= [[tStartDate]] and date <= [[tEndDate]]") into > tSQL Not sure if dbLib supports it but you could use

Re: dBLib

2014-09-12 Thread Terence Heaford
Thanks, I’m sure the author IS smart enough. ;) Also, tryng to increase your workload. I have been using an existing stack of mine to evaluate dBLib which totals columns like this: put merge("select sum(amountColumn) as totalValue from amountColumn where amountColumn < 0

Re: dBLib

2014-09-12 Thread Andre Garzia
> May have found the answer in the following handler in dbLib. > > I have commented out an “if” test that seems to overwrite the contents of > the column dbWhere when you try and add another condition. > > Why the author did this, I am not sure, would anyone care to hazard a > g

Re: dBLib

2014-09-11 Thread Terence Heaford
May have found the answer in the following handler in dbLib. I have commented out an “if” test that seems to overwrite the contents of the column dbWhere when you try and add another condition. Why the author did this, I am not sure, would anyone care to hazard a guess? Thanks Terry

dBLib

2014-09-11 Thread Terence Heaford
Thought I’d give this plugin a try: convert tStartDate from short system date to seconds convert tEndDate from short system date to seconds dbResetQuery dbWhere "category", pItemName dbWhere "date >=", tStartDate dbWhere "date <=", tEndDate dbOrderBy “date" put dbGet(sq(tTa

Re: Valentina DB, SQLite and DBLib

2013-07-02 Thread Ruslan Zasukhin
On 7/2/13 4:14 PM, "Mike Kerner" wrote: > The easiest way to try to do this (i.e. enforcing referential integrity, > maintain related tables, etc.), is to use triggers. You have to tell the > DB what to do. Even RDBMS's (4D is one I use all the time that comes to > mind) can't read your mind, b

Re: Valentina DB, SQLite and DBLib

2013-07-02 Thread Ruslan Zasukhin
only with 4-5 columns each, the others will be > much smaller. > > I started to write my app using DBLib which works very nicely. I > assumed that I have to handle the table-relations (update several > fields in several tables if necessary) myself and remember to write > the data

Re: Valentina DB, SQLite and DBLib

2013-07-02 Thread Mike Kerner
f the tables will have a row added every > 15 or 30 minutes, but only with 4-5 columns each, the others will be > much smaller. > > I started to write my app using DBLib which works very nicely. I > assumed that I have to handle the table-relations (update several > fields in sever

Valentina DB, SQLite and DBLib

2013-07-02 Thread Pascal Lehner
using DBLib which works very nicely. I assumed that I have to handle the table-relations (update several fields in several tables if necessary) myself and remember to write the data everywhere where it is required. I installed Valentina Studio yesterday and see that Valentina actually can handle

Re: [BEGINNER] Using DBLib and MySQL

2013-05-22 Thread Shawn Blc
I get an error on that line: *put* dbInsert("names", tDataA) into tResult Going to register now on your forum. On Wed, May 22, 2013 at 8:21 AM, Shawn Blc wrote: > Thank you Andre. I'll start posting my related questions on your forum. > I'll give that a shot and update you. Thank you for

Re: [BEGINNER] Using DBLib and MySQL

2013-05-22 Thread Shawn Blc
Thank you Andre. I'll start posting my related questions on your forum. I'll give that a shot and update you. Thank you for the quick response! On Wed, May 22, 2013 at 8:19 AM, Andre Garzia wrote: > On Wed, May 22, 2013 at 10:06 AM, Shawn Blc > wrote: > > > put dbInsert["names", tDataA] in

Re: [BEGINNER] Using DBLib and MySQL

2013-05-22 Thread Andre Garzia
On Wed, May 22, 2013 at 10:06 AM, Shawn Blc wrote: > put dbInsert["names", tDataA] into tResult Shawn, You are using brackets instead of parenthesis. It should read: put dbInsert("names", tDataA) into tResult Also the best place to ask for DB Lib related help is on my forum at http://andre

[BEGINNER] Using DBLib and MySQL

2013-05-22 Thread Shawn Blc
I'm using DBLib and I'm having trouble inserting into a MySQL database. My database connection is working. My database name: names Table name: names My table fields are: fldID fldFullName fldEmailAddress fldRegistered My controls on my form are: fldFullName fldEmailAddress fld