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.
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo